Clear rows
The Google Sheets Clear Rows tool is an efficient AI-powered solution designed to delete the content of specified rows within a Google Sheets spreadsheet, leaving the rows blank without removing them entirely. It is ideal for automating data management tasks and maintaining spreadsheet structure while clearing outdated or unnecessary row data.
Features
- Effortlessly clears content from one or multiple rows in a Google Sheets spreadsheet without deleting the rows themselves.
- Supports specifying exact spreadsheet ID, worksheet ID, and the range of rows to clear for precise control.
- Compatible with Google Drive and Google Shared Drives, allowing flexible access to your spreadsheets.
- Automated row clearing helps maintain clean and organized sheets while preserving row formatting and structure.
- Integrates seamlessly with workflow automation platforms like Pipedream for streamlined data operations.
Benefits
- Saves time by automating the tedious task of manually clearing spreadsheet rows.
- Prevents accidental deletion of entire rows, protecting spreadsheet integrity.
- Enhances productivity by enabling bulk clearing of rows based on dynamic input parameters.
- Offers compatibility with shared drives, facilitating team collaboration while managing data.
- Improves data governance by regularly cleansing outdated information without disrupting sheet layout.
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. |
| 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 clear |
| endIndex | integer | Row number of the end (exclusive) of the range of rows to clear |
