Move Sheet Rows
move_sheet_rowsMove selected rows from one sheet to another in the same spreadsheet, preserving formulas, formatting, and data types.
Instructions
Moves rows from one sheet to another within the same spreadsheet. The move is performed in a single batchUpdate (copyPaste followed by deleteDimension). Note: batchUpdate executes requests sequentially but does not roll back on partial failure — if the copy succeeds but the delete fails, rows may be duplicated. Formulas, data types, and formatting are preserved (unlike a values.get/append round-trip). Row numbers are 1-based (matching the spreadsheet UI).
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": {
"user_google_email": "<user_google_email>",
"spreadsheet_id": "<spreadsheet_id>",
"source_sheet": "<source_sheet>",
"start_row": "<start_row>",
"end_row": "<end_row>",
"destination_sheet": "<destination_sheet>"
},
"name": "move_sheet_rows"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end_row | Yes | Last row to move (1-based, inclusive). Required. | |
| start_row | Yes | First row to move (1-based, inclusive). Required. | |
| source_sheet | Yes | Name of the sheet to move rows from. Required. | |
| spreadsheet_id | Yes | The ID of the spreadsheet. Required. | |
| destination_sheet | Yes | Name of the sheet to move rows to. Required. | |
| user_google_email | Yes | The user's Google email address. Required. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |