Scrape and qualify HR job leads with Apify, Google Sheets and OpenAI GPT-4o-mini

HR Client Acquisition (Part 1) – Job Lead Discovery & AI Qualification System

This n8n template helps recruitment agencies discover active job openings, filter them based on hiring relevance, and qualify them using AI — specifically designed for semi-skilled manpower hiring use cases.

What this template demonstrates Job lead discovery using Apify scraping
Hash-based deduplication to avoid duplicate entries
Batch processing using Split In Batches
Google Sheets as a structured lead database
AI-based lead qualification with strict JSON outputs
Separation between scraping, processing, and scoring

Use cases Recruitment agencies sourcing overseas job demand
HR consultancies targeting bulk hiring companies
Manpower supply businesses (semi-skilled labor focus)
Job demand validation before outreach
Building job-based lead pipelines

How it works User submits job roles and locations via form
Inputs are expanded into multiple search combinations
Apify scrapes job listings based on these inputs
Jobs are normalized and assigned unique identifiers
Existing jobs in Google Sheets are checked for duplicates
Only new jobs are stored and processed
Missing company data is enriched if required
AI scores each job based on hiring relevance
Jobs are marked as qualified or not qualified
Final results are saved back into Google Sheets

How to use Submit job roles and locations using the form trigger
Connect your Apify API credentials
Connect your Google Sheets account
Add your OpenAI API key
Run the workflow in test mode
Check results inside Google Sheets
Adjust scoring logic if needed

Requirements n8n (Cloud or Self-hosted)
Apify account for job scraping
Google Sheets for storage
OpenAI or compatible LLM API

Customising this workflow Modify job roles to match your niche (e.g., drivers, welders, helpers)
Adjust AI scoring logic for your hiring criteria
Replace Google Sheets with a database if needed
Add filters like salary, visa type, or urgency
Extend workflow for enruching & outreach automation (Part 2)

Good to know This template focuses only on job discovery and qualification
It is designed for semi-skilled manpower hiring workflows
AI scoring can be customized for any industry or role
No outreach is performed in this workflow
Works best with consistent job data sources

Who this is for Recruitment agencies working with overseas clients
HR consultants sourcing bulk hiring opportunities
Founders building recruitment automation systems
Anyone building a job-based lead generation pipeline