Clear rows
The Google Sheets Clear Rows tool allows users to delete the contents of specified rows in a spreadsheet while keeping the rows intact as blank. This functionality streamlines spreadsheet management by enabling easy content removal without restructuring the sheet.
Features
- Supports clearing specific rows or a range of rows within a worksheet.
- Works with spreadsheets stored on Google Drive, including Shared Drives.
- Requires minimal input: spreadsheet ID, worksheet ID, and row indices to target.
- Deletes content without removing rows, preserving the overall sheet layout.
- Provides integration with Google Sheets API for seamless automation.
Benefits
- Simplifies cleaning up spreadsheets by removing unnecessary data quickly.
- Maintains row structure for consistent data formatting and further use.
- Enhances productivity by automating repetitive row clearing tasks.
- Works directly within Google Drive environment, ensuring data security and accessibility.
- Facilitates integration into workflows via API for customized spreadsheet operations.
Description
Delete the content of a row or rows in a spreadsheet. Deleted rows will appear as blank rows. 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-clear-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-clear-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-clear-rows, propName: worksheetId. |
| startIndexrequired | integer | Row number of the start (inclusive) of the range of rows to clear |
| endIndex | integer | Row number of the end (exclusive) of the range of rows to clear |