find_in_spreadsheet
Search for a specific value in a Google Spreadsheet cells, returning their locations and values. Supports optional sheet filter, case sensitivity, and result limit.
Instructions
Find cells containing a specific value in a Google Spreadsheet.
Args: spreadsheet_id: The ID of the spreadsheet (found in the URL) query: The text to search for in cell values sheet: Optional sheet name to search in. If not provided, searches all sheets. case_sensitive: Whether the search should be case-sensitive (default False) max_results: Maximum number of results to return (default 50)
Returns: List of found cells with their location (sheet, cell in A1 notation) and value
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_id | Yes | ||
| query | Yes | ||
| sheet | No | ||
| case_sensitive | No | ||
| max_results | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |