Skip to main content

​
Connect

1

Go to Settings → Integrations → Google Sheets

2

Click Connect and sign in with Google

3

Grant access to your spreadsheets

​
Actions

ActionExample Prompt
Read rowsGet all rows from @Google Sheets "Leads"
Filter rowsGet rows where Status = "New" from @Google Sheets "Leads"
Add rowAdd row to @Google Sheets "Output" with {{data}}
Update rowUpdate row where Email = "{{email}}" in @Google Sheets
Create sheetCreate @Google Sheets "Report - {{date}}"

​
Examples

​
Read and process

Get leads from @Google Sheets "Sales Pipeline" where Stage = "Qualified"
For each: enrich with company data, update sheet

​
Write results

Write all processed leads to @Google Sheets "Enriched Leads":
- Name, Email, Company
- Revenue estimate
- Enrichment date

​
Sync between sheets

Get new rows from @Google Sheets "Form Responses"
Transform and append to @Google Sheets "Master List"
Mark as synced

​
Tips

  1. Use headers — First row should be column names
  2. Named ranges — Reference by name, not A1 notation
  3. Batch writes — Combine multiple rows into one operation
  4. Handle errors — Check if sheet exists before writing

​
Next

Google Sheets Guide

Advanced patterns and tips

Batch Runs

Process spreadsheet data at scale