This workflow uses Clay to build a targeted list of healthcare executives (CEOs, COOs, VPs of Talent Acquisition) by pulling company data and enriching each contact with LinkedIn profiles and verified work emails via a custom waterfall. It is designed for GTM teams selling into large health systems and enables immediate outreach with accurate contact data at scale.
Seed a Company Table with target healthcare organizations
Create a Company Table in Clay populated with target health systems (e.g., Mayo Clinic, UPMC, Kaiser Permanente, Ascension). Include company domain and any known firmographic data. This serves as the anchor dataset for person-level lookups.
Use 'Find People' to identify executives by title and company
Run Clay's native 'Find People' enrichment using filters like job title keywords (CEO, COO, VP Talent Acquisition, President) and company domain. This populates 2,915 rows of contacts with First Name, Last Name, Job Title, Location, and LinkedIn Profile URL automatically.
Pull LinkedIn profile details for each identified contact
For each person found, Clay fetches the LinkedIn Profile URL and can optionally pull additional profile metadata (headline, seniority, tenure) using LinkedIn enrichment providers connected within Clay (e.g., Proxycurl or similar).
Cascade through multiple email-finding providers to maximize coverage
Clay's Custom Waterfall sequences through multiple email enrichment providers (e.g., Hunter, Findymail, Apollo, Datagma) in order of preference. If the first provider returns no result, it automatically tries the next, maximizing the percentage of contacts that receive a verified work email.
Apply a second email-finding step for contacts still missing emails
A dedicated 'Find Work Email (2)' column runs an additional enrichment pass for any contacts where the waterfall did not return a valid email on the first attempt. This two-pass approach is visible in the table schema and ensures near-complete email coverage.
Merge waterfall and direct email results into a single 'Combined Email & Waterfall' column
A formula or Clay logic column merges the best available email from all enrichment passes into one clean 'Combined Email & Waterfall' field. This gives downstream tools (CRM, sequencer) a single reliable email field per contact without manual deduplication.
Send enriched contacts to Salesforce, HubSpot, Outreach, or Apollo
Once the table reaches 100% completion, export the enriched contact list via Clay's native integrations or CSV export into a CRM (Salesforce, HubSpot) or sales engagement platform (Outreach, Salesloft, Apollo) to begin personalized outreach sequences targeting healthcare executives.