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
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"spreadsheet_id": "<spreadsheet_id>",
"range": "<range>",
"values": "<values>"
},
"name": "sheets_write_range"
}
}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 |