When contact lists are built in Clay, they often have gaps — missing emails, unformatted phone numbers, or incomplete company data. ZoomInfo's bulk enrichment feature can fill those gaps, but the integration isn't direct. The workflow below bridges Clay and ZoomInfo via CSV export/import, then feeds clean data back into HubSpot for outreach.
This process was established during initial B2B sales setup, using a 159-contact Great Lakes Food & Beverage list as the first test run. See [1] for full context.
Populate a Clay table with whatever data is available — typically name, company, LinkedIn URL, and any other fields sourced from ZoomInfo, Apollo, or manual research. At this stage, email and phone gaps are expected and acceptable.
Download the current Clay table as a CSV. Include all columns that ZoomInfo can use for matching:
Use ZoomInfo's Enrich feature to upload the CSV and let ZoomInfo match records and append:
ZoomInfo matches on name + company as the primary key. The more identifying fields included in the export, the higher the match rate.
Once ZoomInfo processes the file, download the enriched output. Review match confidence and flag any records that returned no data for manual follow-up.
Upload the enriched CSV to HubSpot, mapping columns to the correct contact and company properties. Key fields to confirm on import:
Note: Phone numbers imported from CSV often come in as text strings. HubSpot may prompt you to reformat them on first edit — click save on the field to trigger the format conversion.
ZoomInfo credits are use-it-or-lose-it on a monthly cycle. To avoid waste:
"We have ZoomInfo in there, use it or lose it, right? So every month we need to be sure we suck every bit of content out of there that we can." — Mark Hope
| Problem | Workaround |
|---|---|
| Small/local companies not in ZoomInfo | Use Clay's geographic search (radius-based local pull) to find contacts ZoomInfo doesn't index |
| Low match rate on sparse records | Add LinkedIn URL to the export; it significantly improves ZoomInfo matching |
| Emails still missing after enrichment | Filter HubSpot segment to contacts with confirmed emails; prioritize those for email sequences; route no-email contacts to phone-first cadence |