Set a filter
set_filterEnable header-row filter buttons for a Google Sheets range, or clear a tab's filter. Use for sorting and filtering rows directly in Sheets.
Instructions
Turn on a basic filter (filter buttons in the header row) for a range, or clear the tab's filter.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| clear | No | ||
| range | Yes | Data range including header, or tab name when clearing | |
| account | No | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. | |
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |