Skip to main content
Glama

google-sheets-mcp

update_dropdown_options_tool

Modify dropdown options in a Google Sheets table column. Add new options while preserving existing ones or remove specific dropdown choices to streamline data entry.

Instructions

Update dropdown options in a table column.
This tool can add or remove specific dropdown options from an existing column in a table. For 'add' action: Adds new options to existing dropdown (preserves existing options). For 'remove' action: Removes specific options from existing dropdown.
Args: spreadsheet_name: Name of the spreadsheet sheet_name: Name of the sheet containing the table table_name: Name of the table to update dropdown options in action: Action to perform - "add" or "remove" column_name: Name of the column to update dropdown options for dropdown_options: List of dropdown options to add/remove
Returns: JSON string with success status and dropdown update details

Input Schema

NameRequiredDescriptionDefault
actionYesAction to perform: 'add' or 'remove'
column_nameYesName of the column to update dropdown options for
dropdown_optionsNoList of dropdown options to add/remove (required for 'add' and 'remove' actions)
sheet_nameYesThe name of the sheet containing the table
spreadsheet_nameYesThe name of the Google Spreadsheet
table_nameYesName of the table to update dropdown options in

Input Schema (JSON Schema)

{ "properties": { "action": { "description": "Action to perform: 'add' or 'remove'", "title": "Action", "type": "string" }, "column_name": { "description": "Name of the column to update dropdown options for", "title": "Column Name", "type": "string" }, "dropdown_options": { "default": [], "description": "List of dropdown options to add/remove (required for 'add' and 'remove' actions)", "items": { "type": "string" }, "title": "Dropdown Options", "type": "array" }, "sheet_name": { "description": "The name of the sheet containing the table", "title": "Sheet Name", "type": "string" }, "spreadsheet_name": { "description": "The name of the Google Spreadsheet", "title": "Spreadsheet Name", "type": "string" }, "table_name": { "description": "Name of the table to update dropdown options in", "title": "Table Name", "type": "string" } }, "required": [ "spreadsheet_name", "sheet_name", "table_name", "action", "column_name" ], "title": "update_dropdown_options_toolArguments", "type": "object" }

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/henilcalagiya/google-sheets-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server