batch_update_cells
Update multiple ranges in a Google Sheet at once by mapping range strings to 2D arrays of values.
Instructions
Batch update multiple ranges in a Google Spreadsheet.
Args: spreadsheet_id: The ID of the spreadsheet (found in the URL) sheet: The name of the sheet ranges: Dictionary mapping range strings to 2D arrays of values e.g., {'A1:B2': [[1, 2], [3, 4]], 'D1:E2': [['a', 'b'], ['c', 'd']]}
Returns: Result of the batch update operation
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_id | Yes | ||
| sheet | Yes | ||
| ranges | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |