π₯ 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