
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... Read More
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.
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.
{
"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
}
]
} Read Less