Clear cell
Google Sheets Clear Cell is an efficient tool designed to delete the content of a specific cell within a spreadsheet seamlessly. It integrates with Google Sheets API to provide a simple way to clear cell data programmatically.
Features
- Deletes content from any specified cell using A1 notation.
- Supports selection of the desired spreadsheet via Sheet ID.
- Allows choosing specific worksheets within a spreadsheet using Worksheet ID.
- Compatible with Google Drive and Shared Drives for flexible file access.
- Provides programmatic control over spreadsheet editing for automation purposes.
Benefits
- Improves productivity by automating cell content clearing tasks.
- Reduces manual errors related to spreadsheet editing.
- Enables integration with workflows for dynamic spreadsheet management.
- Saves time by targeting specific cells instead of clearing large ranges.
- Enhances data management processes within collaborative environments.
Description
Delete the content of a specific cell in a spreadsheet. See the documentation
Parameters
4 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-cell, 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-cell, 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-cell, propName: worksheetId. |
| cellrequired | string | The A1 notation of the cell to clear. E.g., |