Clear Spreadsheet Values
sheets_clear_valuesDestructiveIdempotent
Clear cell values from a range in a Google Spreadsheet while keeping formatting intact. Provide spreadsheet ID and range to remove content.
Instructions
Clear cell values from a specific range in a Google Spreadsheet (keeps formatting).
Args:
spreadsheet_id (string): The ID of the Google Spreadsheet
range (string): The A1 notation range to clear (e.g., 'Sheet1!A1:D10')
Returns: { "spreadsheetId": string, "clearedRange": string }
Examples:
Clear range: range="Sheet1!A1:D10"
Clear entire sheet: range="Sheet1"
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_id | Yes | The ID of the Google Spreadsheet | |
| range | Yes | The A1 notation range to clear (e.g., 'Sheet1!A1:D10') |