Tool
Delete rows
The Google Sheets Delete Rows tool is an efficient automation utility that allows users to delete specified rows in a Google Sheets spreadsheet quickly. It integrates seamlessly with Google Drive and Sheets to streamline spreadsheet management tasks.
Features
- Deletes specified rows in a Google Sheets spreadsheet using precise start and end indices.
- Supports integration with both personal Google Drive and Shared Drives.
- Allows selection of specific spreadsheets via spreadsheet ID for targeted operations.
- Enables selection of specific worksheets within spreadsheets using worksheet ID.
- Offers a user-friendly interface to manage large data sets by removing unnecessary rows efficiently.
Benefits
- Saves time by automating the deletion of unwanted rows in spreadsheets.
- Enhances data organization by enabling clean-up of datasets without manual effort.
- Improves productivity for users working with extensive Google Sheets data.
- Integrates easily with other tools and workflows through Pipedream for scalable automation.
- Reduces errors associated with manual row deletions, ensuring accuracy in spreadsheet management.
Description
Deletes the specified rows from a spreadsheet. See the documentation
Parameters
5 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | The drive containing the spreadsheet to edit. If you are connected with any Google Shared Drives, you can select it here. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID |
| worksheetIdrequired | string | Select a worksheet or provide a worksheet ID |
| startIndexrequired | integer | Row number of the start (inclusive) of the range of rows to delete |
| endIndex | integer | Row number of the end (exclusive) of the range of rows to delete |
