google-sheets-mcp

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

{ "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" }