Google Sheets
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.
| Credential | Description |
|---|
| Access Token | OAuth 2.0 access token with Sheets scope |
Triggers
| Trigger | When it fires |
|---|
| New Row Added | A new row is appended to a tracked sheet |
| Row Updated | An existing row’s content is changed |
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
| Action | Key inputs | Key outputs |
|---|
| Get Row(s) | spreadsheetId, range (A1 notation) | values[][], count |
| Append Row | spreadsheetId, sheetName, values[] | updatedRange, updatedRows |
| Update Row | spreadsheetId, range, values[][] | updatedRange, updatedCells |
| Clear Range | spreadsheetId, range | clearedRange |
| Find Row | spreadsheetId, sheetName, column, value | row, rowNumber, found |
| Batch Update | spreadsheetId, data[] (range + values pairs) | totalUpdatedCells |
| List Sheets | spreadsheetId | sheets[] — sheetId, title, index |
| Create Sheet | spreadsheetId, title | sheetId, title |
| Get Spreadsheet Info | spreadsheetId | title, locale, sheets[], spreadsheetUrl |
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.
