Google Sheets Integration
Connect Google Sheets to read rows, append data, update cells, and trigger workflows from spreadsheet changes.
Available triggers
| Trigger | When it fires |
|---|---|
| New Row | A new row is added to a sheet |
| Row Updated | An existing row is modified |
Available actions
| Action | What it does |
|---|---|
| Append Row | Add a new row at the bottom |
| Update Row | Modify an existing row |
| Get Row | Retrieve a specific row by number or criteria |
| Get All Rows | Retrieve all rows (with optional filter) |
| Delete Row | Remove a row |
| Create Spreadsheet | Create a new Google Sheets file |
Setup
- App Authorizations → Google Sheets
- Sign in with Google
- Grant access to your Google Drive and Sheets
Common patterns
Form to Sheet
Form Submission → Append Row (name, email, message, timestamp)
Sheet as database
Webhook → Get Row (find by email) → If-Else (exists?) →
Yes: Update Row | No: Append Row
Daily report
Schedule (daily) → Get All Rows (today's records) → TinyGPT (summarize) → Send Email
Two-way sync
Google Sheets Trigger (row updated) → Update HubSpot Contact (sync fields)
HubSpot Trigger (contact updated) → Update Google Sheets Row (sync back)
Tip
Use Google Sheets as a lightweight database for simple workflows. For complex queries or large datasets, migrate to PostgreSQL or TinyTables.