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!
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.
You can also use triggers via App Scripts, onEdit() is called after every edit.
https://developers.google.com/apps-script/guides/triggers
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With