Healthcare Executive Lead List with Verified Emails via Clay

Set up 'Find People' table with company and job title filters

Create a Clay table targeting healthcare executives by filtering for companies in the health system/hospital space. Define job titles such as CEO, COO, CFO, President, VP of Talent Acquisition, and Regional VP of Operations. This forms the seed list that drives all downstream enrichment.

Pull in company-level data (domain, HQ location, org size) linked to each contact

Clay's 'Company Table Data' column pulls in firmographic data for each person's employer, including company domain (e.g., mayoclinic.org, upmc.com). This ensures email guessing patterns and enrichment providers have the right domain to work with.

Auto-resolve LinkedIn profile URLs for each contact

Clay uses first name, last name, company name, and job title to look up and attach verified LinkedIn profile URLs for each contact. This enables further enrichment, social selling, and connection request workflows downstream.

First-pass email lookup using primary enrichment provider

Clay's Custom Waterfall runs the first enrichment provider (e.g., Apollo or Clearbit) to attempt to find the verified work email. If a result is returned with sufficient confidence, the waterfall stops here. This minimizes credit usage across providers.

Second-pass email lookup if first provider returns no result

If the first waterfall step fails to return a valid email, Clay automatically falls through to a secondary provider (e.g., Hunter.io or Prospeo). This increases overall email coverage across the 2,915-row list without manually switching tools.

Dedicated email finder for remaining unresolved contacts

Clay's native 'Find Work Email' module runs as a final enrichment pass for contacts not resolved by the waterfall. It combines multiple signals (LinkedIn URL, domain, name) to produce a best-guess verified email.

Merge all email sources into a single 'Combined Email & Waterfall' column

Clay uses a formula or logic column to consolidate the best available email from all three sources (Waterfall 1, Waterfall 2, Find Work Email) into a single output column. This gives the user one clean email field per contact for export or outreach.

Export enriched list to CSV or push directly to HubSpot, Salesforce, or Outreach/Apollo sequences

Once all 2,915 rows are enriched (100% completion shown), the list can be exported as CSV or synced directly to a CRM or sales sequencer. Each record includes full name, title, company, location, LinkedIn URL, company domain, and verified email — ready for personalized outreach.