[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] Fetch Google Doc
Fetch the contents of an existing Google Document.
[Google] Fetch Google Sheet
Fetch contents of a Google Spreadsheet range.
Get Gmail Attachments
Download attachments from a Gmail email and store them on the app's own storage.
[Gmail] Get Draft
Retrieve a specific draft from Gmail by draft ID.
[Gmail] Get Email
Retrieve a specific email from Gmail by message ID.
Get Gmail Unread Count
Get the number of unread emails in the connected Gmail inbox.
Add [Google] Delete Sheet Rows to your workflow
Build powerful AI workflows with drag-and-drop blocks. No coding required.