What This Workflow Does
This automation solves the time-consuming challenge of manual resume screening by leveraging AI to objectively compare candidate resumes against job descriptions. Recruiters and hiring managers often spend 5-7 minutes reviewing each resume - this workflow reduces that to seconds while providing standardized scoring.
The system ingests resumes (PDF, DOCX, or text) and job description URLs, extracts clean text, then uses Google Gemini's advanced natural language processing to generate compatibility scores across multiple dimensions. These scores are automatically logged to Google Sheets with timestamps, creating an auditable record and enabling easy candidate comparison.
How It Works
Step 1: Input Collection
The workflow accepts candidate resumes through multiple channels (email attachments, form submissions, or direct uploads) along with the relevant job description URL. This flexibility allows integration with your existing recruitment pipelines.
Step 2: Text Extraction
Resumes and job descriptions are processed to extract clean, formatted text. The system handles various file formats and removes headers, footers, and formatting that could interfere with analysis.
Step 3: AI Analysis
Google Gemini analyzes the extracted text, comparing skills, experience levels, education, and other relevant factors. It generates match percentages for each category plus an overall compatibility score.
Step 4: Data Logging
Scores are automatically recorded in Google Sheets with candidate identifiers, analysis timestamps, and detailed breakdowns. This creates a searchable database of all applicants with consistent evaluation metrics.
Who This Is For
This workflow benefits recruitment agencies, HR departments, and hiring managers across all industries. It's particularly valuable for:
- Tech companies screening for specific technical skills
- High-volume recruiters processing dozens of applications daily
- Organizations prioritizing objective, bias-free hiring practices
- Teams needing to document hiring decisions for compliance
What You'll Need
- Active n8n instance (self-hosted or cloud)
- Google Gemini API access
- Google Sheets with write permissions
- Resume submission method (email, form, or upload portal)
- Job descriptions hosted online or in a shareable format
Quick Setup Guide
- Download and import the JSON template into your n8n instance
- Connect your Google Gemini API credentials
- Configure the Google Sheets destination with your preferred columns
- Set up your resume intake method (modify the trigger node as needed)
- Test with sample resumes and job descriptions
- Adjust scoring weights in the AI prompt if needed
Key Benefits
Save 80% screening time: Reduce resume review from minutes to seconds while maintaining (or improving) evaluation quality.
Objective candidate comparison: Standardized scoring eliminates human bias and provides apples-to-apples comparison of all applicants.
Auditable hiring records: Automated logging creates compliance-ready documentation of your screening process.
Scalable recruitment: Handle high application volumes without additional staffing costs.
Continuous improvement: Historical match data helps refine future job descriptions and hiring criteria.
Pro tip: For best results, periodically review your top-performing hires' match scores to refine your AI's weighting criteria. This creates a self-improving screening system.