Move Sheet Rows
move_sheet_rowsMove rows between sheets in a Google spreadsheet while preserving formulas, data, and formatting. Specify source and destination sheets and the row range.
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 |
|---|---|---|---|
| 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
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |