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", "[email protected]", 95],
    ["Jane Smith", "[email protected]", 88]
  ],
  "insert_location": "append",
  "value_input_option": "USER_ENTERED"
}