​
What it does

The Append Google Sheet tool adds new rows of data to existing Google Sheets. Perfect for logging data, collecting form responses, tracking events, and maintaining records automatically.
Requires Google Sheets Integration: You need to set up a Google Sheets integration before agents can use this tool.

​
Key features

  • Add single or multiple rows at once
  • Append to specific sheets/tabs within a workbook
  • Automatic placement at the end of existing data
  • Support for custom column ranges
  • Real-time data updates

​
Parameters

ParameterTypeRequiredDescription
sheet_idstringYesThe Google Sheet ID (from the URL)
valuesarrayYesArray of row data to append (each row is an array of values)
sheet_namestringNoName of the specific sheet/tab (default: first sheet)
rangestringNoColumn range specification like ‘A:C’ (default: ‘A:A’)

​
Common use cases

​
Log single entry

sheet_id: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
values: [["John Doe", "john@example.com", "2024-01-15", "Completed"]]
sheet_name: "User Activity"
Add a single row of data to track user activity.

​
Add multiple rows

sheet_id: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
values: [
  ["Product A", "100", "2024-01-15"],
  ["Product B", "150", "2024-01-15"],
  ["Product C", "200", "2024-01-15"]
]
sheet_name: "Sales Data"
Add multiple rows of sales data at once.

​
Append to specific columns

sheet_id: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
values: [["Task completed", "2024-01-15 10:30"]]
range: "A:B"
sheet_name: "Activity Log"
Add data to specific column ranges.

​
Form submission logging

sheet_id: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
values: [["Jane Smith", "jane@example.com", "Marketing", "Newsletter signup"]]
sheet_name: "Form Responses"
Log form submissions automatically.

​
Event tracking

sheet_id: "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
values: [["User Login", "user123", "2024-01-15 14:22:33", "Success"]]
sheet_name: "Event Log"
Track events and system activities.

​
Data format

The values parameter expects an array of arrays:
  • Single row: [["value1", "value2", "value3"]]
  • Multiple rows: [["row1col1", "row1col2"], ["row2col1", "row2col2"]]
Each inner array represents one row, and each string represents a cell value.

​
Finding the Sheet ID

The Sheet ID is found in the Google Sheets URL: 
https://docs.google.com/spreadsheets/d/SHEET_ID/edit#gid=0

​
What you get back

  • Success confirmation: Message confirming data was added
  • Updated range: The range where data was inserted
  • Row count: Number of rows added
  • Cell count: Number of cells updated

​
Best practices

  • Ensure data matches the existing column structure
  • Use consistent data formats (dates, numbers, etc.)
  • Include all required columns to maintain data integrity
  • Test with single rows before adding multiple rows
  • Keep the Google Sheet organized with clear headers

​
Troubleshooting

“Sheet not found” or “Access denied”
  • Verify the Sheet ID is correct
  • Ensure the sheet is shared with your Google Sheets integration
  • Check that the sheet name exists (case-sensitive)
“Invalid range”
  • Check the range format (e.g., ‘A:C’, ‘A1:C1’)
  • Ensure the range matches your data structure
  • Verify the columns exist in the sheet
“Data format error”
  • Ensure values is an array of arrays
  • Check that each row has the correct number of columns
  • Verify all values are strings
“Integration not configured”
  • Set up the Google Sheets integration first
  • Verify the integration has write permissions
  • Check that the integration is active