clear_range
Remove cell values from a specified Google Sheets range while preserving formatting and row structure. Use it to wipe data without deleting rows or styles.
Instructions
Clear the values in a range, leaving formatting and the rows in place.
Args: spreadsheet_id: The long token from the spreadsheet URL. a1_range: The range to clear, e.g. "Sheet1!A2:D100".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| a1_range | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||