Is it possible to listen to "Spreadsheet renamed" events?
The corresponding event object has changeType equal to 'OTHER'. It works when the change is renaming a sheet, but doesn't work when the whole spreadsheet is renamed.
Is it possible to listen to "Spreadsheet renamed" events?
The corresponding event object has changeType equal to 'OTHER'. It works when the change is renaming a sheet, but doesn't work when the whole spreadsheet is renamed.
You can't run a function on sheet rename, no. You can do it from a Spreadsheet-bound script, but you need to set some properties and cascade the triggers. This is a really rough working example: