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
| Name | Required | Description | Default | 
|---|---|---|---|
| action | Yes | Action to perform: 'add' or 'remove' | |
| column_name | Yes | Name of the column to update dropdown options for | |
| dropdown_options | No | List of dropdown options to add/remove (required for 'add' and 'remove' actions) | |
| sheet_name | Yes | The name of the sheet containing the table | |
| spreadsheet_name | Yes | The name of the Google Spreadsheet | |
| table_name | Yes | Name 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"
}