sheets_batch_update_values
Update multiple cell ranges in a Google Sheet simultaneously by sending a batch request with range and values data.
Instructions
Write to multiple ranges at once in a Google Spreadsheet (spreadsheets.values.batchUpdate)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | JSON string of an array of {range, values} objects, e.g. [{"range":"Sheet1!A1","values":[["v1"]]}] | |
| spreadsheetId | Yes | The spreadsheet ID |