Delete rows
Google Sheets Delete Rows is a powerful AI tool that enables users to efficiently remove specified rows from their spreadsheets. Integrated via Pipedream and Google Sheets API, it simplifies data management by automating row deletions with precision.
Features
- Deletes specified rows within a Google Sheets document using row indexes.
- Supports selection of spreadsheets from personal or shared Google Drives.
- Allows targeting specific worksheets by worksheet ID for precise operation.
- Integrates seamlessly with Pipedream workflows for automation.
- Utilizes Google Sheets API ensuring reliable and secure data manipulation.
Benefits
- Saves time by automating manual row deletion in spreadsheets.
- Enhances data accuracy by removing unwanted rows programmatically.
- Supports collaboration by working across personal and shared Google Drives.
- Increases workflow efficiency when used in automated pipelines.
- Reduces errors associated with manual spreadsheet editing.
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. You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-delete-rows, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-delete-rows, propName: sheetId. |
| worksheetIdrequired | integer | Select a worksheet or provide a worksheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-delete-rows, propName: worksheetId. |
| 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 |