Skip to main content

Add Data to Sheet

The Add Data to Sheet node allows you to append or insert data into Google Sheets documents.

Overview

This node enables you to:
  • Append rows to existing sheets
  • Insert data at specific locations
  • Add multiple rows at once
  • Handle different data types
  • Format cells while adding data

Configuration

ParameterTypeDescription
Spreadsheet IDStringThe ID of the Google Sheet
Sheet NameStringName of the target sheet
ValuesArrayData to be added
Insert LocationStringWhere to add data (append/specific range)
Value Input OptionStringHow to interpret input (RAW/USER_ENTERED)

Authentication

This node requires:
  • Google Cloud Project
  • Google Sheets API enabled
  • Service account or OAuth2 credentials
  • Appropriate sharing permissions

Output

The node returns:
  • Number of rows added
  • Updated range
  • Success/failure status
  • Error messages if operation fails

Example Usage

{
  "spreadsheet_id": "1234567890abcdef",
  "sheet_name": "Sheet1",
  "values": [
    ["Name", "Email", "Score"],
    ["John Doe", "john@example.com", 95],
    ["Jane Smith", "jane@example.com", 88]
  ],
  "insert_location": "append",
  "value_input_option": "USER_ENTERED"
}
I