Screen CVs and score candidates with Gmail, Google Drive, OpenAI, and Sheets

Name: Screen CVs and score candidates with Gmail, Google Drive, OpenAI, and Sheets
Availability: InStock
Author: Stefan Joulien

Screen CVs and score candidates with Gmail, Google Drive, OpenAI, and Sheets preview

Open on n8n.io

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER

Early Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

Overview

Who's it for

This template is for HR teams, recruiters, and companies that receive job applications via email and want to automatically screen and evaluate candidates using AI. Ideal for organisations processing a high volume of resumes who want to reduce manual screening time.

How it works

When a candidate emails their CV, the workflow triggers automatically:

Gmail detects the incoming application and uploads the CV attachment to Google Drive
A Switch node identifies the file type (PDF, DOCX, or TXT) and routes it to the appropriate extraction method
The full text content of the resume is extracted and standardised into a clean format
An AI recruiter agent powered by OpenAI evaluates the candidate's strengths, weaknesses, skills, and potential contribution to the company
The candidate is assigned a suitability score from 1 to 10
A Structured Output Parser extracts the key evaluation data and saves it to Google Sheets for the hiring team to review

How to set up

Connect your Gmail account to the Gmail Trigger node
Connect your Google Drive account and set the destination folder for incoming CVs
Connect your OpenAI account to the AI model node
Connect your Google Sheets account and configure the candidate tracking sheet
Customise the Recruiter Agent prompt to match your job role and evaluation criteria

Requirements

Gmail account
Google Drive account
OpenAI API key
Google Sheets account

Stefan Joulien

5 workflows

Complexity

advanced

Published 10 Mar 2026

Likes 0

View on n8n.io Download Workflow

Install path: /data/workflows/13970/13970.json

Share Your Workflow

Have a useful automation to share? Publish it and help the community.

Submit Your Template How to Submit

Related Workflows

Aggregate multi-source job boards to Supabase and Google Sheets

Stop manually checking dozens of career pages. This workflow runs every morning, hits the public APIs of 8+ ATS platforms and job boards, normalizes every listing into a single clean schema, and syncs everything to Supabase and Google Sheets deduplicated and ready to query. ## Who it's for Job seekers, recruiters, or career platforms that want a consolidated, up-to-date feed of openings from specific companies without scraping, without API keys, and without paying for a jobs aggregator. ## How it works 1. A Schedule Trigger fires daily at 8 AM IST 2. A Company List code node defines all sources grouped by ATS type (Greenhouse, Lever, Ashby, Workable, SmartRecruiters, RemoteOK, and board APIs like Remotive, Himalayas, Arbeitnow, Jobicy) 3. A Prepare Request node builds the correct API URL and headers for each source, including multi-page pagination for SmartRecruiters (up to 500 jobs via offset) and Himalayas (up to 500 via page param) 4. An HTTP Request node fetches all sources in batches of 5 5. A Parse + Enrich + Filter node normalizes all divergent JSON structures into a unified schema — resolving ISO country codes, Indian city detection, salary parsing across all formats, and domain-based filtering 6. Deduplicated results are upserted to a Supabase (Postgres) table and written to Google Sheets ## ATS platforms supported Greenhouse, Lever, Ashby, Workable, SmartRecruiters, RemoteOK, Remotive, Himalayas, Arbeitnow, Jobicy ## Normalized output schema `job_id`, `title`, `company`, `location`, `country`, `salary`, `job_type`, `apply_url`, `posted_at`, `source_ats` ## Setup 1. Open the **Company List** node and edit the `sources` array — add or remove companies and their ATS slugs 2. Update `ALLOWED_DOMAINS` in the Parse node to filter by location or job type relevant to you 3. Add your **Supabase** credentials in the Postgres node and confirm your table name and schema match the output fields 4. Connect your **Google Sheets** credentials and set the target spreadsheet and sheet ID 5. (Optional) Adjust pagination limits per source in the Prepare Request node ## Requirements - Self-hosted or cloud n8n instance - Supabase project with a jobs table - Google Sheets with headers matching the normalized schema - No external API keys required — all sources use public endpoints

View

Check and deactivate broken job apply URLs with Postgres and Google Sheets

Keep your job listings database clean without manual checks. Every three days, this workflow fetches all active jobs from your Postgres database, runs each application URL through a validation check, identifies dead links via HTTP status codes and soft-404 redirect detection, then marks failed entries as inactive in both Supabase and Google Sheets simultaneously. ## Who it's for Teams running a job aggregator, career platform, or internal hiring tracker who store job listings in Postgres and want stale or broken apply links removed automatically — without waiting for user reports. ## How it works 1. A Schedule Trigger fires every 3 days 2. All active jobs are fetched from your Postgres (Supabase) database via a SQL query 3. A Prepare URLs node filters out any rows with missing, malformed, or non-HTTP URLs before they're checked 4. An HTTP Request node sends a HEAD request to each `apply_url` 5. A Find Dead Jobs code node analyzes each response and flags a job as dead if: - Status code is `404` or `410` - DNS resolution fails (`ENOTFOUND`) - Connection is refused (`ECONNREFUSED`) - A `301`/`302`/`307` redirect points to a different path — indicating the job was removed and the ATS is silently redirecting (soft-404 detection) 6. If dead jobs are found, an IF node routes them to both update nodes in parallel: - **Supabase (Postgres)** — status set to `inactive` via parameterized SQL - **Google Sheets** — row updated to reflect the new status 7. If no dead jobs are detected, the workflow exits cleanly with no writes ## Setup 1. Connect your **Postgres** credentials and confirm the query in the Fetch Active Jobs node matches your table and column names (`apply_url`, `job_hash`, `job_title`) 2. Connect your **Google Sheets** credentials and set the Resource ID and Sheet Name in the Mark Inactive node 3. Confirm the `inactive` status value in the Postgres update query matches what your app expects 4. (Optional) Adjust the soft-404 redirect detection logic in the Find Dead Jobs node if your ATS platforms use non-standard redirect patterns ## Database columns expected `job_hash` (unique identifier), `apply_url`, `job_title`, `status` ## Requirements - Self-hosted or cloud n8n instance - Supabase (or any Postgres-compatible) database with an active jobs table - Google Sheets with a matching jobs log

