drive_update_range
Overwrite a range of a Google Sheet in the registered Google Drive folders, such as 'Sheet1'!B2:C3. Values are entered as if typed. To add rows at the end use drive.append_rows.
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": {
"file": "<file>",
"range": "<range>",
"values": "<values>"
},
"name": "drive_update_range"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | Drive id or pasted link of a Google Sheet. | |
| range | Yes | A1 range, e.g. 'Sheet1'!B2:C3. | |
| values | Yes | The new values: a list of rows, each a list of cell values. | |
| in_workspace | No | Run this one call in this workspace id instead of the session's. Nothing is stored; other sessions are not affected. |