drive_sheets_append
Append rows to a Google Sheet range without overwriting existing cells. Preview with dry_run before performing real writes.
Instructions
Append rows after the table in a Google Sheet range; use drive_sheets_write to overwrite existing cells. Mirrors omni-dev drive sheets append. Example: spreadsheet_id, range:"A1:B2", values:[["a","b"]], 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 |
|---|---|---|---|
| input | No | Interpretation: user-entered (default; parses formulas/dates/numbers) or raw (literal text). | |
| 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. | |
| values | No | Inline array of rows, e.g. `[["name", "score"], ["Ada", "42"]]`. Exactly one of values or values_path is required. | |
| 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. | |
| values_path | No | Local UTF-8 CSV/TSV/JSON file; mutually exclusive with values. Stdin (-) is unsupported. | |
| values_format | No | File format: auto (default; infer extension), csv, tsv, json. Only applies to values_path. | |
| spreadsheet_id | Yes | Spreadsheet id from /d/<ID>/ in a Sheets URL, e.g. 1a2B3c4D. Required. |