Healthcare Executive Lead List Builder with Email Enrichment

Import or build a list of target healthcare companies

Create a Clay table with a 'Company Table Data' column populated with target organizations (e.g., Mayo Clinic, UPMC, McKesson, Optum, Kaiser Permanente). This serves as the seed dataset that drives the people-finding process.

Use Clay's 'Find People' feature to identify contacts by title and company

Run Clay's native 'Find People' enrichment on each company row, filtering by target job titles such as CEO, COO, CFO, VP of Talent Acquisition, and Regional VP of Operations. This populates First Name, Last Name, Job Title, Location, and Company Domain for each contact.

Resolve LinkedIn profile URLs for each identified contact

Use Clay's LinkedIn enrichment integration to find and attach LinkedIn profile URLs to each person row. This provides additional profile validation and enables LinkedIn-based outreach as a parallel channel.

Cascade through multiple email-finding providers to find the first valid work email

Configure a Custom Waterfall column in Clay that sequentially queries multiple data providers (e.g., Hunter.io, Apollo, Datagma, Prospeo) until a valid work email is returned. This maximizes email hit rate while controlling per-row costs by stopping once a result is found.

Run a secondary waterfall to catch contacts missed by the first pass

A second Custom Waterfall column targets contacts that returned no result in the first waterfall, using a different set or order of enrichment providers. This two-pass approach ensures maximum coverage across the 2,900+ row dataset.

Apply a dedicated 'Find Work Email' enrichment as a final fallback

Run Clay's native 'Find Work Email' action on any remaining contacts without a resolved email after both waterfall passes, leveraging Clay's built-in provider network as a final catch-all.

Merge results from both waterfalls and the dedicated enrichment into a single 'Combined Email & Waterfall' column

Use a Clay formula or conditional logic column to consolidate the three email sources (Waterfall 1, Waterfall 2, Find Work Email) into a single clean 'Combined Email' field. Priority logic ensures the highest-confidence email is surfaced per contact.

Export enriched list or sync to outbound tool

Once all rows are enriched (100% completion as shown), export the table as CSV or push directly to a CRM (HubSpot, Salesforce) or sales sequencer (Outreach, Apollo, Instantly) for campaign execution targeting healthcare executives.