{"product_id":"n8n-ai-recruiting-workflow-mistral-gemini-google-sheets-drive","title":"n8n AI Recruiting Workflow: Mistral, Gemini, Google Sheets \u0026 Drive","description":"\u003ch3\u003eAutomate AI candidate screening in n8n—end to end\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n AI Recruiting Workflow\u003c\/strong\u003e collects job applications via an n8n form, extracts resume text with \u003cstrong\u003eMistral AI\u003c\/strong\u003e, matches candidates to roles from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, scores fit with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, and stores the CV plus an evaluation report in the right \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e folder (shortlisted or rejected).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects candidate submissions\u003c\/strong\u003e through an n8n form (name, email, CV upload, and department selection).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts resume text\u003c\/strong\u003e from the uploaded CV using \u003cstrong\u003eMistral AI\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads open roles by department\u003c\/strong\u003e from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (filtered by the selected department).\u003c\/li\u003e\n  \u003cli\u003eIf \u003cstrong\u003eno open roles\u003c\/strong\u003e exist, displays a “no jobs available” completion page; otherwise shows a \u003cstrong\u003erole dropdown\u003c\/strong\u003e for the candidate to choose.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches the full job description\u003c\/strong\u003e from \u003cstrong\u003eGoogle Docs\u003c\/strong\u003e using the stored JD link for the selected role.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores the resume against the job\u003c\/strong\u003e using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e via a LangChain LLM chain, returning structured \u003cstrong\u003eJSON\u003c\/strong\u003e (scores, matched skills, missing requirements).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a text evaluation report\u003c\/strong\u003e by comparing \u003cem\u003eoverallScore\u003c\/em\u003e to the role’s \u003cem\u003eMin_Score\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUploads results to department folders in Google Drive\u003c\/strong\u003e, placing the CV and evaluation report into the appropriate folder for shortlisted or rejected candidates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eHiring teams that need fast, consistent \u003cstrong\u003eAI recruiting\u003c\/strong\u003e scoring across multiple departments.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who want a repeatable workflow for application intake, role matching, and documentation storage.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up \u003cstrong\u003en8n workflows\u003c\/strong\u003e combining LLM resume extraction and structured candidate evaluations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMistral AI\u003c\/strong\u003e: extracts plain text from the uploaded CV.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: retrieves open job roles filtered by department.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Docs\u003c\/strong\u003e: pulls the job description text via the role’s JD link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (PaLM) API\u003c\/strong\u003e: scores fit and outputs structured JSON evaluation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Drive\u003c\/strong\u003e: uploads CV and the generated evaluation report to department-specific folders.\u003c\/li\u003e\n  \u003cli\u003en8n nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eform\u003c\/strong\u003e, \u003cstrong\u003eemail send\u003c\/strong\u003e, \u003cstrong\u003emistral ai\u003c\/strong\u003e, and \u003cstrong\u003egoogle docs\u003c\/strong\u003e (among the required steps).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45748943388851,"sku":"N8N-17705","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/b_NIH7g8GGHo4lGQxc-tO_93gS3h7r.png?v=1785575050","url":"https:\/\/buyflowscripts.com\/products\/n8n-ai-recruiting-workflow-mistral-gemini-google-sheets-drive","provider":"N8N Commerce","version":"1.0","type":"link"}