gws.sheets.write_range
Write values to a specified range in a Google Spreadsheet using a 2D array of cell data. Choose USER_ENTERED for parsed formulas/dates or RAW for verbatim input, after confirming intent.
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) |