Google Sheets events

The Google Sheets connector supports the following predefined events: When a new spreadsheet is created, When a spreadsheet is updated, When a spreadsheet is moved to trash, Cell in Sheet Updated, Row Added to the Bottom of Sheet, Sheet Created.

For the Cell in Sheet Updated, Sheet Created, and Row Added to the Bottom of Sheet events, you can select your target spreadsheet directly when configuring the event.

The Google Sheets connector also supports New record created, Existing record deleted, Existing record updated events on the Spreadsheet object.

Note:

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 seconds time difference 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. 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.