FM
FlowMarket
Email & Outreach Intermediate ⚡ 7 n8n Nodes

Screen and score resumes from Gmail to Sheets with AI

Description This intelligent n8n automation streamlines the process of collecting, extracting, and scoring resumes sent to a Gmail inbox—making it an ideal s...

🔌 Nodes & Integrations Used (1)

n8n Core Logic

📖 Implementation & Setup Guide

Description

This intelligent n8n automation streamlines the process of collecting, extracting, and scoring resumes sent to a Gmail inbox—making it an ideal solution for recruiters who regularly receive hundreds of applications. The workflow scans incoming emails with attachments, extracts relevant candidate information from resumes using AI, evaluates each candidate based on customizable criteria, and logs their scores alongside contact details in a connected Google Sheet.

Who Is This For?

  • **Recruiters & Hiring Managers**: Automate the resume screening process and save hours of manual work.
  • **HR Teams at Startups & SMBs**: Quickly evaluate talent without needing large HR ops infrastructure.
  • **Agencies & Talent Acquisition Firms**: Screen large volumes of resumes efficiently and with consistent criteria.
  • **Solo Founders Hiring for Roles**: Use AI to help score and shortlist top candidates from email applications.

What Problem Does This Workflow Solve?

Manually reviewing resumes is time-consuming, error-prone, and inconsistent. This workflow solves these challenges by:

  • Automatically detecting and extracting resumes from Gmail attachments.
  • Using OpenAI to intelligently extract candidate info from unstructured PDFs.
  • Scoring resumes using customizable evaluation criteria (e.g., relevant experience, skills, education).
  • Logging all candidate data (Name, Email, LinkedIn, Score) in a centralized, filterable Google Sheet.
  • Enabling faster, fairer, and more efficient candidate screening.

How It Works

1. Gmail Trigger - Runs on a scheduled interval (e.g., every 6 or 24 hours). - Scans a connected Gmail inbox (using OAuth credentials) for unread emails that contain PDF attachments.

2. Extract Attachments - Downloads the attached resumes from matching emails.

3. Parse Resume Text - Sends the PDF file to OpenAI's API (via GPT-4 or GPT-3.5 with file support or via base64 + PDF-to-text tool). - Prompts GPT with a structured format to extract fields like Name, Email, LinkedIn, Skills, and Education.

4. Score Resume - Evaluates the resume on predefined scoring logic using AI or logic inside the workflow (e.g., "Has X skill = +10 points").

5. Log to Google Sheets - Appends a new row in a connected Google Sheet, including: - Candidate Name - Email Address - LinkedIn URL - Resume Score

Setup

Accounts & API Keys You’ll need accounts and credentials for:

  • **n8n** (hosted or self-hosted)
  • **Google Cloud Platform** (for Gmail, Drive, and Sheets APIs)
  • **OpenAI** (for GPT model access)

Google Sheet - Make a Google Sheet and connect it via Google Sheets node in n8n. Columns should include: - Name - Email - LinkedIn - Score

Configuration

Google Cloud: - Enable Gmail API and Google Sheets API. - Set up OAuth 2.0 Credentials in Google Console. - Connect n8n Gmail, Drive, and Sheets nodes to these credentials.

OpenAI: - Generate an API Key. - Use the HTTP Request node or official OpenAI node to send prompt requests.

n8n Workflow: - Add Gmail Trigger. - Add extraction logic (e.g., filter PDFs). - Add OpenAI prompt for resume parsing and scoring. - Connect structured output to a Google Sheets node.

Requirements

Accounts: - **n8n** - **Google** (Gmail, Sheets, Drive, Cloud Console) - **OpenAI**

API Keys & Credentials: - OpenAI API Key - Google Cloud OAuth Credentials - Gmail Access Scopes (for reading attachments) - Configured Google Sheet - OpenAI usage (after free tier) - Google Cloud API usage (if exceeding free quota)

⚡ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save Screen and score resumes from Gmail to Sheets with AI.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related Email & Outreach Workflows

View All in Email & Outreach →