sheets_write_range
Write values into a specified A1 notation range of a Google Sheet, choosing user-entered parsing or raw storage, to populate spreadsheet cells programmatically.
Instructions
Writes values to a specified range in a Google Sheets spreadsheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | The A1 notation range to write to (e.g. Sheet1!A1:C3) | |
| values | Yes | 2D array of values to write | |
| input_mode | No | How input data should be interpreted. user_entered parses as if typed into the UI; raw stores as-is | user_entered |
| spreadsheet_id | Yes | The ID of the spreadsheet |