// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Adds an editor to the spreadsheet using an email address.// TODO(developer): Replace the email address with a valid email.ss.addEditor('cloudysanfrancisco@gmail.com');// Gets a sheet by its name and protects it.constsheet=ss.getSheetByName('Sheet1');constsampleProtectedSheet=sheet.protect();// Adds an editor of the protected sheet using an email address.// TODO(developer): Replace the email address with a valid email.sampleProtectedSheet.addEditor('cloudysanfrancisco@gmail.com');// Gets the editors of the protected sheet.consteditors=sampleProtectedSheet.getEditors();// Logs the editors' email addresses to the console.for(consteditorofeditors){console.log(editor.getEmail());}

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Gets a sheet by its name.constsheet=ss.getSheetByName('Sheet1');// Protects the sheet.constsampleProtectedSheet=sheet.protect();// Adds the active user as an editor of the protected sheet.sampleProtectedSheet.addEditor(Session.getActiveUser());// Gets the editors of the protected sheet.consteditors=sampleProtectedSheet.getEditors();// Logs the editors' email addresses to the console.for(consteditorofeditors){console.log(editor.getEmail());}

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Gets a sheet by its name.constsheet=ss.getSheetByName('Sheet1');// Creates variables for the email addresses to add as editors.// TODO(developer): Replace the email addresses with valid ones.constTEST_EMAIL_1='cloudysanfrancisco@gmail.com';constTEST_EMAIL_2='baklavainthebalkans@gmail.com';// Protects the sheet.constsampleProtectedSheet=sheet.protect();// Adds editors to the protected sheet using the email address variables.sampleProtectedSheet.addEditors([TEST_EMAIL_1,TEST_EMAIL_2]);// Gets the editors of the protected sheet.consteditors=sampleProtectedSheet.getEditors();// Logs the editors' email addresses to the console.for(consteditorofeditors){console.log(editor.getEmail());}

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Gets a sheet by its name.constsheet=ss.getSheetByName('Sheet1');// Protects the sheet.constsampleProtectedSheet=sheet.protect();// Logs whether domain users have permission to edit the protected sheet to the// console.console.log(sampleProtectedSheet.canDomainEdit());

// Remove all range protections in the spreadsheet that the user has permission// to edit.constss=SpreadsheetApp.getActive();constprotections=ss.getProtections(SpreadsheetApp.ProtectionType.RANGE);for(leti=0;i <protections.length;i++){constprotection=protections[i];if(protection.canEdit()){protection.remove();}}

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Gets a sheet by its name.constsheet=ss.getSheetByName('Sheet1');// Protects the sheet and sets the description.constsampleProtectedSheet=sheet.protect().setDescription('Sample sheet is protected');// Gets the description of the protected sheet and logs it to the console.constsampleProtectedSheetDescription=sampleProtectedSheet.getDescription();console.log(sampleProtectedSheetDescription);

// Protect the active sheet, then remove all other users from the list of// editors.constsheet=SpreadsheetApp.getActiveSheet();constprotection=sheet.protect().setDescription('Sample protected sheet');// Ensure the current user is an editor before removing others. Otherwise, if// the user's edit permission comes from a group, the script throws an exception// upon removing the group.constme=Session.getEffectiveUser();protection.addEditor(me);protection.removeEditors(protection.getEditors());if(protection.canDomainEdit()){protection.setDomainEdit(false);}

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Gets a sheet by its name.constsheet=ss.getSheetByName('Sheet1');// Protects the sheet.constsampleProtectedSheet=sheet.protect();// Gets the type of the protected area.constprotectionType=sampleProtectedSheet.getProtectionType();// Logs 'SHEET'to the console since the type of the protected area is a sheet.console.log(protectionType.toString());

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Gets a sheet by its name.constsheet=ss.getSheetByName('Sheet1');// Gets the range 'A1:B10' of Sheet1.constrange=sheet.getRange('A1:B10');// Makes cells A1:B10 a protected range.constsampleProtectedRange=range.protect();// Gets the protected ranges on the sheet.constprotections=sheet.getProtections(SpreadsheetApp.ProtectionType.RANGE);// Logs the A1 notation of the first protected range on the sheet.console.log(protections[0].getRange().getA1Notation());

// Protect a named range in a spreadsheet and log the name of the protected// range.constss=SpreadsheetApp.getActive();constrange=ss.getRange('A1:B10');constprotection=range.protect();ss.setNamedRange('Test',range);// Create a named range.protection.setRangeName('Test');// Associate the protection with the named range.Logger.log(protection.getRangeName());// Verify the name of the protected range.

// Unprotect cells E2:F5 in addition to any other unprotected ranges in the// protected sheet.constsheet=SpreadsheetApp.getActiveSheet();constprotection=sheet.protect();constunprotected=protection.getUnprotectedRanges();unprotected.push(sheet.getRange('E2:F5'));protection.setUnprotectedRanges(unprotected);

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Gets a sheet by its name.constsheet=ss.getSheetByName('Sheet1');// Protects the sheet.constsampleProtectedSheet=sheet.protect();// Sets the warning status for the protected sheet as true.sampleProtectedSheet.setWarningOnly(true);constprotectedSheetWarningStatus=sampleProtectedSheet.isWarningOnly();// Logs the warning status of the protected sheet to the console.console.log(protectedSheetWarningStatus);

