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

Workflow overview

Why this workflow matters

Helpful for business development and pipeline building. Supports knowledge capture and document intelligence use cases.

HR Client Acquisition (Part 1) – Job Lead Discovery & AI Qualification System This AlekSystem 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 AlekSystem (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

Best fit

Need another direction?