[Google] Delete Sheet Rows
The [Google] Delete Sheet Rows block removes a specified range of rows from a Google Spreadsheet.
Delete a range of rows from a Google Sheet
The [Google] Delete Sheet Rows block removes a specified range of rows from a Google Spreadsheet. You provide the spreadsheet's document ID, the name of the sheet or tab you want to target, and the start and end row numbers that define the range to delete. Row numbers are 1-based and inclusive on both ends, so setting startRow to 2 and endRow to 5 would delete rows 2, 3, 4, and 5. If no sheet name is provided, the block operates on the first sheet in the document by default.
The block requires a Google OAuth connection with the appropriate Drive scope to authenticate against the Google Sheets API. It takes no return value — the output is void — meaning it performs the deletion as a side effect and passes control to the next step in the workflow without producing data for downstream blocks to consume.
This block fits into workflows that manage or clean up spreadsheet data programmatically. Common scenarios include removing processed records after they have been handled, clearing out old log entries on a schedule, or trimming staging data after it has been migrated elsewhere. It is typically used alongside other Google Sheets blocks that read, write, or append rows.
What you can build
Real-world workflows powered by the [Google] Delete Sheet Rows block.
Remove Processed Records
After a workflow reads and processes rows from a Google Sheet, use this block to delete those rows so they are not processed again in future runs.
Clear Expired Log Entries
On a scheduled workflow, identify log rows older than a defined date and delete them from a logging sheet to keep the file size manageable.
Post-Migration Data Cleanup
After migrating rows from a staging sheet to a production database, delete the migrated rows from the source sheet to avoid duplication.
Reset a Template Sheet
Before populating a report template with fresh data, delete the previous data rows to ensure the sheet starts from a clean state.
Purge Cancelled Orders
When an order is cancelled in an external system, trigger a workflow that locates the corresponding row range in an orders sheet and deletes it.
Rotate Queue Entries
In a task queue managed in Google Sheets, delete completed task rows after they have been dispatched so the queue only reflects pending items.
Ready to add [Google] Delete Sheet Rows to your workflow?
Get Started FreeCommon questions about [Google] Delete Sheet Rows
What parameters are required to use this block?
The required parameters are documentId (the Google Spreadsheet ID), startRow (the first row to delete, 1-based), and endRow (the last row to delete, 1-based and inclusive). A Google OAuth connectionId is also needed for authentication. The sheetName parameter is optional; if omitted, the block targets the first sheet in the spreadsheet.
What does this block return?
The block returns void. It performs the row deletion as a side effect and does not produce any output data for downstream blocks to consume.
How are row numbers counted — does row 1 mean the header row?
Row numbers are 1-based, so row 1 is the very first row in the sheet, which is typically the header row. If you want to delete only data rows and preserve a header, set startRow to 2 or higher.
What happens if I omit the sheetName parameter?
If sheetName is not provided, the block operates on the first sheet (tab) in the specified Google Spreadsheet by default.
What kinds of workflows commonly use this block?
This block is commonly used in data cleanup workflows, scheduled maintenance routines, post-processing pipelines that remove handled records, and queue management workflows where completed entries need to be removed from a Google Sheet.
Related capabilities
[Google] Create Google Doc
Create a new Google Document and optionally populate it with content.
[Google] Update Google Doc
Update the contents of an existing Google Document.
[Google] Fetch Google Doc
Fetch the contents of an existing Google Document.
[Google] Create Google Sheet
Create a new Google Spreadsheet and populate it with CSV data.
[Google] Update Google Sheet
Update a Google Spreadsheet with new data.
[Google] Fetch Google Sheet
Fetch contents of a Google Spreadsheet range.
Add [Google] Delete Sheet Rows to your workflow
Build powerful AI workflows with drag-and-drop blocks. No coding required.