Search LinkedIn companies, score with AI and add them to Google Sheet CRM
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What 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 (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 2 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)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - 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
From the author
Search LinkedIn companies, Score with AI and add them to Google Sheet CRM Setup Video: https://youtube.com/watch?v=m904RNxtF0w&t Who is this for? This template is ideal for sales teams, business development professionals, and marketers looking to build a…