HS Lookup function is bugged - operators are stated as an AND function but it treats empty fields in CRM as a wildcard - example: lookup on "First, Last, Company Name" - but if in HS, there is a First, Last match but the company field is not populated, clay will match that HS record to the clay row.
The HubSpot Lookup function uses AND logic as documented, requiring all specified fields to match. However, the behavior you're experiencing with empty fields acting as wildcards appears to be unintended. For more accurate matching, consider: ** Using email as the primary lookup field since it's more reliable ** Enabling "Exact Match" to ensure precise field matching * Adding additional validation using AI formulas to compare domains If you need further help with this issue, please request human assistance by clicking on "Talk to a person."
so its a bug
The HubSpot Lookup function is designed to search for contacts using provided information like email, first and last name, or phone number. For companies, it can lookup using company domain or company ID. The lookup action includes optional settings like "Remove blank values from results" and "Limit" parameters. However, the specific behavior you're describing with empty fields acting as wildcards isn't detailed in our documentation. This suggests the issue may need technical investigation. Are you using the "Remove blank values from results" option in your HubSpot Lookup configuration?
Hi Severan, Thanks for reaching out to support. Would you be able to send over a Loom of the issue you are experiencing. Also, feel free to send over your table URL.
no need, its user error. Tried to delete the original post but looks like that functionality isn't enabled in this channel?
Sounds good! Glad it got resolved, let me know if any other questions arise :)
.png)