read_formulas
Retrieve formulas from spreadsheet cells to access the underlying expressions instead of calculated results.
Instructions
Read formulas from cells (not just their calculated values)
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>"
},
"name": "read_formulas"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | The A1 notation range to read formulas from | |
| spreadsheet_id | Yes | The ID of the spreadsheet |