update_range
Overwrite a Google Sheets range with new values or formulas. Preview changes with dry-run or store inputs literally with raw mode.
Instructions
Write values (or formulas) to an existing range. Overwrites current content.
Formulas like '=SUM(A:A)' are interpreted as formulas by default (USER_ENTERED). The previous values of the target range are snapshotted for rollback before writing.
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'. values: 2D list of cell values, rows x columns. 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 | ||
| range | Yes | ||
| sheet | Yes | ||
| values | Yes | ||
| dry_run | No | ||
| spreadsheet_id_or_url | Yes |