spreadsheet_idstring · requiredfind_in_spreadsheet
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
Read only
Parameters
querystring · requiredsheetstring · default nullcase_sensitiveboolean · default falsemax_resultsinteger · default 50