📊 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
- Read — read rows from a spreadsheet range
- Write — write data to a specific range
- Append — append a new row to the end of a sheet
Configuration
- Credential — select a Google Sheets OAuth2 credential
- Spreadsheet ID — the ID from the Google Sheets URL
- Sheet Name — the tab/sheet name within the spreadsheet
- Range — cell range (e.g., A1:D10)
- Data — rows to write/append as JSON array
- 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