Domain to email extraction using Apollo API

Who is this for? - Sales professionals looking to build lead lists from target company domains - Business development teams conducting outreach campaigns - Marketers building contact databases for account-based marketing - Recruiters searching for potential candidates at specific companies - Anyone needing to transform a list of company domains into actionable contact information

What problem is this workflow solving? Finding business email addresses for outreach is a time-consuming process. The Apollo API doesn't provide a direct way to extract email contacts from domains in a single call. This workflow bridges that gap by:

1. Automating the two-step process required by Apollo's API 2. Processing multiple domains in batches without manual intervention 3. Extracting, enriching, and storing contact information in a structured format 4. Eliminating hours of manual data entry and API interaction

What this workflow does This workflow creates an automated pipeline between Google Sheets and Apollo's API to:

1. Pull a list of target domains from a Google Sheet 2. Submit each domain to Apollo's search API to find associated people 3. Loop through each person found and enrich their profile data 4. Extract key information: name, title, email address, and LinkedIn URL 5. Write the enriched contact information back to a results sheet 6. Process the next domain automatically until all are complete

Setup

Prerequisites: - An n8n instance (cloud or self-hosted) - Apollo.io account with API access - Google account with access to Google Sheets

Google Sheets Setup: 1. Create a new Google Sheet with two tabs: - Tab 1: "Target Domains" with a column named "Domain To Enrich" - Tab 2: "Results" with columns: Company, First Name, Last Name, Title, Email, LinkedIn