AI-Powered CV Screening with Gemini, Gmail & Google Sheets

Overview

This workflow automates the entire CV screening process for a Software Engineer position. When a candidate submits an application via an n8n web form (including their resume as a PDF), the workflow extracts the text from the PDF, uses Google Gemini to analyze the resume against a job description, logs the candidate details and AI rating into a Google Sheet, sends a confirmation email to the candidate, and notifies HR via email. It eliminates manual resume review and speeds up the initial screening phase.

Nodes and Their Functions

• Application Form (Form Trigger) — No auth. This node presents a web form to collect candidate details: Full Name, E-mail, Expectation, LinkedIn, and a PDF resume. It triggers the workflow upon submission.
• Convert Binary to Json (Extract From File) — No auth. Extracts text from the uploaded PDF resume using the binaryPropertyName set to Your_Resume_CV. The extracted text is passed to the next node.
• Google Gemini Chat Model (LM Chat Google Gemini) — API Key auth. Configures the Google Gemini language model. No additional parameters are set beyond the default options; the API key is stored in n8n credentials.
• Using AI Analysis & Rating (Chain LLM) — No auth (uses the Gemini model above). This node sends a structured prompt to Gemini asking it to analyze the resume against a job description ("Software Engineer"). The prompt instructs the AI to output a compatibility rating (1–10), a recommendation, and a plain-text analysis (no markdown). The output is stored as text.
• Candidate Lists (Google Sheets) — OAuth2 auth. Appends a new row to a Google Sheet with columns: Full Name, E-mail, Expectation, LinkedIn, CV filename, and AI Rating. The sheet is identified by its document ID (1y4FFMXTuznSf2wWUraK57eBJnu4MVtgkxrGYRzRMwDQ) and sheet name (পত্রক1).
• Inform HR New CV Received (Gmail) — OAuth2 auth. Sends an email to [email protected] with candidate details and the AI rating. The subject is "New Candidate CV Awaiting Review".
• Confirmation of CV Submission (Gmail) — OAuth2 auth. Sends a thank-you email to the candidate’s submitted email address. The subject is "We Have Received Your CV".

Setup Instructions

1. Google Cloud Project – Enable the Gmail API and Google Sheets API. Create OAuth2 credentials (Desktop app type) and add the redirect URI from your n8n instance.
2. Google Gemini API Key – Obtain an API key from Google AI Studio (or via Google Cloud Vertex AI).
3. n8n Credentials – In n8n, create:
   • Gmail OAuth2 credential using your Google Cloud OAuth2 client ID and secret.
   • Google Sheets OAuth2 credential (same OAuth2 client).
   • Google Gemini API credential with your API key.
4. Google Sheet – Create a new Google Sheet with columns: Full Name, E-mail, Expectation, Linkedin, CV, AI Rating. Copy the sheet’s ID from the URL and update the documentId in the Candidate Lists node.
5. Form Trigger – The web form URL is generated automatically when you activate the workflow. Share the form URL with candidates.
6. HR Email – Update the sendTo field in the Inform HR node with your HR team’s email address.

Use Cases and Variations

• Different Job Descriptions – Modify the prompt in the Using AI Analysis & Rating node to match any job title or description.
• Slack Notifications – Replace or add a Slack node to notify HR via a Slack channel instead of (or in addition to) email.
• Multiple Sheets – Store accepted/rejected candidates in separate sheets based on AI rating thresholds.
• Interview Scheduling – After AI analysis, add a node to automatically send a calendar invite if the rating is above a certain score.
• Language Support – The prompt includes a variable ${output_language}; you can set it to any language (e.g., English, Spanish) to receive the analysis in that language.

{
  "id": "ES4TSw9HacxoNhLZ",
  "meta": {
    "instanceId": "5219bc76ea806909b58e13e2acac1c19192522e70dc3c90467e1800e94864105",
    "templateCredsSetupCompleted": true
  },
  "name": "AI CV Screening Workflow",
  "tags": [],
  "nodes": [
    {
      "id": "e77fbc32-5ee9-49b4-93d5-f2ffda134b08",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        1230,
        530
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "UcdfdADI6w9nkgg5",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "9e24167f-cac6-4b98-95da-30065510d79a",
      "name": "Confirmation of CV Submission",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1780,
        460
      ],
      "webhookId": "954756dc-2946-4b78-b208-06f3df612ab5",
      "parameters": {
        "sendTo": "={{ $('Application Form').item.json['E-mail'] }}",
        "message": "=Dear {{ $('Application Form').item.json['Full Name'] }}, \n\nThank you for submitting your CV. We have received it and will review it shortly. \n\nBest regards,\nMediusware",
        "options": {},
        "subject": "We Have Received Your CV"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "taFlf0vD5S4QlOKM",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
// ... truncated (copy to see full JSON)