insert_rows
Insert empty rows into a Google Sheet at a specific row index by providing spreadsheet ID, sheet ID, start index, and number of rows.
Instructions
Insert empty rows at a specific position.
Args: spreadsheet_id: The ID of the spreadsheet. sheet_id: The numeric ID of the sheet. start_index: Row index to insert at (0-based, so row 1 = index 0). num_rows: Number of rows to insert.
Returns: Success message.
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>",
"sheet_id": "<sheet_id>",
"start_index": "<start_index>",
"num_rows": "<num_rows>"
},
"name": "insert_rows"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| num_rows | Yes | ||
| sheet_id | Yes | ||
| start_index | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |