Google Gemini Resume Scoring with n8n & Google Sheets

Automatically score resumes with Google Gemini—inside n8n, powered by Google Sheets

Turn inbound job applications into a quantified, recruiter-ready decision. This n8n workflow captures applications via an n8n form, extracts resume text, analyzes it with Google Gemini against a job description in Google Sheets, calculates a fit score, updates status, and sends the candidate a Gmail acknowledgment or rejection email.

What this workflow does

• Receives applications when a candidate submits the n8n form with contact details, position, experience, and a resume PDF.
• Generates an Application ID and timestamp, validates required fields, and checks experience.
• Auto-rejects low experience: if the candidate has 5 years of experience or less, it immediately sends a Gmail rejection.
• Stores candidate data by appending or updating records in the Google Sheets spreadsheet named “Job Applications” (including the resume file reference).
• Loads the correct job description from a separate Google Sheets spreadsheet named “Job Descriptions” based on the selected position and combines it with application data.
• Extracts resume text from the uploaded PDF and sends it to Google Gemini for structured JSON analysis (skills, strengths, weaknesses, and missing skills).
• Scores fit and updates status against JD requirements (required skills, experience, preferred skills, and strengths), writes score + analysis back to “Job Applications,” and sets final status to: Selected (score ≥ 80) or Rejected.
• Emails the candidate via Gmail: confirmation if selected, rejection if rejected.

Use cases

• Recruiting teams that want resume scoring automation using n8n, Gemini, and Google Sheets.
• SaaS operators handling higher application volume and needing consistent, auditable scoring.
• Automation engineers deploying a production-ready pipeline for JD matching and candidate follow-ups.

Technical details

• n8n nodes/logic: if, set, code, gmail, merge, sticky note
• Google Sheets: reads from “Job Descriptions,” writes to “Job Applications”
• Google Gemini: resume text → structured JSON analysis → fit score and status