Find & score LinkedIn leads with GPT-4 AI and export to Google Sheets CRM
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs manually, when you click “Execute workflow”. 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”.
- Set Variables (Edit Fields (Set)): sets 6 fields: Your target, B: 1-10 employees, C: 11-50 employees, D: 51-200 employees, E: 201-500 employees, F: 501-1000 employees, G: 1001-5000 employees, H: 5001-10,000 employees, I: 10,001+ employees, Location (find it on : https://www.ghostgenius.fr/tools/search-sales-navigator-locations-id)…
- Search Companies (HTTP Request): calls api.ghostgenius.fr
- Extract Company Data (Split Out): splits a list into separate items
- Process Each Company Batch Control (Loop Over Items (Split in Batches)): loops over the items in batches
- Get Company Info (HTTP Request): calls api.ghostgenius.fr
- Filter Valid Companies (If): checks a condition and branches into true / false
- Check If Company Exists (Google Sheets): uses Google Sheets
- Is New Company? (If): checks a condition and branches into true / false
- AI Company Scoring (OpenAI): uses OpenAI
- Wait: waits 3 seconds
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.ghostgenius.fr
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - OpenAI
@n8n/n8n-nodes-langchain.openAi - Wait
n8n-nodes-base.wait - Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Search LinkedIn Companies, Score Them with AI, and Add to Google Sheets CRM Who is this for? This template is designed for sales teams, business development reps, and marketers who need a reliable, automated way to build targeted prospect lists. It’s…