← Showcase #168
Find People Lead Finder (n8n Workflow Studio)
Export Workflow JSON

Two-Tier Decision Maker & Email Discovery Pipeline

Ingests pending business leads from Google Sheets, identifies corporate decision makers through SearchAPI Google Search & Vertex AI verification, automatically triggers a LinkedIn directory fallback when initial confidence is insufficient, and verifies business email deliverability via Hunter.io.

Architectural Clue: Never trust the first result blindly. Each stage must confirm that the business, person, role, and email belong together before updating the sheet.
5
Ingested Leads
4
Decision Makers
2
Verified Emails
40%
Fallback Recovery
Simulate Target Business:
n8n Workflow Execution Graph 24 Nodes · Dual-Tier Pipeline
Ready for execution

SearchAPI

Primary & LinkedIn Fallback Prospecting
📊
Get row(s) in sheet1
read: sheet
5 leads
🌐
SearchApi
GET searchapi.io
Primary
{}
Code in JavaScript5
Format Snippets
Transform
🤖
Basic LLM Chain2
Verify Decision Maker
LangChain
G
Google Vertex Chat
Model: chat-bison
Vertex AI
{}
Code in JavaScript4
Validate Affiliation
Gatekeeper
⑂
If2
Decision Maker Found?
Split
{}
Code in JavaScript14
Prep Hunter Params
Domain/Name
🎯
Hunter2
email:finder
Hunter API
⑂
If5
Email Verified?
Score >= 60
📊
Update row in sheet9
Primary + Verified
Complete
📊
Update row in sheet8
Primary + Unverified
Complete
in
SearchApi-LinkedIn
Fallback Directory
Fallback
{}
Code in JavaScript7
Prep LinkedIn Context
Profiles
🤖
Basic LLM Chain3
Analyze Profiles
LangChain
G
Google Vertex Chat
Model: chat-bison
Vertex AI
{}
Code in JavaScript6
Validate LinkedIn Match
Gatekeeper
⑂
If3
Fallback Found?
Split
📊
Update row in sheet1
Exhausted Searches
Not Found
{}
Code in JavaScript15
Prep Hunter Params
Domain/Name
🎯
Hunter3
email:finder
Hunter API
⑂
If6
Email Verified?
Score >= 60
📊
Update row in sheet10
LinkedIn + Verified
Complete
📊
Update row in sheet11
LinkedIn + Unverified
Complete
Row ID Business Name Website Location Decision Maker Role Verified Email Score Status Match Source
Automated Pipeline Diagnostics (8/8 Checks)
ALL 8 TESTS PASSING
1. Filter pending leads: Status != 'Completed' PASS
2. Primary search query generation PASS
3. Vertex AI affiliation verification gatekeeper PASS
4. Automatic LinkedIn fallback on low confidence PASS
5. Clean domain extraction for Hunter API PASS
6. Hunter.io email deliverability scoring (>= 60) PASS
7. Universal row completion marking (idempotency) PASS
8. Consistent sheet schema for outreach readiness PASS