Healthcare Executive Lead List Builder with Email Finder

Create or import a Company Table with target healthcare organizations

Start by creating a Clay table of target companies (e.g., Mayo Clinic, UPMC, McKesson, Kaiser Permanente). Include company name and domain as anchor fields. This serves as the seed data for the people search.

Run 'Find People' enrichment using company domain and job title filters

Use Clay's native 'Find People' feature to search for contacts at each company. Filter by seniority (C-suite, VP, Director) and relevant job title keywords (CEO, COO, Talent Acquisition, Operations). Clay surfaces first name, last name, job title, location, and LinkedIn URL for each match — resulting in 2,915 contacts in this example.

Pull LinkedIn profile URLs and validate contact identity

For each found person, Clay stores the LinkedIn profile URL. This can be used to validate the contact's current role and company, ensure data freshness, and optionally trigger further enrichment via LinkedIn data providers connected to Clay.

Cascade through multiple email providers to find verified work emails

Clay's Custom Waterfall sequentially queries multiple email enrichment providers (e.g., Hunter.io, Apollo, Clearbit, ContactOut) and returns the first verified result. This maximizes email coverage across all 2,915 contacts while minimizing credit spend. Two separate waterfall columns are used — likely one for primary email and one as a fallback — then combined into a single 'Combined Email & Waterfall' field.

Merge waterfall results into a single clean email column

A formula column ('Combined Email & Waterfall') merges the outputs from both waterfall runs, prioritizing the highest-confidence verified email. This produces a single, clean email field ready for export or direct use in outreach sequences.

Export enriched contact list to Salesforce, HubSpot, Outreach, or Apollo

Once the table reaches 100% enrichment completion, export the list via CSV or push directly to a CRM or sales engagement platform via Clay's native integrations. The final output includes: full name, title, company, location, domain, LinkedIn URL, and verified work email — ready for personalized outreach campaigns.