insert_rows
Add new rows to a spreadsheet at a specified position, shifting existing rows downward. Optionally populate inserted rows with data values or leave them blank for manual entry.
Instructions
Insert rows at a given position, shifting existing rows down.
If data is provided, the inserted rows are filled with those values (type-coerced). Otherwise the rows are left blank.
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>",
"row": "<row>"
},
"name": "insert_rows"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | Path to the spreadsheet file | |
| row | Yes | 1-based row index where new rows will be inserted. Existing rows at and below this index shift down. | |
| count | No | Number of rows to insert. If data is provided and longer, enough rows are inserted to fit the data. | |
| data | No | Optional 2D array of values to fill the inserted rows. Leave empty for blank rows. | |
| sheet | No | Sheet name. Defaults to the first sheet if omitted. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |