drive_sheets_clear
Clear cell values in a Sheets range while retaining formatting. Preview changes with dry_run first; use drive_sheets_write to replace cleared values.
Instructions
Clear cell values while retaining formatting; use drive_sheets_write to replace them. Mirrors omni-dev drive sheets clear. Example: spreadsheet_id, range:"A1:B2", dry_run:true. dry_run defaults to false. Dry-run first: previews need no lease. Real writes require an operator allow rule and a lease unless require_lease:false. Acquire with drive_lease_acquire. A lease permits repeated writes to one file until expiry. refused-lease-stale needs a fresh backup: release with omni-dev drive lease release or wait for expiry before acquiring (acquire reuses stale live tokens too). Cancellation/timeout is not rollback; inspect state before retrying, especially append. Output is complete tagged YAML; refusals/failures set is_error.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| lease | No | Token from drive_lease_acquire or omni-dev drive lease acquire. Not needed for dry_run or operator require_lease:false rules; any supplied token is still validated. | |
| range | No | A1 range, e.g. A1:B2 or Sheet1!A1:B2. Omit with sheet to target the tab. | |
| sheet | No | Tab title, e.g. Sheet1. Supplies a bare range prefix; conflicts with a range already naming a tab. | |
| account | No | Selects a named Drive account instead of the ambient `--account`/`OMNI_DEV_DRIVE_ACCOUNT` resolution — e.g. `work`. Omit to use the resolved default account (or the legacy single-account credentials, if no named accounts are configured). Call `drive_account_list` to discover configured names. | |
| dry_run | No | Preview without mutating or requiring a lease. Default false; preview first. | |
| spreadsheet_id | Yes | Spreadsheet id from /d/<ID>/ in a Sheets URL, e.g. 1a2B3c4D. Required. |