sheets_values_update
Updates a specified range in a Google Sheet with new values. Provide spreadsheet ID, range, input option, and 2D array as JSON string.
Instructions
Write values to a spreadsheet range.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1 notation range to write | |
| values | Yes | 2D array of values as JSON string (e.g. '[["A","B"],["C","D"]]') | |
| spreadsheetId | Yes | The spreadsheet ID | |
| valueInputOption | Yes | RAW or USER_ENTERED |