🎣 Generate & enrich LinkedIn leads with Apollo.io, LinkedIn API, Mail.so & GPT-3.5

⚡ 24,365 views · 🎣 Lead Generation & Enrichment

💡 Pro Tip — If you’re pulling LinkedIn data through HTTP requests or dealing with API restrictions, there’s a community node called ScraperNode that handles this natively. It has dedicated scrapers for profiles, companies, jobs, and people search — you just pass a URL and get structured data back.

Description

Note: Now includes an Apify alternative for Rapid API (Some users can’t create new accounts on Rapid API, so I have added an alternative for you. But immediately you are able to get access to Rapid API, please use that option, it returns more detailed data). Scroll to bottom for APify setup guide

This n8n workflow automates LinkedIn lead generation, enrichment, and activity analysis using Apollo.io, RapidAPI, Google Sheets and Mail.so.

Perfect for sales teams, founders, B2B marketers, and cold outreach pros who want personalized lead insights to drive better conversion rates.

⚙️ How This Workflow Works

The workflow is broken down into several key steps, each designed to help you build and enrich a valuable list of LinkedIn leads:

1. 🔑 Lead Discovery (Keyword Search via Apollo)

Pulls leads using Apollo.io’s API based on keywords, industries, or job titles.
Saves lead name, title, company, and LinkedIn URL to your Google Sheet.
You can replace the trigger node from the form node to a webhook, whatsapp, telegram, etc, any way for you to send over your query variables over to initiate the workflow.

2. 🧠 Username Extraction (from LinkedIn URL)

Extracts the LinkedIn username from profile URLs using a simple script node.
This is required for further enrichment via RapidAPI.

3. ✉️ Email Lookup (via Apollo User ID)

Uses the Apollo User ID to retrieve the lead’s verified work email.
Ensures high-quality leads with reliable contact info.
To double check that the email is currently valid, we use the mail.so api and filter out emails that fail deliverability and mx-record check. We don’t wanna risk sending emails to no longer existent addresses, right?

4. 🧾 Profile Summary Enrichment (via RapidAPI)

Queries the LinkedIn Data API to fetch a lead’s profile summary/bio.
Gives you a deeper understanding of their background and expertise.

5. 📰 Recent Activity Collection (Posts & Reposts)

Retrieves recent posts or reposts from each lead’s profile.
Great for tailoring outreach with reference to what they’re currently talking about.

6. 🗂️ Leads Database Update

All enriched data is written to the same Google Sheet.
New columns are filled in without overwriting existing data.

✅ Smart Retry & Row Status Logic

Every subworkflow includes a fail-safe mechanism to ensure:

✅ Each row has status columns (e.g., done, failed, pending).
🕒 A scheduled retry workflow resets failed rows to pending after 2 weeks (customizable).
💬 This gives failed enrichments another chance to be processed later, reducing data loss.

📋 Google Sheets Setup

Template 1: Apollo Leads Scraping & Enrichment

Template 2: Enriched Leads Database

Make a copy to your Drive and use.

Columns will be filled as each subworkflow runs (email, summary, interests, etc.)

🔐 Required API Keys

To use this workflow, you’ll need the following credentials:

🧩 Apollo.io

Sign up and get your key here: Apollo.io API Keys
⚠️ Important: Toggle the “Master API Key” option to ON when generating your key.
This ensures the same key can be used for all Apollo endpoints in this workflow.

🌐 RapidAPI (LinkedIn Data API)

Subscribe to the API here: LinkedIn Data API on RapidAPI
Use the key in the x-rapidapi-key header in the relevant nodes.

✉️ Mail.so

> 💡 For both APIs, set up the credentials in n8n as “Generic Credential” types.
This way, you won’t need to reconfigure the headers in each node.

🛠️ Customization Options

Modify the Apollo filters (location, industry, seniority) to target your ideal customers.
Change retry interval in the scheduler (e.g., weekly instead of 2 weeks).
Connect the database to your email campaign tool like Mailchimp or Instantly.ai.
Replace the AI nodes with your desired AI agents and customize the system messages further to get desired results.

🆕 Apify Update Guide

To use this workflow, you’ll need the following credentials:

Click on integrations and scroll down to API Solutions and select “Use API endpoints”. Scroll to “Run Actor synchronously and get dataset items” and copy the actor endpoint url then paste it in the placeholder inside the http node of Apify alternative flow “apify-actor-endpoint”. That’s it, you are set to go.

I am available for custom n8n workflows, if you like my work, please get in touch with me on email at joseph@uppfy.com

🔗 Nodes Used

Google Sheets, HTTP Request, Schedule Trigger, Google Sheets Trigger, n8n Form Trigger, OpenAI

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup