Find rows
find_rowsFilter Google Sheets rows by column criteria or free text and return only matching rows with absolute row numbers, so you can update them without reading long ranges.
Instructions
Finds rows matching one or more criteria and returns only those, along with their absolute row numbers. Prefer this over read_range on long tables: it avoids pulling hundreds of irrelevant rows into the conversation. The row numbers it returns can be passed straight to update_row.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum rows returned. | |
| query | No | Free text searched across all columns. | |
| sheet | Yes | Tab name, e.g. 'Log'. | |
| where | No | Criteria combined with AND. Omit together with query to return every row. | |
| headerRow | No | Row holding the headers. | |
| spreadsheetId | Yes | Spreadsheet ID, or its full URL. The ID is the segment between /d/ and /edit in the URL. |