Sheets

Searches for rows in a Google Sheet by matching a value in a specific column and returns all matching row data.

This integration searches through a specific tab in your Google Sheets spreadsheet to find rows where a particular column matches your search value. It’s useful for looking up customer records, order information, or any data stored in your sheets where you need to find specific entries and retrieve the complete row details.

Parameters

• google_sheet_id (String): The unique identifier of your Google Sheets spreadsheet, found in the URL between “/d/” and “/edit”. Example: “1x9YzABcdeFgHiJkLmNoPqRsTuVwXyZ0123456789”
• sheet_tab_name (String): The name of the specific sheet tab you want to search within. Example: “Customer Data”
• search_value (String): The value you want to find in the specified column. Example: “sarah.johnson@example.com”
• search_column (String): The column letter (A, B, C, etc.) where you want to search for the value. Example: “A”

Output

Returns a search results object containing matched_count (number of matching rows found), search_column and search_value (your search criteria), searched_column_name (the header name of the searched column), and matched_rows (array of matching row data). Each matched row includes all column values from that row plus a line_number indicating its position in the spreadsheet.

Example Output:

{
  "matched_count": 1,
  "search_column": "A",
  "search_value": "sarah.johnson@example.com",
  "searched_column_name": "Email",
  "cleaned_sheet_tab_name": "Customer%20Data",
  "matched_rows": [
    {
      "Email": "sarah.johnson@example.com",
      "Look up date": "2024-01-15",
      "Voucher code": "SAVE20",
      "conversation_id": "conv_789xyz",
      "line_number": 3
    }
  ]
}