Find Rows
find_rowsFind rows in a Google Sheets tab by matching cell value, optionally restrict to a column, and retrieve row indices for updating or deleting.
Instructions
Searches a sheet tab for rows whose cell value matches query and returns each match with its 1-based sheet row index (feed straight into update_row / delete_rows). Restrict to one column by 1-based column index OR by column_header name (resolved via header_row); omit both to search every column. Matches the raw unformatted value (numbers/dates by their underlying value, not displayed text). The header_row is treated as headers and excluded from matches.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| match | No | 'exact' = whole cell equals query; 'contains' = cell contains query as substring | exact |
| query | Yes | Value to search for | |
| column | No | 1-based column index to restrict the search to (e.g. 3 = C). Mutually exclusive with column_header | |
| header_row | No | 1-based row holding headers; used to resolve column_header and excluded from matches (default 1) | |
| sheet_name | Yes | Target sheet tab name | |
| max_results | No | Maximum number of matching rows to return (default 50) | |
| spreadsheet | Yes | Target spreadsheet: a full Google Sheets URL (https://docs.google.com/spreadsheets/d/<ID>/edit...) or a bare spreadsheet ID | |
| column_header | No | Header name to restrict the search to, matched in header_row. Mutually exclusive with column | |
| case_sensitive | No | Match case-sensitively (default false) |