I shared a file of Google sheets with my collaborator, and every day he will input the data into the row of Google sheets, and I want to lock that row after 1 hour after he finishes his work! Please help me.

CodePudding user response：

You can use Apps Script for this. Use a time-driven installable trigger in a script that protects/locks the sheet.

Your code should be something like this:

var sheet = SpreadsheetApp.getActiveSheet();
var permissions = sheet.getSheetProtection();
permissions.setProtected(true);
sheet.setSheetProtection(permissions);