find_rows
Locate rows in a Google Sheets tab by matching a column value, with exact or substring search and a result limit.
Instructions
Find records in a tab whose column matches a value.
Args: spreadsheet_id: The long token from the spreadsheet URL. sheet_name: The tab name to search. column: Header name of the column to match against. value: Value to look for; matching is case-insensitive. header_row: 1-based row number holding the column headers. exact: True for an exact match, False for a substring match. limit: Maximum number of matches to return.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| exact | No | ||
| limit | No | ||
| value | Yes | ||
| column | Yes | ||
| header_row | No | ||
| sheet_name | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||