Is it possible to set automatic sheet/cell lock in Google Sheets?

Question

Google Sheets

There are cells/sheets in Google Spreadsheet. Other employees also have access to this table, and it is inconvenient to manually put protection on cells / sheets on a regular basis. Is it possible to somehow set a timer so that the cell / sheet is automatically blocked, for example, the next day or at the time I appointed?

Answer 1

Write a function and set a time trigger for it:

var spreadsheet = SpreadsheetApp.getActive();
  var protection = spreadsheet.getRange('C3:D5').protect();
  protection.setDescription('Описание');