​

Add Data to Sheet

​

Overview

• 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

• Google Cloud Project
• Google Sheets API enabled
• Service account or OAuth2 credentials
• Appropriate sharing permissions

​

Output

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