Clear cells
clear_rangeClear values and formulas from a specified Google Sheets range while keeping formatting intact. Previous contents are saved for undo.
Instructions
Clear values and formulas in a range (formatting is kept). Previous contents are saved for undo_last.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name | |
| account | No | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. | |
| dry_run | No | ||
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |