​

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

​

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"
}