append_rows
Add new rows to the end of a Google Sheets range. Provide the spreadsheet ID, target columns, and values as a JSON 2D array.
Instructions
Append rows to the end of data in a sheet.
Args: spreadsheet_id: The ID of the spreadsheet. range_notation: A1 notation indicating which columns (e.g., "Sheet1!A:D"). values: JSON 2D array of rows to append.
Returns: JSON with updated range and cells appended.
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_notation": "<range_notation>",
"values": "<values>"
},
"name": "append_rows"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| values | Yes | ||
| range_notation | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |