Skip to main content
Read and write data in Google Sheets — use it as a simple database, a reporting output, or a data source. Supports batch updates, row search, and sheet metadata retrieval.

​
Authentication

Auth type: OAuth 2.0 Enable the Google Sheets API in Google Cloud Console. Generate an OAuth 2.0 token with https://www.googleapis.com/auth/spreadsheets scope.

​
Triggers

Google Sheets triggers use polling. Changes are detected on a configurable interval (minimum: 1 minute). For real-time response, combine a Google Forms submission webhook with a Sheets read action instead.

​
Actions

Use A1 notation for ranges: Sheet1!A1:D10. Omit the sheet name to target the first sheet. Use Sheet1!A:A to target an entire column.

​
Next steps

Connectors overview

All connectors for Collabase Automation by category: communication, calendar, storage, CRM and finance, developer tools, Swiss ERP and HR, AI.

Actions

Action nodes perform operations when an automation runs.

Triggers

Triggers are the starting point of every automation.
Last modified on October 13, 2026