sheets_batch_update_values
Update multiple ranges in a Google Sheets spreadsheet with new values in one request. Specify spreadsheet ID, range-value pairs, and input interpretation (RAW or USER_ENTERED).
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) |