{"product_id":"google-gemini-resume-scoring-with-n8n-google-sheets","title":"Google Gemini Resume Scoring with n8n \u0026 Google Sheets","description":"\u003ch3\u003eAutomatically score resumes with Google Gemini—inside n8n, powered by Google Sheets\u003c\/h3\u003e\n\u003cp\u003eTurn inbound job applications into a quantified, recruiter-ready decision. This n8n workflow captures applications via an n8n form, extracts resume text, analyzes it with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e against a job description in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, calculates a fit score, updates status, and sends the candidate a \u003cstrong\u003eGmail\u003c\/strong\u003e acknowledgment or rejection email.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives applications\u003c\/strong\u003e when a candidate submits the n8n form with contact details, position, experience, and a resume PDF.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates an Application ID\u003c\/strong\u003e and timestamp, validates required fields, and checks experience.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuto-rejects low experience:\u003c\/strong\u003e if the candidate has \u003cstrong\u003e5 years of experience or less\u003c\/strong\u003e, it immediately sends a Gmail rejection.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStores candidate data\u003c\/strong\u003e by appending or updating records in the Google Sheets spreadsheet named \u003cstrong\u003e“Job Applications”\u003c\/strong\u003e (including the resume file reference).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads the correct job description\u003c\/strong\u003e from a separate Google Sheets spreadsheet named \u003cstrong\u003e“Job Descriptions”\u003c\/strong\u003e based on the selected position and combines it with application data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts resume text\u003c\/strong\u003e from the uploaded PDF and sends it to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e for structured JSON analysis (skills, strengths, weaknesses, and missing skills).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores fit and updates status\u003c\/strong\u003e against JD requirements (required skills, experience, preferred skills, and strengths), writes score + analysis back to “Job Applications,” and sets final status to:\n    \u003cstrong\u003eSelected\u003c\/strong\u003e (score ≥ 80) or \u003cstrong\u003eRejected\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails the candidate\u003c\/strong\u003e via Gmail: confirmation if selected, rejection if rejected.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRecruiting teams that want \u003cstrong\u003eresume scoring automation\u003c\/strong\u003e using n8n, Gemini, and Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators handling higher application volume and needing consistent, auditable scoring.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying a production-ready pipeline for \u003cstrong\u003eJD matching\u003c\/strong\u003e and candidate follow-ups.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic:\u003c\/strong\u003e if, set, code, gmail, merge, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e reads from “Job Descriptions,” writes to “Job Applications”\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini:\u003c\/strong\u003e resume text → structured JSON analysis → fit score and status\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46029303218355,"sku":"N8N-19616","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/88WNLfTHjBsKhqfsN1iPr_6froixg3.png?v=1789463013","url":"https:\/\/buyflowscripts.com\/products\/google-gemini-resume-scoring-with-n8n-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}