Using Clay to Import HubSpot Contacts with ICP Details

Josh M. · 2025-11-20T21:02:20.383Z

Is there a table example that shows how you can use Clay to import a list from HubSpot of Contacts who have a Linkedin profile, then build out columns that capture ICP details, then find other people who match the same ICP details?

Yes, you can use a Claybook template to import a list of HubSpot Contacts, extract their company and people data, build out columns for ICP (Ideal Customer Profile) details, and then find other people who match those ICP details.

Example workflow:

1.
Copy a relevant Claybook template (such as this one).
2.
Import contacts from HubSpot: Connect your HubSpot account and import your list of contacts. You can map the company URL or other identifiers from your import data.
3.
Enrich and build ICP columns: Add columns to capture ICP details (like industry, company size, etc.) using enrichment steps.
4.
Find lookalike contacts: Use Clay’s search to find additional people who match your defined ICP criteria, and enrich them with company and people data.

This approach allows you to organize, analyze, and expand your contact list based on your ICP directly within Clay [1] [2] [3].

3 comments