Screen candidate CVs with Google Gemini, Google Sheets, and Gmail

Description

Quick overview This workflow collects candidate applications via an n8n form, extracts text from uploaded PDF CVs, compares each CV to a job description stored in Google Sheets using Google Gemini (via OpenRouter), logs screening results back to Google Sheets, and creates a Gmail draft email for HR review. How it works Candidate submits the n8n-hosted form with their details and a PDF CV. Two operations run in parallel: CV text is extracted from the uploaded PDF, and the matching Job Description is fetched from Google Sheets using the role the candidate entered. Gemini Flash evaluates the CV against the JD and returns a structured recommendation: Strong Interview, Interview, Borderline, or Do Not Proceed, along with a score, matched skills, gaps, and a plain-text summary. The full screening record is logged to a Screening Results tab in Google Sheets. A Gmail draft is created for HR to review and send: a shortlist notification for Interview and above, a rejection for Borderline and below. Setup Open the Config node and fill in spreadsheet_id, jd_sheet_gid, results_sheet_gid, and company_name. Create two tabs in your Google Sheet: Job Description (columns: job_id, title, department, required_skills, min_experience_years, description) and Screening Results (columns matching the Log to Sheets node). Connect credentials: Google Sheets, Gmail, and OpenRouter. Activate the workflow. The form URL appears in the CV Application Form node -- share it with candidates. Requirements n8n self-hosted or cloud. OpenRouter account with access to google/gemini-flash-1.5. Google Sheets with the two tabs above. Gmail account. Customization Swap the model slug in the OpenRouter node for any model on OpenRouter. Adjust the ats_score thresholds in the AI agent prompt. Add a Slack notification after Log to Sheets for real-time alerts. Convert the role text field to a dropdown by switching fieldType to "dropdown" and adding fieldOptions. An n8n automation workflow template by Aironauts AI.

Categories

Tags

Capabilities

• 5 nodes
• 1 views