Google Sheets
Read, write, and append data to Google Sheets spreadsheets.
Overview
Read, write, and append data to Google Sheets spreadsheets from your workflows. Use it for data collection, report generation, CRM tracking, or any spreadsheet-based automation.
Operations
- Get Row(s) — read the sheet as header-keyed rows, optionally filtered by column values (combine filters with AND/OR, or return only the first match)
- Get Range — read a specific A1-notation range
- Append Row — add a row by column names (e.g.
{"Status": "booked"}) - Update Row(s) — update every row whose match column (plus optional additional columns) equals a value
- Append or Update — update matching rows, or append a new row when none match (upsert)
- Append Rows / Update Range — raw 2D-array writes for full control
Configuration
- Credential — select a Google Sheets OAuth2 credential (a Google Drive credential also works and unlocks picking the document from a list)
- Document — pick a spreadsheet from a list, or paste its URL/ID
- Sheet / Tab — pick a tab from a list, or type its name
- Filters — column/value pairs for Get Row(s), with AND/OR combining
- Fields to Write — column → value mapping for header-based writes
- Range — cell range (e.g., A1:D10) for range operations
- Output Variable — name for storing read results
Common Use Cases
- Lead tracking — append new leads from webhook forms or emails to a Google Sheet for sales team review
- Report output — write AI-generated reports and summaries to a shared Google Sheet on a schedule
- Data collection — aggregate data from multiple API sources and compile results into a spreadsheet for analysis
- Inventory management — read product data from a Sheet, check stock levels, and trigger reorder alerts via email or SMS