Back to Templates

Automate CV Screening and Candidate Scoring with Gemini AI and Google Sheets

Created by

Created by: Asfandyar Malik || asfandyar-malik

Asfandyar Malik

Last update

Last update a day ago

Share


Screenshot 20251030 174902.png

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)

How to customize

You can modify the AI prompt to align with your company’s job criteria or evaluation style.
Add more scoring categories (e.g., education, technical skills, experience).
Change the output destination — send results to Airtable, Notion, or Slack.
Enhance it with dashboards or extra nodes for reporting and analytics.

⚠️ Disclaimer

This workflow uses Gemini AI, which may require self-hosting for community node compatibility.
Ensure that no personal or sensitive candidate data is shared externally when using AI services.