🤖 Automate CV screening with AI candidate analysis

How it works

This workflow automates your initial hiring pipeline by creating an AI-powered CV scanner. It collects job applications through a web form, uses AI to analyze the candidate's CV against your job description, and neatly organizes the results in a Google Sheet.

Here’s the step-by-step process: The Application Form: A Form Trigger provides a public web form for candidates to submit their name, email, and CV (as a PDF). Initial Logging: As soon as an application is submitted, the candidate's name and email are added to a Google Sheet. This ensures every applicant is logged, even if a later step fails. CV Text Extraction: The workflow uses Mistral's OCR model to accurately extract all the text from the uploaded CV PDF. AI Analysis: The extracted text is sent to Google Gemini. A detailed prompt instructs the AI to act as a hiring assistant, scoring the CV against the specific requirements of your job role and providing a detailed explanation for its score. Structured Output: A JSON Output Parser ensures the AI's analysis is returned in a clean, structured format, making the data reliable. Final Record: The AI-generated qualification score and explanation are added to the candidate's row in the Google Sheet, giving you a complete, analyzed list of applicants.

Set up steps

Setup time: ~15 minutes

You'll need API keys for Mistral and Google AI, and to connect your Google account.

1. Get Your Mistral API Key: Visit the Mistral Platform at [console.mistral.ai/api-keys](https://console.mistral.ai/api-keys). Create and copy your API key. In the workflow, go to the Extract CV Text node, click the Credential dropdown, and select + Create New Credential. Paste your key into the API Key field and Save.

2. Get Your Google AI API Key: Visit Google AI Studio at [aistudio.google.com/app/apikey](https://aistudio.google.com/app/apikey). Click "Create API key in new project" and copy the key. In the workflow, go to the Gemini 2.5 Flash Lite node, click the Credential dropdown, and select + Create New Credential. Paste your key into the API Key field and Save.