Pascal Landry
Pascal Landry

Reputation: 81

Listener on edit of a document with Google Sheets API v4

I am running a script locally with Node.Js using the "Google Sheets API v4" to read and record data in a Google Sheets. I would like to know if it is possible to create a listener with the same API that it is triggered when someone edit a document?

Cheers!

Upvotes: 8

Views: 4254

Answers (2)

gieoon
gieoon

Reputation: 177

You can also use triggers via App Scripts, onEdit() is called after every edit.

https://developers.google.com/apps-script/guides/triggers

Upvotes: 1

Elliott Beach
Elliott Beach

Reputation: 11463

To create a listener without many API calls you need the drive push api, or you can check for changes.

The google sheets API does not support this feature.

Upvotes: 5

Related Questions