gws.sheets.write_range
Write a 2D array of values to a specified range in Google Sheets, using A1 notation and choosing RAW or USER_ENTERED input parsing.
Instructions
Write values to a range in a Google Spreadsheet. values is a JSON array of arrays of scalars (strings/numbers/bools/null). Example: values = [["A1","B1"],["A2","B2"]]. value_input_option defaults to 'USER_ENTERED' (formulas, dates are parsed); pass 'RAW' to write values verbatim. This tool irreversibly modifies user content. Confirm intent with the user before calling it on documents you did not create in this session.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1-notation range (e.g., 'Sheet1!A1:B2') | |
| values | Yes | 2D array of cell values (array of row arrays) | |
| account | No | Account label or email. Uses default if omitted. | |
| spreadsheet_id | Yes | The spreadsheet ID | |
| value_input_option | No | 'RAW' or 'USER_ENTERED' (default) |