Google-sheets – Who has invited somebody, when and how to a Google Drive Spreadsheet

There is no way to change the link of a file in Google Drive, but you could create set expirations dates. For details see Set expiration dates for access to Google Drive, Docs, Sheets, and Slides files

If you are using Google Apps for Work or other similar edition, share your files with people from the same domain, so when their accounts get suspended, they will lose the access to the files.

If you are using a consumer account, create a Google Groups group, add the people that you want to give access to the files as members, and share the files to the group's email address. Then, when someone leave the organization, remove that member from the group.

Another alternative is create a copy of the file which will have a new link, then you could unshare the old file.

Note: The copy will not include the change/version history and comments from the original.

This should do what you are looking for:

When you open your spreadsheet go to tools --> script editor and you can copy/paste the code below.

Refresh the spreadsheet and you will have a new menu item at the far left called GMail, opening this menu will give you the ability to click on "Count Labels." Doing so will run the script.

This will go through your inbox and for every label applied create a new row on a tab called "priorities" which will have the label name and the count of the emails which have that specific tag assigned to them. From that tab you can reference the table in any way you'd like.

function label_count() {

  var labels = GmailApp.getUserLabels();
  var label_array = [];
  for (var i = 0; i < labels.length; i++) {
    var label_name = labels[i].getName();
    var label_count = GmailApp.getUserLabelByName(label_name).getThreads().length;
label_array.push([label_name,label_count]);;
  }

  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getSheetByName('priorities');
  sheet.clear();
  sheet.appendRow(['Label Name','Label Count']);
  sheet.getRange(sheet.getLastRow()+1, 1, label_array.length, 2).setValues(label_array);
}

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('GMail')
  .addItem('Count Labels', 'label_count')
  .addToUi();
}

Some notes:

1. You will need to add the "priorities" tab to the spreadsheet you are using this script on.

2. This script must be installed and run while you are using it as the user whose e-mail you are looking to search (your shared email address).

3. This script will only update the page when you tell it to by using the custom menu, if you want it to update automatically at specific intervals you can set up a trigger through the script editor by clicking on the icon which looks like a clock.