Automations
Google Sheets Node
5 min readnode-google-sheets
Append rows to a Google Sheet, update cells, or read data — automate your reporting without CSV exports.
Google Sheets Node
Reads and writes Google Sheets via the Sheets API. Supports appending rows, updating specific cells, and reading ranges.
---
Setup
- Settings → Credentials → Connect Google
- Authorise with your Google account — select the Google Sheets scope
- The credential is saved as
Google — [your email]
---
Actions
| Action | Description |
|---|---|
append_row | Append a new row to a sheet |
update_cell | Update a specific cell by A1 notation |
read_range | Read a cell range and store as a variable |
---
Fields — append_row
| Field | Required | Description |
|---|---|---|
spreadsheetId | Yes | The ID from the Google Sheets URL: .../spreadsheets/d/SPREADSHEET_ID/... |
sheetName | No | Tab name (default: Sheet1) |
values | Yes | JSON array of values in column order: ["{{lead.email}}", "{{lead.businessName}}", "{{lead.city}}"] |
---
Example: log every new lead to a sheet
json
{
"action": "append_row",
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
"sheetName": "Leads",
"values": [
"{{lead.createdAt}}",
"{{lead.businessName}}",
"{{lead.email}}",
"{{lead.city}}",
"{{lead.emailStatus}}"
]
}
---
Tips
- The sheet must already exist with the correct tab name — the node won't create new sheets
- Column order in
valuesmust match the order of your sheet headers - Use a Loop node upstream to append multiple rows from a query result set