google sheetsgoogle-account
The company that I work on uses some neuralgic spreadsheets that I created and shared with my team. I am the owner of them.
If my account is deleted from company's owner (for various legitimate reasons), would these sheets be lost or the team will still have access to them?
All the sheets are saved to a shared folder that is shared using my coleagues emails. The sheets is shared within google suite towards accounts that belong to the same organization.
Try this code:
function start() {
var idFolder = '0B79ClRnKS87QcW9XbVhrcFZxd28'; // change
var sheetNames = ['1', '2', '3']; // change
var strRange = 'A1'; // change
deleteProtection(idFolder, sheetNames, strRange)
}
function deleteProtection(idFolder, sheetNames, strRange) {
var folder = DriveApp.getFolderById(idFolder);
var contents = folder.getFiles();
var file;
var sheet;
var sheets;
var sheetName;
var range;
var strRangeProtect;
var protections;
var protection;
var app = SpreadsheetApp;
while(contents.hasNext()) {
file = app.openById(contents.next().getId());
sheets = file.getSheets();
for(var i = 0; i < sheets.length; i++) {
sheet = sheets[i];
sheetName = sheet.getName();
protections = file.getProtections(app.ProtectionType.RANGE);
for (var i = 0; i < protections.length; i++) {
var protection = protections[i];
var range = protection.getRange();
var sheetName = range.getSheet().getName();
strRangeProtect = range.getA1Notation();
if (strRangeProtect == strRange && sheetNames.indexOf(sheetName) > 0) {
protection.remove();
}
}
}
}
}
Befor you start:
First you need to paste all the files into one folder, then copy it's id:
and change this lines:
var idFolder = '0B79ClRnKS87QcW9XbVhrcFZxd28'; // change
var sheetNames = ['1', '2', '3']; // change
var strRange = 'A1'; // change
- I am not sure if creating a copy will keep the IDs same or the scripts need to be updated.
File ID's are unique to each file. If you make a copy, the copy will have a different file ID from the original.
- If I move a copy of the folder to a shared place in client's drive, will the client require allowing permissions again?
Google Apps Script authorizations are Script Project based so moving them from one folder to another will not require a new authorization.
Best Answer
From the documentation: Depending on your organization's Google account: All of a user's data is deleted, unless you transfer it to another user[...] Obviously deletion of data is not a desirable outcome but there are options.
Your administrator needs to familiarise themselves with the various options and issues. Start with Google Workspace admin Help and perhaps focus on Delete or suspend users
I don't suggest that this is a full/complete list but consider: