Score and route job candidates with Mistral, Gemini, Google Sheets, and Drive
Ready for 3.0What this workflow does
This AI workflow has 26 nodes and runs when someone submits an n8n form (“Candidate Form”). Along the way it connects Google Sheets, Google Docs, Google Drive and Google Gemini Chat Model and 1 more.
How it runs
Trigger: When someone submits an n8n form (“Candidate Form”).
- Extract Resume with Mistral (Mistral AI): uses Mistral AI
- Fetch Job Roles from Sheets (Google Sheets): uses Google Sheets
- Filter Jobs by Department (Code): runs custom JavaScript code
- Check If Jobs Available (If): checks a condition and branches into true / false
- Show Job Selection Form (n8n Form): shows the next form page
- Show No Jobs Available Page (n8n Form): shows the next form page
- Show Submission Success Page (n8n Form): shows the next form page
- Filter Job Description by Role (Code): runs custom JavaScript code
- Fetch Job Description from Docs (Google Docs): get
- Construct AI Evaluation Prompt (Code): runs custom JavaScript code
…plus 13 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Code
n8n-nodes-base.code - n8n Form
n8n-nodes-base.form - If
n8n-nodes-base.if - n8n Form Trigger
n8n-nodes-base.formTrigger - Google Sheets
n8n-nodes-base.googleSheets - Mistral AI
n8n-nodes-base.mistralAi - Google Docs
n8n-nodes-base.googleDocs - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Convert to File
n8n-nodes-base.convertToFile - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Drive
n8n-nodes-base.googleDrive - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow collects candidate applications via an n8n form, extracts resume text with Mistral AI, matches the candidate to an open role stored in Google Sheets and Google Docs, scores the fit using Google Gemini, and uploads the CV and an…