Skip to main content

​
Node Inputs

​
Required Fields

Spreadsheet ID:
The unique identifier of the Google Sheets spreadsheet.
Example: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms" Operation:
The operation to perform.
Available options:
  • read: Read data from the sheet
  • write: Write data to the sheet
  • append: Append data to the sheet
  • update: Update specific cells
    Example: "read"
Range:
The A1 notation range to read or write.
Example: "Sheet1!A1:D100"

​
Optional Fields

Values:
Data to write (required for write, append, update operations).
Example: 
[
  ["Name", "Email", "Status"],
  ["John Doe", "john@example.com", "Active"],
  ["Jane Smith", "jane@example.com", "Inactive"]
]
Value Input Option:
How to interpret input values.
Available options:
  • RAW: Values are not parsed
  • USER_ENTERED: Values are parsed as if typed by user
    Default: USER_ENTERED
Include Headers:
Whether the first row contains headers (for read operations).
Example: true
Default: true

​
Node Output

Sheet Data:
The data read from or written to the Google Sheet. Read Operation Output: 
{
  "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
  "range": "Sheet1!A1:D100",
  "operation": "read",
  "rows": 3,
  "columns": 3,
  "data": [
    {
      "Name": "John Doe",
      "Email": "john@example.com",
      "Status": "Active"
    },
    {
      "Name": "Jane Smith",
      "Email": "jane@example.com",
      "Status": "Inactive"
    }
  ]
}
Write Operation Output: 
{
  "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
  "range": "Sheet1!A1:C3",
  "operation": "write",
  "updated_cells": 9,
  "updated_rows": 3,
  "updated_columns": 3,
  "status": "success"
}

​
Node Functionality

The Google Sheets node:
  • Reads data from Google Sheets spreadsheets.
  • Writes and updates data in sheets.
  • Appends rows to existing data.
  • Supports structured data with headers.
  • Handles large datasets efficiently.
  • Enables automated spreadsheet workflows and reporting.
⌘I