8

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!

Pascal Landry
  • 81
  • 1
  • 3

2 Answers2

5

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.

Elliott Beach
  • 10,459
  • 9
  • 28
  • 41
1

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

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

gieoon
  • 129
  • 7