// Remove all range protections in the spreadsheet that the user has permission// to edit.constss=SpreadsheetApp.getActive();constprotections=ss.getProtections(SpreadsheetApp.ProtectionType.RANGE);for(leti=0;i <protections.length;i++){constprotection=protections[i];if(protection.canEdit()){protection.remove();}}

// Remove sheet protection from the active sheet, if the user has permission to// edit it.constsheet=SpreadsheetApp.getActiveSheet();constprotection=sheet.getProtections(SpreadsheetApp.ProtectionType.SHEET)[0];if(protection?.canEdit()){protection.remove();}

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Gets a sheet by its name.constsheet=ss.getSheetByName('Sheet1');// Creates a variable for an email address.// TODO(developer): Replace the email address with a valid one.constTEST_EMAIL='baklavainthebalkans@gmail.com';// Protects the sheet.constsampleProtectedSheet=sheet.protect();// Adds an editor to the protected sheet using the email address variable.sampleProtectedSheet.addEditor(TEST_EMAIL);// Removes the editor from the protected sheet using the email address variable.sampleProtectedSheet.removeEditor(TEST_EMAIL);// Gets the editors of the protected sheet.consteditors=sampleProtectedSheet.getEditors();// Logs the editors' email addresses to the console.for(consteditorofeditors){console.log(editor.getEmail());}

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Gets a sheet by its name.constsheet=ss.getSheetByName('Sheet1');// Protects the sheet.constsampleProtectedSheet=sheet.protect();// Removes the active user from the editors of the protected sheet.sampleProtectedSheet.removeEditor(Session.getActiveUser());// Gets the editors of the protected sheet.consteditors=sampleProtectedSheet.getEditors();// Logs the editors' email addresses to the console.for(consteditorofeditors){console.log(editor.getEmail());}

// Protect the active sheet, then remove all other users from the list of// editors.constsheet=SpreadsheetApp.getActiveSheet();constprotection=sheet.protect().setDescription('Sample protected sheet');// Ensure the current user is an editor before removing others. Otherwise, if// the user's edit permission comes from a group, the script throws an exception// upon removing the group.constme=Session.getEffectiveUser();protection.addEditor(me);protection.removeEditors(protection.getEditors());if(protection.canDomainEdit()){protection.setDomainEdit(false);}

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Gets the sheet 'Sheet1' by its name.constsheet=ss.getSheetByName('Sheet1');// Protects the sheet.constsampleProtectedSheet=sheet.protect();// Sets the sheet description to 'Sheet1 is protected.'sampleProtectedSheet.setDescription('Sheet1 is protected');// Gets the description of the protected sheet.constsampleProtectedSheetDescription=sampleProtectedSheet.getDescription();// Logs the description of the protected sheet to the console.console.log(sampleProtectedSheetDescription);

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Protects cells A1:D10 on Sheet1.constsheet=ss.getSheetByName('Sheet1');constprotectedRange=sheet.getRange('A1:D10').protect();// Logs the current protected range, A1:D10.console.log(protectedRange.getRange().getA1Notation());// Creates a named range for cells E1:J10 called 'NewRange.'constnewRange=sheet.getRange('E1:J10');ss.setNamedRange('NewRange',newRange);constnamedRange=ss.getNamedRanges()[0];// Updates the protected range to the named range, 'NewRange.'// This updates the protected range on Sheet1 from A1:D10 to E1:J10.protectedRange.setNamedRange(namedRange);// Logs the updated protected range to the console.console.log(protectedRange.getRange().getA1Notation());

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Protects cells A1:D10 on Sheet1 of the spreadsheet.constsheet=ss.getSheetByName('Sheet1');constprotectedRange=sheet.getRange('A1:D10').protect();// Logs the original protected range, A1:D10, to the console.console.log(protectedRange.getRange().getA1Notation());// Gets the range E1:J10.constnewRange=sheet.getRange('E1:J10');// Updates the protected range to E1:J10.protectedRange.setRange(newRange);// Logs the updated protected range to the console.console.log(protectedRange.getRange().getA1Notation());

// Protect a named range in a spreadsheet and log the name of the protected// range.constss=SpreadsheetApp.getActive();constrange=ss.getRange('A1:B10');constprotection=range.protect();ss.setNamedRange('Test',range);// Create a named range.protection.setRangeName('Test');// Associate the protection with the named range.Logger.log(protection.getRangeName());// Verify the name of the protected range.

// Protect the active sheet except B2:C5, then remove all other users from the// list of editors.constsheet=SpreadsheetApp.getActiveSheet();constprotection=sheet.protect().setDescription('Sample protected sheet');constunprotected=sheet.getRange('B2:C5');protection.setUnprotectedRanges([unprotected]);// Ensure the current user is an editor before removing others. Otherwise, if// the user's edit permission comes from a group, the script throws an exception// upon removing the group.constme=Session.getEffectiveUser();protection.addEditor(me);protection.removeEditors(protection.getEditors());if(protection.canDomainEdit()){protection.setDomainEdit(false);}

// Opens the spreadsheet file by its URL. If you created your script from within// a Google Sheets file, you can use SpreadsheetApp.getActiveSpreadsheet()// instead.// TODO(developer): Replace the URL with your own.constss=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/abc123456/edit',);// Gets the sheet 'Sheet1' by its name.constsheet=ss.getSheetByName('Sheet1');// Protects the sheet and sets the protection to warning-based.constsampleProtectedSheet=sheet.protect().setWarningOnly(true);// Logs whether the protected sheet is warning-based to the console.console.log(sampleProtectedSheet.isWarningOnly());