Get named ranges
google_sheets_get_named_rangesList all named ranges in a Google Sheets spreadsheet by providing its ID. Use to automate range references in scripts and formulas.
Instructions
List named ranges on a 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": {
"spreadsheetId": "<spreadsheetId>"
},
"name": "google_sheets_get_named_ranges"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| account | No | Account nickname to use. | |
| spreadsheetId | Yes | Spreadsheet ID. |