AI Resume Screening with Gmail, GPT-4o & Google Sheets - Automated Hiring Pipeline

Description

AI Resume Screening with GPT-4o & Google Drive - Automated Hiring Pipeline

How it works

Transform your hiring process with this intelligent automation that screens resumes in minutes, not hours. The workflow monitors your Gmail inbox, processes resume attachments using AI analysis, and delivers structured candidate evaluations to a centralized Google Sheets dashboard.

Key workflow steps:
Email Detection - Monitors Gmail for resume attachments (PDF, DOCX, TXT)
File Processing - Uploads to Google Drive and extracts text content
AI Analysis - GPT-4o evaluates candidates against job requirements
Data Extraction - Pulls contact info and key qualifications automatically
Results Logging - Saves structured analysis to Google Sheets for team review

Set up steps

Total setup time: 15-20 minutes

Required Credentials (5 minutes)
Gmail account with OAuth2 access
Google Drive API credentials
Google Sheets API access
OpenAI API key for GPT-4o

Configuration Steps (10 minutes)
Connect Gmail trigger - Authorize email monitoring
Set up Google Drive folder - Choose destination for resume files
Create tracking spreadsheet - Copy the provided Google Sheets template
Add OpenAI credentials - Insert your API key for AI analysis
Customize job description - Update the role requirements in the "Job Description" node

Optional Customization (5 minutes)
Modify AI scoring criteria in the recruiter prompt
Adjust candidate information extraction fields
Customize Google Sheets column mapping

No coding required - All configuration happens through the n8n interface using pre-built nodes and simple dropdown selections.

Template Features

Smart File Handling
Supports PDF, Word documents, and plain text resumes
Automatic format conversion and text extraction
Intelligent routing based on file type

AI-Powered Analysis
GPT-4o evaluation against job requirements
Structured scoring with strengths/weaknesses breakdown
Risk and opportunity assessment for each candidate
Actionable next-steps recommendations

Seamless Integration
Direct Gmail inbox monitoring
Automatic Google Drive file organization
Real-time Google Sheets dashboard updates
Clean data extraction for CRM integration

Professional Output
Standardized candidate scoring (1-10 scale)
Detailed justification for each evaluation
Contact information extraction
Resume quality validation

Perfect for HR teams, recruiting agencies, and growing companies looking to streamline their hiring pipeline with intelligent automation.