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

by Joseph ✓ · 25,893 views · created 2025-04-29 · Lead Generation, AI Summarization

What this workflow does

This AI workflow has 56 nodes and runs when someone submits an n8n form (“Leads Search”) (plus 9 other triggers). Along the way it connects Google Sheets and OpenAI. It also calls api.apollo.io and linkedin-data-api.p.rapidapi.com over HTTP.

How it runs

Trigger: When someone submits an n8n form (“Leads Search”) (plus 9 other triggers).

1. Generate Leads with Apollo.io (HTTP Request): calls api.apollo.io (POST)
2. Get Pending Username Row (Google Sheets): uses Google Sheets
3. Get Pending Email Statuses (Google Sheets): uses Google Sheets
4. get invalid email rows (Google Sheets): uses Google Sheets
5. Get Pending About and Posts Rows (Google Sheets): uses Google Sheets
6. get_failed_profile_summary_rows (Google Sheets): uses Google Sheets
7. Get Pending About and Posts Rows (Google Sheets): uses Google Sheets
8. Get Pending About and Posts Rows (Google Sheets): uses Google Sheets
9. get_failed_posts_summary_rows (Google Sheets): uses Google Sheets
10. Get Completely Enriched Profiles (Google Sheets): uses Google Sheets

…plus 36 more steps. See the full node list below.

Services it uses

Google SheetsOpenAI

HTTP calls to: api.apollo.io, linkedin-data-api.p.rapidapi.com

Before you upgrade to n8n 3.0

Nodes used (11)

• n8n Form Triggern8n-nodes-base.formTrigger
• Split Outn8n-nodes-base.splitOut
• Google Sheets Triggern8n-nodes-base.googleSheetsTrigger
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• Schedule Triggern8n-nodes-base.scheduleTrigger
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Mergen8n-nodes-base.merge
• Ifn8n-nodes-base.if

From the author

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).…

View the original on n8n.io → Check your own copy