View

Screen resumes with GPT-4 Turbo from Gmail and send shortlisted to Slack

# AI Resume Screening Workflow using Gmail, OpenAI (GPT-4 Turbo) & Slack This workflow automatically fetches resumes from Gmail, extracts text from PDF attachments, analyzes candidate profiles using AI, and shortlists qualified candidates by sending their details to Slack. It significantly reduces manual effort in resume screening and speeds up hiring decisions. ### Quick Implementation Steps 1. Connect your Gmail account in n8n 2. Connect your OpenAI API (GPT-4 Turbo) 3. Connect your Slack account 4. Ensure resumes are received as PDF attachments in Gmail 5. Update job requirements inside the AI Resume Analyzer node 6. Run the workflow manually or activate it ## What It Does This workflow automates the resume screening process by integrating Gmail, AI, and Slack into a seamless pipeline. It starts by fetching emails containing resume attachments, then processes and validates these files to ensure only PDF resumes are analyzed. Once validated, the workflow extracts text from each resume and sends it to an AI model. The AI evaluates candidate details such as skills, experience, and contact information, and calculates a match score based on predefined job requirements. Finally, the workflow determines whether a candidate should be shortlisted or rejected. Shortlisted candidates are instantly shared on Slack with complete details, enabling faster hiring decisions and reducing manual screening effort. ## Who’s It For - HR teams and recruiters - Hiring managers - Startups handling large volumes of applications - Recruitment agencies - Businesses looking to automate candidate screening ## Requirements to Use This Workflow - n8n (self-hosted or cloud) - Gmail account (OAuth connected) - OpenAI API key (GPT-4 Turbo access) - Slack account (with channel access) - Resumes in PDF format - Basic understanding of n8n workflows ## How It Works & Set Up ### Setup Instructions 1. **Manual Trigger Setup** Use the *Start Workflow Manually* node to initiate the workflow. 2. **Gmail Configuration** Connect your Gmail account in the *Fetch Gmail* node. Ensure emails contain resume attachments. 3. **Attachment Processing** The workflow formats and checks attachments. Only emails with attachments proceed further. 4. **PDF Validation** Ensure resumes are in PDF format. Non-PDF files are ignored automatically. 5. **Text Extraction** The *Extract Resume Text* node converts PDF resumes into plain text. 6. **AI Configuration** Add your OpenAI credentials in the *OpenAI Chat Model* node. Customize job requirements inside the *AI Resume Analyzer* node prompt. 7. **Evaluation Logic** Candidates are scored based on: - Skills (50%) - Experience (30%) - Location (20%) 8. **Output Handling** If score ≥ 70 → Sent to Slack as shortlisted. Else → Marked as rejected 9. **Activate Workflow** Run manually or activate for continuous use. ## How To Customize Nodes - **AI Resume Analyzer** - Modify job requirements (skills, experience, location). Adjust scoring logic or threshold - **Evaluate Candidate Score** - Change minimum score (default: 70) - **Slack Node** - Customize message format. Change Slack channel - **Gmail Node** - Add filters (labels, subjects, senders) - **Extract Resume Text** - Extend for other file formats if needed ## 1.8 Add-ons (Enhancements) - Store shortlisted candidates in Google Sheets or database - Send rejection emails automatically - Add ATS (Applicant Tracking System) integration - Include resume ranking system - Add duplicate candidate detection - Enable multi-role job matching ## 1.9 Use Case Examples - Automating resume screening for tech hiring - Filtering candidates for specific skill sets (e.g., React Native developers) - Handling bulk job applications efficiently - Shortlisting candidates for remote roles - Pre-screening candidates before interviews There can be many more use cases depending on hiring workflows and business needs. ## 1.10 Troubleshooting Guide | Issue | Possible Cause | Solution | |---------------------------|-----------------------------------------------------|------------------------------------------------------------| | No emails fetched | Gmail not connected or incorrect filters | Reconnect Gmail and check filters | | Attachments not processed | Emails don’t contain attachments | Ensure resumes are attached | | PDF not detected | Incorrect file type | Ensure resumes are in PDF format | | AI response parsing error | Invalid JSON from AI | Check prompt and enforce strict JSON | | No Slack message | Slack credentials or channel issue | Verify Slack connection and channel ID | | Low-quality matches | Incorrect job requirements | Update AI prompt with accurate criteria | ## Need Help? If you need assistance setting up this workflow or customizing it for your business needs, we’re here to help. Whether you want to: - Extend this workflow with advanced features - Integrate it with your existing systems - Build similar automation solutions Feel free to reach out to our [n8n workflow development](https://www.weblineindia.com/n8n-automation/) experts at **WeblineIndia** for expert support and tailored workflow development. 👉 Let us help you automate smarter and scale faster.

View

Need Custom Automation?

Get help designing a custom n8n workflow that connects your stack and fits your process.

Screen CVs and score candidates with Gmail, Google Drive, OpenAI, and Sheets

Workflow preview

Overview

Who's it for

How it works

How to set up

Requirements