clear_range
Clear cell values in a specified range without affecting formatting. Default dry-run mode allows preview before permanent deletion, with snapshot support for restoring cleared data.
Instructions
Clear all values in a range (destructive — dry_run defaults to TRUE).
Values are snapshotted before clearing so they can be restored. Formatting is not affected by this operation.
Args: spreadsheet_id_or_url: Full Sheets URL or bare spreadsheet ID. sheet: Sheet name OR gid string. range: Bare A1 range without sheet prefix, e.g. 'B2:D10'. dry_run: Defaults to TRUE. Pass false to actually clear. force: Allow clears touching more than the cell limit.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| force | No | ||
| range | Yes | ||
| sheet | Yes | ||
| dry_run | No | ||
| spreadsheet_id_or_url | Yes |