batch_write
Write values to multiple ranges in Google Sheets with one call. Provide a JSON list of range-value pairs to update cells across the spreadsheet.
Instructions
Write values to multiple ranges at once.
Args: spreadsheet_id: The ID of the spreadsheet. data: JSON array of objects with 'range' and 'values' keys. Example: '[{"range": "A1:B2", "values": [[1,2],[3,4]]}, {"range": "D1", "values": [["Hello"]]}]'
Returns: JSON with total cells, rows, columns updated.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |