AutomationMart
Home/Browse/Domain to email extraction using Apollo API
n8n

Domain to email extraction using Apollo API

n8nn8n9 modulesv1.0
Google SheetsLinkedIn

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

At a glance

Domain to email extraction using Apollo API is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, LinkedIn
Modules
9
Price
Free
Version
v1.0
Domain to email extraction using Apollo API workflow diagram

About this workflow

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 n8n Setup: 1. Import the workflow JSON into your n8n instance 2. Set up Google Sheets credentials in n8n 3. Update the Google Sheets document ID in both Google Sheets nodes 4. Add your Apollo API key to both HTTP Request nodes 5. Review and adjust API rate limits if needed Testing: 1. Add a few test domains to your "Target Domains" sheet 2. Run the workflow manually to verify it's working correctly 3. Check the "Results" sheet to confirm data is being properly populated How to customize this workflow to your needs Adding More Contact Fields: 1. Modify the "Clean Up" node to extract additional fields from the Apollo API response 2. Add corresponding columns to your "Results" sheet 3. Update the "Results To Results Sheet" node mapping to include the new fields Filtering Results: 1. Add a Filter node after "Clean Up" to include only contacts with specific roles 2. Create conditions based on title, seniority, or other fields returned by Apollo Automating Workflow Execution: 1. Replace the manual trigger with a Schedule Trigger to run daily/weekly 2. Add a Filter node to process only domains with "Not Processed" status 3. Update the status field in Google Sheets after processing Additional Notes - This workflow respects Apollo's API rate limits by processing one contact at a time - The Apollo API may not return contact information for all domains or all employees - Consider legal and privacy implications when collecting and storing contact information Made with ❤️ by Hueston

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Filter and delete rows in Google Sheets based on specific criteria

Automatically filter and delete rows in Google Sheets based on specific criteria, streamlining data management and ensuring your spreadsheets remain organized and relevant.

Free

Extract LinkedIn post engagement data with Airtop

LinkedIn Post Engagement Data Extractor Use Case This automation is designed to extract key engagement metrics and audience data from a LinkedIn post. It's useful for analyzing the impact of content and identifying engaged users for lead generation, marketing, or research purposes. What It Does Given a LinkedIn post URL and an Airtop profile, this automation extracts: - Total number of reactions - Total number of comments - Total number of reposts - A list of users who reacted or commented, incl

Free

Upload CSV files to AWS S3 from Google Sheets content

Automatically upload Google Sheets data as CSV files to AWS S3, streamlining data management and storage across platforms with this Make template.

Free

Send country-based user & session report from Google Analytics to Google Sheets

Gain deeper insights into your website’s traffic with our automated report that sends country-specific user and session data to Google Sheets every Friday. Easily adjust the scheduling to align with your analytical needs. The scenario is scheduled to execute every Friday at 17:00 which you can change in the schedule setting by clicking the clock icon on the first module.

Free

Automated email assistant for suppliers using OpenAI and Google Sheets

Automated Email Assistant for Busy Professionals This assistant is designed for people who don't have time to write and send emails to suppliers. With just one request, it drafts and sends clear, professional messages automatically. How It Works The user makes a request (e.g., “Send an email to my fruit supplier asking for a quote on 1 crate of mangoes.”). Workflow: 1. The AI agent searches for the supplier in a Google Sheets database. 2. It automatically drafts the email using OpenAI (with the

Free

Customer support & lead collection chatbot with RAG, GPT-4o, Sheets & Telegram

Who’s it for This template is designed for small and medium businesses, startups, and agencies that want to automate customer inquiries, provide instant support, and capture leads without losing valuable conversations. It’s especially useful for teams that get many repetitive questions about products, services, or locations but don’t want to miss out on collecting contact details for follow-up. What it does / How it works The workflow creates a 24/7 AI-powered chatbot that answers company-relate

Free

Weekly SEO keyword research & competitor analysis with GPT5.5 and Bright Data

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically performs weekly keyword research and competitor analysis to discover trending keywords in your industry. It saves you time by eliminating the need to manually research keywords and provides a constantly updated database of trending search terms and opportunities. Overview This workflow automatically researches trending keywords for any specified topic or industry using

Free

Automated server log cleanup via email alerts with SSH - Nginx, Docker, System

This n8n workflow monitors email alerts for disk utilization exceeding 80%, extracts the server IP, logs into the server, and purges logs from Nginx, PM2, Docker, and system files to clear disk space. Key Insights - Ensure email alerts are consistently formatted with server IP details. - SSH access must be properly configured to avoid authentication failures. Workflow Process 1. Initiate the workflow with the Check Disk Alert Emails node when an email triggers on high disk usage. 2. Parse the

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free