Score and triage Indeed CVs with Mistral OCR, Groq, and Google Sheets

Who is it for

This template is for HR teams, recruitment agencies, and startups that receive job applications via Indeed and want to eliminate manual CV screening. If you're spending hours reading CVs before deciding who to call, this workflow automates that first-pass evaluation entirely.

What it does

Every time a candidate applies through Indeed, this workflow:

1. Picks up the application email via IMAP and extracts the CV attachment 2. Uploads the CV to a dedicated Google Drive folder (organized by job position) 3. Runs OCR on the PDF using Mistral AI to extract clean text 4. Sends the CV text to Groq (Llama 3.3 70B) for structured analysis 5. Validates the AI output and enforces score/recommendation consistency 6. Appends every candidate to a Google Sheets HR dashboard 7. Sends a formatted HTML email to the recruiter — but only for candidates scoring ≥ 75

Each candidate receives a score from 0 to 100 and one of four recommendations: REJECT, REVIEW, INTERVIEW, or STRONGHIRE. The AI also extracts key skills, years of experience, languages, education, strengths, and weaknesses.

Estimated cost: ~€0.005 per CV (OCR + LLM combined).

How to set up