CODEWITHSUNDEEP
google-apps-script
Meng Yang
Meng Yang

Reputation: 1

How can I know which sheet changed of a Google spreadsheet via AppScript

Dear Google AppScript Experts,

Recentlly I'm wondering whether there is a way to know exactly which sheet of a google spreadsheet changed or not. For example, thera are 30 sheets, such as 'Sheet1', 'Sheet2', 'Sheet3' and etc.

I can use Google Drive AppScript to retrieve the last update timestamp of spreadsheet to know whether it's changed or not, which it's on the whole spreadsheet, I cannot get to know which sheet change.

Anyone who has a solution on this problem?

Many thanks in advance.

Upvotes: 0

Views: 85

Answers (1)

Sujay Phadke
Sujay Phadke

Reputation: 2196

It's well documented: GAS-triggers

Use the OnChange trigger and the 'e' object will have the 'source' with the spreadsheet name. Even though the doc doesn't mention it, you can use source with OnChange as well as OnEdit.

Upvotes: 0

Related Questions