Get Started
Back to Templates

Score Resumes Against JDs with Google Drive, Google Sheets, and GPT-4o

Created by

Created by: Rahul Joshi || rahul08

Rahul Joshi

Last update

Last update a day ago

Categories

Share

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. ✅