batch_update_values
Write data to multiple Google Sheets ranges in a single API call, with options for dry-run preview or raw input.
Instructions
Write multiple ranges in one call (one API request, atomic-ish).
Args: spreadsheet_id_or_url: Full Sheets URL or bare spreadsheet ID. updates: List of {"sheet": str, "range": str, "values": list[list]}. 'sheet' is a name or gid; 'range' is bare A1 without prefix. raw: If true, store inputs literally (formulas become plain text). dry_run: If true, return the execution plan without writing. force: Allow writes touching more than the cell limit.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| raw | No | ||
| force | No | ||
| dry_run | No | ||
| updates | Yes | ||
| spreadsheet_id_or_url | Yes |