Google Sheets
App IntegrationsGoogle Sheets Node
Overview
Supports the following operations: Create Sheet, Read Data, Insert Row.
Configuration
| Property | Type | Default | Description |
|---|---|---|---|
operation | string | — | Action to execute |
worksheetName | string | — | Worksheet Name for this node |
spreadsheetId | string | — | Google Sheets document ID |
rowData | string | — | Row Data for this node |
range | string | — | Cell range in A1 notation |
title | string | — | Title of the content or record |
headers | string | — | HTTP headers to include in the request |
Output Variables
Reference these variables in downstream nodes using the {{node.field}} syntax.
{{google-sheets.rows}}anyOutput field: rows
{{google-sheets.row_count}}anyOutput field: row_count
Examples
Basic Usage
Example configuration:
{
"operation": "value",
"worksheetName": "value",
"spreadsheetId": "value",
"rowData": "value",
"range": "value",
"title": "value",
"headers": "value"
}Tips & Best Practices
- •Ensure all required fields are configured.
- •Check the output variables to see available data.
- •Verify your connection credentials are configured in Settings > Integrations.
Try Google Sheets in Your Workflow
Create a free account and start building AI-powered workflows with the Google Sheets node.
Open Workflow Editor