← MCP Catalog

set_dropdown

Create or replace a dropdown validation rule on an A1 range. Provide either `values` for a fixed list, or both `source_sheet` and `source_range` to read options from another range in the same spreadsheet. `reject_invalid=True` blocks values outside the dropdown.

MCPGoogle Sheets AuthorizationPrivate connector
Can change or delete data

Parameters

spreadsheet_idstring · required

sheetstring · required

rangestring · required

valuesarray · default null

source_sheetstring · default null

source_rangestring · default null

reject_invalidboolean · default true

show_dropdownboolean · default true

help_textstring · default null