append_rows
Add new rows to the end of a spreadsheet sheet. Use this tool to efficiently append data like [['Alice', 30], ['Bob', 25]] after the last used row.
Instructions
Append one or more rows after the last used row in the sheet.
Values are type-coerced (numeric strings to numbers). This is the most efficient way to add data to the end of a sheet.
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": {
"file": "<file>",
"data": "<data>"
},
"name": "append_rows"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | Path to the spreadsheet file | |
| data | Yes | List of rows to append, e.g. [['Alice', 30], ['Bob', 25]]. Each inner list is one row. | |
| sheet | No | Sheet name. Defaults to the first sheet if omitted. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |