gws.sheets.clear
Clear cell values in a Google Sheets range using A1 notation, preserving formatting and validation. Returns the cleared range for confirmation.
Instructions
Clear (empty) the values in a range of a Google Spreadsheet. range uses A1 notation (e.g., 'Sheet1!A1:C10', 'Sheet1'). Removes cell values only — formatting, data validation, and other cell properties are left intact, and no rows or columns are deleted. Returns the cleared range. This tool irreversibly modifies user content. Confirm intent with the user before calling it on documents you did not create in this session.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1-notation range to clear (e.g., 'Sheet1!A1:C10') | |
| account | No | Account label or email. Uses default if omitted. | |
| spreadsheet_id | Yes | The spreadsheet ID |