apply_filter
Filter spreadsheet rows by column conditions (eq, contains, regex, null, etc.) and return matching rows.
Instructions
Filter rows by column conditions (eq, ne, gt, gte, lt, lte, between, contains, not_contains, startswith, endswith, regex, in, not_in, is_null, not_null) and return the matching rows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to the spreadsheet file (absolute, or relative to the first allowed directory) | |
| limit | No | Max rows to return (max 5000) | |
| match | No | Rows must match all conditions, or any | all |
| sheet | No | Sheet name. Defaults to the first sheet. | |
| columns | No | Only return these columns. Defaults to all. | |
| conditions | Yes | Conditions to test each row against | |
| header_row | No | 1-based row holding column names; 0 means no header (columns named A, B, C...) |