sheets_batch_update_values
Update multiple ranges in a Google Sheet at once by providing range-value pairs and a spreadsheet ID.
Instructions
Update values in multiple ranges of a Google Sheets spreadsheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | Array of range-value pairs to update | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) | |
| valueInputOption | No | How the input data should be interpreted (default: USER_ENTERED) |