Manage Named Range
manage_named_rangeList, create, update, or delete named ranges in Google Sheets using spreadsheet ID, user email, and range parameters.
Instructions
Manages the lifecycle of named ranges in a Google Sheet: list, create, update, or delete.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | Name for the named range (required for "create"; optional identifier for "update"/"delete"). | |
| action | Yes | The operation to perform: "list", "create", "update", or "delete". Required. | |
| new_name | No | New name for the named range (used with action="update"). | |
| new_range | No | New A1-style range for the named range (used with action="update"). | |
| range_name | No | Target cell or range in A1 notation (e.g., "Sheet1!A1:D10", "A1:B5") (required for "create"). | |
| named_range_id | No | The ID of the named range (optional identifier for "update"/"delete"). | |
| spreadsheet_id | Yes | The ID of the spreadsheet. Required. | |
| user_google_email | Yes | The user's Google email address. Required. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |