workspace_update_sheet
Updates a Google Sheets range by overwriting it with values from a JSON 2D array. Specify spreadsheet ID, range, and value input option.
Instructions
Update cell values in a Google Sheets range (PUT — overwrites the range completely)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheetId | Yes | Spreadsheet ID (from URL: docs.google.com/spreadsheets/d/{id}) | |
| range | Yes | A1 notation range (e.g. "Sheet1!A1:C10") | |
| values | Yes | 2D array as JSON string (e.g. [["A1","B1"],["A2","B2"]]) | |
| valueInputOption | No | How values are interpreted: USER_ENTERED parses dates/numbers, RAW stores as-is | USER_ENTERED |