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)