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).
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 |