Back to Templates

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

Last update

Last update 9 hours ago

Share


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