Problem Statement
Tausi Tech HR team was under pressure to fill 5–10 engineering and sales roles every quarter, but their sourcing process was painfully manual:
- LinkedIn searches yielded junk data
- LinkedIn exports for "Senior DevOps" or "Sales Representative" often had missing emails, broken profile links, or no company context.
- HR spent 4–6 hours daily manually verifying if candidates were real, active, and a good fit.
- Scattered candidate pipelines
- Shortlisted candidates lived in personal Google Sheets or recruiter notes.
- Great candidates got lost when handoffs happened between recruiters
- Generic outreach got ignored
- Messages like "We're hiring Devops engineers" had less than 5% response rates.
- HR needed to reference specific skills (AWS certs, recent projects) or company fit, but researching 100+ profiles weekly was impossible.
Tausi Tech needed a system to automatically qualify and enrich passive candidates so HR only contacted top matches with personalized outreach.
Solution
Built an automated candidate sourcing and enrichment workflow tailored for internal HR teams.
- Capturing raw candidate searches
- Apollo → Google Sheets
- HR runs searches for roles like "Senior Devops engineer" in Apollo.
- Exports land in a master Google Sheet with basic info: name, title, company website,company Linkedin URL, Personal LinkedIn URL, email.
- n8n quality filtering
- Workflow automatically filters for:
- Verified email exists
- Active LinkedIn profile URL
- Current company website available (to check stability, tech stack)
- 60–70% of raw exports get flagged as "Skip" so HR never sees bad data.
- Airtable as the candidate CRM
- Qualified candidates → Airtable
- Clean candidates land in Airtable with fields like:
- Name, current role, company
- LinkedIn URL, email, phone
- Role applied for: "Senior Devops engineer"
- Status: New, Contacted, Phone Screen, Offer
- Handles different layouts and formats, so invoices from different vendors can still be processed in a consistent way.
- Deep candidate profile enrichment
- Loop through each candidate
- n8n loops over "New" Airtable records using Apify to scrape:The LinkedIn URLs and company website
- JavaScript cleanup for HR-ready insights
- Raw data transforms into recruiter-friendly data fields
- Updates Airtable automatically with:
- Skills match score (High/Medium/Low for the role)
- Profile summary
- Personalization hooks ("open to work")
- Ready to use personalization for outreach using AI
- Use AI(LLM of choice) to personalise an email message based on the profile summary
Results
- 70% time savings on candidate research
- Raw searches cut from 60/week to 10 qualified candidates.
- Manual LinkedIn browsing dropped from 20+ hours/week to 3–4 hours total.
- Response rates jumped from 4% to 28%
- Personalized messages referencing skills, recent activity, and company context got dramatically higher replies.
- HR now competes with agencies for top passive talent.
- Centralized pipeline ended candidate chaos
- Airtable became the single source: no more "Did we contact them?" confusion.
- Time-to-hire dropped from 45 days to 32 days average.
- Filled 87% of open roles internally
- Better candidate quality meant fewer agency fees (saved ~$120k).
- 5-10 engineering/sales roles filled with enriched passive candidates.
Quick Demo
Experience a live demo of the LinkedIn Outreach system.Please reach out on my email for a live demo session.
Book a Live Demo
Workflow Diagram
This diagrams illustrate the workflow of the system.
Technology Stack
The system combines workflow automation software, apollo and AI LLMs.
- n8n automation platform
- Openai-Chatgpt(LLM of your choice)
- Apollo.io