Filtering Contacts by Location from HubSpot in Clay Table

Josephine V. · 2025-05-14 14:10:09.412396+00

Hello, I have an account list being pulled from hubspot and brought into a clay table and then relevant people being found via clay - is there a way to only have people pulled from a location listed on the same original company table

Filtering Contacts by Location from HubSpot in Clay Table | Clay

6 comments

· Sorted by Oldest

kushagra t.
·
·
If you use the find contacts at company enrichment (which consumes credits) it is possible.
Josephine V.
·
·
that's fine it just needs to only be from the relevant city
kushagra t.
·
·
Yup, so you can reference the location from the hubspot field in the location field when adding the enrichment.
kushagra t.
·
·
Channeled
APP
·
·
You can filter contacts by location when using the "Find people at these companies" feature. Here's how: 1. Go to "Actions" and select "Find people at these companies" 2. Under "Companies," select your table containing company data 3. Choose either company LinkedIn URL or domain as the identifier 4. In the search parameters section, locate the "Location" filter 5. Use this filter to specify the city you want to target - this should match the location data in your original company table 6. You can include or exclude specific regions, countries, or cities 7. Preview your results, then import them to a new table This way, you'll only pull contacts from the specific city or location listed in your original company table.
Sources: Find People overview | Documentation | Clay University Find People overview | Documentation | Clay University Find People [Clay 101] - Clay University
Channeled
APP
·
·
Currently, you can't directly reference a HubSpot location field in the "Find people at these companies" location filter. The location filter in this feature requires manual input of specific regions, countries, or cities. Instead, you'll need to: 1. Pull your HubSpot data into a Clay table 2. Use the "Find people at these companies" action 3. Manually enter the same location in the location filter that appears in your HubSpot data For more complex filtering, you could use the Extract Values from Data action to first organize your HubSpot location data, then use those values to guide your manual location filtering.
Sources: Find People overview | Documentation | Clay University Find People [Clay 101] - Clay University Find People [Clay 101] - Clay University

Loading comments

kushagra t.
·
·
If you use the find contacts at company enrichment (which consumes credits) it is possible.
Josephine V.
·
·
that's fine it just needs to only be from the relevant city
kushagra t.
·
·
Yup, so you can reference the location from the hubspot field in the location field when adding the enrichment.
kushagra t.
·
·
Channeled
APP
·
·
You can filter contacts by location when using the "Find people at these companies" feature. Here's how: 1. Go to "Actions" and select "Find people at these companies" 2. Under "Companies," select your table containing company data 3. Choose either company LinkedIn URL or domain as the identifier 4. In the search parameters section, locate the "Location" filter 5. Use this filter to specify the city you want to target - this should match the location data in your original company table 6. You can include or exclude specific regions, countries, or cities 7. Preview your results, then import them to a new table This way, you'll only pull contacts from the specific city or location listed in your original company table.
Sources: Find People overview | Documentation | Clay University Find People overview | Documentation | Clay University Find People [Clay 101] - Clay University
Channeled
APP
·
·
Currently, you can't directly reference a HubSpot location field in the "Find people at these companies" location filter. The location filter in this feature requires manual input of specific regions, countries, or cities. Instead, you'll need to: 1. Pull your HubSpot data into a Clay table 2. Use the "Find people at these companies" action 3. Manually enter the same location in the location filter that appears in your HubSpot data For more complex filtering, you could use the Extract Values from Data action to first organize your HubSpot location data, then use those values to guide your manual location filtering.
Sources: Find People overview | Documentation | Clay University Find People [Clay 101] - Clay University Find People [Clay 101] - Clay University