👥 Score resumes against JDs with Google Drive, Google Sheets, and GPT-4o
⚡ 204 views · 👥 HR & Recruitment
Description
Description
Automatically compare candidate resumes to job descriptions (PDFs) from Google Drive, generate a 0–100 fit score with gap analysis, and update Google Sheets—powered by Azure OpenAI (GPT-4o-mini). Fast, consistent screening with saved reports in Drive. 📈📄
What This Template Does
- Fetches job descriptions and resumes (PDF) from Google Drive. 📥
- Extracts clean text from both PDFs for analysis. 🧼
- Generates an AI evaluation (score, must-have gaps, nice-to-have bonuses, summary). 🤝
- Parses the AI output to structured JSON. 🧩
- Delivers a saved text report in Drive and updates a Google Sheet. 🗂️
Key Benefits
- Saves time with automated, consistent scoring. ⏱️
- Clear gap analysis for quick decisions. 🔍
- Audit-ready reports stored in Drive. 🧾
- Centralized tracking in Google Sheets. 📊
- No-code operation after initial setup. 🧑💻
Features
- Google Drive search and download for JDs and resumes. 📂
- PDF-to-text extraction for reliable parsing. 📝
- Azure OpenAI (GPT-4o-mini) comparison and scoring. 🤖
- Robust JSON parsing and error handling. 🛡️
- Automatic report creation in Drive. 💾
- Append or update candidate data in Google Sheets. 📑
Requirements
- n8n instance (cloud or self-hosted).
- Google Drive credentials in n8n with access to JD and resume folders (e.g., “JD store”, “Resume_store”).
- Azure OpenAI access with a deployed GPT-4o-mini model and credentials in n8n.
- Google Sheets credentials in n8n to append or update candidate rows.
- PDFs for job descriptions and resumes stored in the designated Drive folders.
Target Audience
- Talent acquisition and HR operations teams. 🧠
- Recruiters (in-house and agencies). 🧑💼
- Hiring managers seeking consistent shortlisting. 🧭
- Ops teams standardizing candidate evaluation records. 🗃️
Step-by-Step Setup Instructions
- Connect Google Drive and Google Sheets in n8n Credentials and verify folder access. 🔑
- Add Azure OpenAI credentials and select GPT-4o-mini in the AI node. 🧠
- Import the workflow and assign credentials to all nodes (Drive, AI, Sheets). 📦
- Set folder references for JDs (“JD store”) and resumes (“Resume_store”). 📁
- Run once to validate extraction, scoring, report creation, and sheet updates. ✅
🔗 Nodes Used
Google Sheets, Google Drive, AI Agent, Extract from File, Azure OpenAI Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File