Hubspot Lookup Not Finding Existing Contacts in Clay Issue

Irvin G. · 2026-01-13T11:51:40.105Z

Hello, If anyone could help please. I am trying to run Hubspot lookup to see if the contacts I have found already exist within clay. Now I have tested it with a contact I know that is already existing and the result came out as no records found

Hubspot Lookup Not Finding Existing Contacts in Clay Issue | Clay

11 comments

· Sorted by Oldest

Clay Support
APP
·
·
I see the issue - your HubSpot lookup is returning "No objects found" even for contacts you know exist. A few things to check:
First, make sure you're using the exact email format that exists in HubSpot. I notice there's a comma after ".school" in your screenshot - that extra punctuation could be causing the mismatch. [1]
Also, click into the specific cell where you're seeing the "No objects found" error to get more details about what might be going wrong.
Try testing with a clean email address (no extra characters) from a contact you're 100% sure exists in your HubSpot. The lookup should use email as the primary identifier since it's the most reliable way to find existing contacts. [2]
If it's still not working, double-check that your HubSpot account connection has the right permissions to access contact data. [3]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help resolving the HubSpot lookup issue, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any other challenges you’re facing?
Irvin G.
·
·
In hubspot records it has a comma because it could also have additional email under the same property aside from the primary email. Here is what it looks like normally
Clay Support
APP
·
·
Got it - HubSpot stores multiple emails in the same field separated by commas. This is likely why your lookup isn't working.
The HubSpot lookup in Clay expects exact matches, so if HubSpot has "vgenetay@gordons.school,otheremail@domain.com" but Clay is searching for just "vgenetay@gordons.school", it won't find a match. [1]
Try this: In your HubSpot lookup configuration, enable the "Remove blank values from results" toggle - this might help with the matching. [2]
If that doesn't work, you might need to clean your HubSpot data first to have one email per contact, or use a different unique identifier for the lookup. [3]
Clay Support
APP
·
·
Did that answer your question?
Muhammad S.
·
·
remove the slash(/) from the start and it should work in the EMAIL column
Clay Support
APP
·
·
You're absolutely right! The "/ X" at the beginning of your email field reference is causing the lookup to fail. Remove those characters so it just shows "Work Email (output column)" instead of "/ X Y @ Work Email (output column)". [1]
That should fix your HubSpot lookup - email addresses need to be clean references without extra formatting characters for the matching to work properly. [2]
Clay Support
APP
·
·
Hope that helps?
Irvin G.
·
·
It worked! Thank you Muhammad S.
Clay Support
APP
·
·
Great to hear that it worked! If you have any more questions or need further assistance, feel free to ask.

Clay Support
APP
·
·
I see the issue - your HubSpot lookup is returning "No objects found" even for contacts you know exist. A few things to check:
First, make sure you're using the exact email format that exists in HubSpot. I notice there's a comma after ".school" in your screenshot - that extra punctuation could be causing the mismatch. [1]
Also, click into the specific cell where you're seeing the "No objects found" error to get more details about what might be going wrong.
Try testing with a clean email address (no extra characters) from a contact you're 100% sure exists in your HubSpot. The lookup should use email as the primary identifier since it's the most reliable way to find existing contacts. [2]
If it's still not working, double-check that your HubSpot account connection has the right permissions to access contact data. [3]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help resolving the HubSpot lookup issue, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any other challenges you’re facing?
Irvin G.
·
·
In hubspot records it has a comma because it could also have additional email under the same property aside from the primary email. Here is what it looks like normally
Clay Support
APP
·
·
Got it - HubSpot stores multiple emails in the same field separated by commas. This is likely why your lookup isn't working.
The HubSpot lookup in Clay expects exact matches, so if HubSpot has "vgenetay@gordons.school,otheremail@domain.com" but Clay is searching for just "vgenetay@gordons.school", it won't find a match. [1]
Try this: In your HubSpot lookup configuration, enable the "Remove blank values from results" toggle - this might help with the matching. [2]
If that doesn't work, you might need to clean your HubSpot data first to have one email per contact, or use a different unique identifier for the lookup. [3]
Clay Support
APP
·
·
Did that answer your question?
Muhammad S.
·
·
remove the slash(/) from the start and it should work in the EMAIL column
Clay Support
APP
·
·
You're absolutely right! The "/ X" at the beginning of your email field reference is causing the lookup to fail. Remove those characters so it just shows "Work Email (output column)" instead of "/ X Y @ Work Email (output column)". [1]
That should fix your HubSpot lookup - email addresses need to be clean references without extra formatting characters for the matching to work properly. [2]
Clay Support
APP
·
·
Hope that helps?
Irvin G.
·
·
It worked! Thank you Muhammad S.
Clay Support
APP
·
·
Great to hear that it worked! If you have any more questions or need further assistance, feel free to ask.