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