AI-powered lead generation system with email personalization and LinkedIn

by Matthieu ✓ · 10,585 views · created 2025-07-15 · Lead Generation, Multimodal AI

What this workflow does

This AI workflow has 36 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets and OpenAI. It also calls api.ghostgenius.fr over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. Get Settings (Google Sheets): uses Google Sheets
2. Get Settings (Google Sheets): uses Google Sheets
3. Aggregate: combines items into one
4. Aggregate: combines items into one
5. If: checks a condition and branches into true / false
6. If: checks a condition and branches into true / false
7. Make the perfect request (OpenAI): uses OpenAI
8. Missing API Key or Account ID (Stop and Error): stops the run with an error
9. Companies Recovery (Google Sheets): uses Google Sheets
10. Missing API Key or Account ID (Stop and Error): stops the run with an error

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

Services it uses

Google SheetsOpenAI

HTTP calls to: api.ghostgenius.fr

Before you upgrade to n8n 3.0

Nodes used (13)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Aggregaten8n-nodes-base.aggregate
• Google Sheetsn8n-nodes-base.googleSheets
• Filtern8n-nodes-base.filter
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• HTTP Requestn8n-nodes-base.httpRequest
• Ifn8n-nodes-base.if
• Split Outn8n-nodes-base.splitOut
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Coden8n-nodes-base.code
• Limitn8n-nodes-base.limit
• Manual Triggern8n-nodes-base.manualTrigger
• Stop and Errorn8n-nodes-base.stopAndError

From the author

🔧 AI-Powered B2B Prospecting Automation This automation is a complete end-to-end system designed to find, qualify, and contact B2B leads — fully automated and powered by AI. 1. Lead Discovery & Scoring - Searches for target companies on LinkedIn via Ghost…

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