Write values to many ranges
batch_write_valuesOverwrite multiple Google Sheets ranges in one call to reduce quota usage. Supports USER_ENTERED or RAW input; null values leave cells untouched.
Instructions
Overwrites several A1 ranges in ONE call — one write against the per-minute quota instead of one per range, so always prefer this over looping write_values. data is a list of {range, values} pairs; all are written with the same value_input_option (USER_ENTERED parses formulas/numbers/dates, RAW stores literally). Returns totalUpdatedCells and a per-range responses[] breakdown. Like write_values, null entries skip cells rather than clearing them.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | The ranges to write, each with its own 2-D values matrix. | |
| spreadsheet_id | Yes | The spreadsheet id — the long id from the URL (docs.google.com/spreadsheets/d/<spreadsheetId>/edit) or from create_spreadsheet / search_spreadsheets output. | |
| value_input_option | No | USER_ENTERED (default) parses formulas/numbers/dates; RAW stores literal strings. |