Move Sheet Rows
move_sheet_rowsDestructive
Move selected rows from one sheet to another within the same Google 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).
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | The user's Google email address. Required. | |
| spreadsheet_id | Yes | The ID of the spreadsheet. Required. | |
| source_sheet | Yes | Name of the sheet to move rows from. Required. | |
| start_row | Yes | First row to move (1-based, inclusive). Required. | |
| end_row | Yes | Last row to move (1-based, inclusive). Required. | |
| destination_sheet | Yes | Name of the sheet to move rows to. Required. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |