Automate CV screening and candidate scoring with Gemini AI and Google Sheets

 Who’s it for

For HR professionals, recruiters, and hiring managers who want to automate the initial CV screening and candidate evaluation process. This workflow helps teams efficiently assess applicants based on submitted answers and resume data — saving hours of manual review and ensuring fair, consistent scoring.

How it works

This workflow automates CV screening using Google Drive, Google Sheets, and Gemini AI. When a candidate submits a form with their answers and CV, the file is uploaded to Drive, converted from PDF to plain text, and merged with the form data. Gemini AI then analyzes both inputs, comparing skills, experience, and responses to generate consistency, job-fit, and final scores. Finally, the results are parsed, saved to Google Sheets, and automatically sorted by score, providing a ranked list of candidates for easy review.

How to set up

1. Connect your Google Drive and Google Sheets credentials in n8n. 2. Configure your Form Trigger to capture candidate answers and CV uploads. 3. Set up the Extract from File node to parse PDF files into text. 4. Add your Gemini AI credentials securely using n8n’s credential system (no hardcoded keys). 5. Execute the workflow once to verify that CVs are uploaded, analyzed, and ranked in the connected Google Sheet.

Requirements

1. n8n account (cloud or self-hosted). 2. Google Drive and Google Sheets integrations. 3. Gemini AI (Chat Model) API credentials. 4. A connected form (e.g., Typeform, n8n Form Trigger)