Google Sheets events
The Google Sheets connector supports the following events via polling for the Document object:
- New Record Created
- Existing Record Updated
- Existing Record Deleted
- When a new spreadsheet is created
- When a spreadsheet is updated
When a spreadsheet is moved to trashNote:
In some cases, using the Google Drive APIs for Polling on Google Sheets may trigger duplicate events if you are logged in with the same account on both Drive and Sheets.
There is a 10-second jitter between the CREATE and UPDATE events on Google Sheets. If you have triggers set up for both CREATE and UPDATE events, it is recommended to wait at least 10 seconds between updating a newly created sheet. In this way, you make sure you receive both events.
Event polling is performed every 5 minutes, by default. The polling interval is configurable. For details, see the Triggers documentation.