append_rows
Append new rows of data to a table in a Google Sheets range, automatically detecting the table structure.
Instructions
Append rows to the table detected in an A1 range.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"spreadsheet_id": "<spreadsheet_id>",
"range": "<range>",
"values": "<values>"
},
"name": "append_rows"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| values | Yes | ||
| spreadsheet_id | Yes | ||
| insert_data_option | No | INSERT_ROWS | |
| value_input_option | No | USER_ENTERED |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||