LinkedIn Company Scorer: AI search & qualification for CRM
n8n pipeline that searches LinkedIn companies via Ghost Genius API, filters by quality (followers + website), deduplicates against the CRM, scores each lead 0-10 with GPT-4.1 using customizable positive/negative criteria, and automatically feeds a Google Sheet CRM.
Max volume
AI score
CRM
Context
Finding qualified B2B prospects on LinkedIn = a full-time job. Sales reps spend hours searching with the right filters (size, sector, location), then scoring each company to know if it's worth contacting. And you need to avoid duplicates when running similar searches. Without automation, you cap at 50-100 qualified leads per week with massive time investment.
The challenge
Build a pipeline that (1) searches up to 1000 LinkedIn companies per run via Ghost Genius API with pagination, (2) filters out weak companies (followers <200, no website), (3) deduplicates against existing CRM via Google Sheets lookup, (4) scores new companies 0-10 with AI contextualized by the business criteria (industry, size, positive/negative indicators), (5) stores everything in an actionable Google Sheet.
The solution
n8n workflow with a manual trigger (ideal for targeted prospecting ramps). Set Variables lets you configure: target keyword, size (B-I), location ID, product/service, positive and negative indicators (3-5 each). Search Companies via Ghost Genius API with pagination (3 pages max, 2s between requests). Process Each Company in split-batches: Get Company Info (1 req/2s for rate limit) → Filter (followers >200 + website) → Check duplicate in Google Sheet by ID → If new: AI Scoring GPT-4.1 (temperature 0.2, JSON output, score 0-10 based on custom criteria) → Wait 2s → Append CRM with status 'Qualified'.
Key features
- 01LinkedIn search via Ghost Genius API (up to 1000 companies/run)
- 02Smart pagination (3 pages max, 2s interval)
- 03Centralized Set Variables: target, size, location, product, +/- indicators
- 04Quality filters: followers >200 + website required
- 05Google Sheets deduplication by LinkedIn ID (avoids cross-run duplicates)
- 06Contextualized AI Scoring GPT-4.1: industry fit + company profile + pain points
- 07Strict JSON output for 0-10 score (temperature 0.2 = consistent)
- 08Customizable positive/negative indicators (3-5 each)
- 09Rate limiting respected: Wait 2s before every Google Sheets append
- 10CRM append with 7 columns (ID, Name, Website, LinkedIn, Summary, Score, State='Qualified')
- 11All companies stored (regardless of score) to avoid re-scraping later