ResumeXray

Automated Resume Processing System

Presentation Document

December 31, 2025

ResumeXray

AI-Powered Applicant Tracking System

Fully Automated Resume Processing Pipeline

Zero Manual Intervention Required

How It Works

ResumeXray automatically processes incoming resume emails, extracts candidate information using AI, and stores everything in a centralized database. The entire workflow runs seamlessly from email reception to database storage without any human intervention.

Email Trigger

Gmail automatically triggers when new resume arrives

AI Analysis

Groq AI extracts and analyzes resume data

Auto Storage

Data automatically saved to MySQL database

Complete Workflow Lifecycle

1

Incoming Resume Email (Gmail Trigger)

When a candidate sends a resume email to HR, N8N workflow automatically triggers.

Key Requirements:

  • Gmail Trigger must have "Download Attachments" ENABLED
  • Only emails with attachments are processed
  • Attachments are available in $binary format
2

Attachment Exists Check

System verifies if the email contains any attachments before proceeding.

Validation Logic:

Object.keys($binary || {}).length > 0

If no attachment found, workflow stops. Only resumes with attachments proceed.

3

Resume Content Validation

Checks if email content indicates a resume or job application using keyword matching.

Keywords Checked:

(resume|cv|job|career|apply|application|opening|position|hiring)

Important: This validates email intent only, NOT file type. Filters out unrelated emails.

4

Validate Resume File Type

Ensures only supported resume file formats are processed.

MIME Type Check:

{{ $binary.attachment_0.mimeType }}

Supported Formats:

PDF DOC DOCX
5

Parallel Processing (Two Nodes)

Two processes run simultaneously for efficiency.

Upload to Google Drive

Original resume file is backed up to Google Drive for safe storage and manual review.

Extract Text from PDF

Text is extracted from PDF/DOC/DOCX files to prepare for AI analysis.

AI Resume Analyzer (Groq AI)

The extracted text is sent to Groq AI model for intelligent analysis and data extraction.

AI Model:

llama-3.1-8b-instant

What AI Does:

  • Extracts candidate information (name, email, phone, location)
  • Identifies skills, education, and experience
  • Calculates role-based scores (0-100 for each metric)
  • Generates professional resume summary (200-250 words)
  • Returns structured JSON data ready for database
7

Parse AI JSON Output

AI response is parsed and formatted for database storage.

Processing Steps:

  • JSON.parse(response) - Parse AI response
  • Map fields to database columns
  • Convert data types (booleans, dates, etc.)
  • Validate required fields (name, email)
8

Store in MySQL Database

Candidate data is stored or updated in the centralized MySQL database.

Storage Logic:

  • Match on Email: Email is the unique identifier
  • New Candidate: Insert new record if email doesn't exist
  • Existing Candidate: Update record if email already exists
  • Prevents Duplicates: One record per candidate email

AI Scoring System

How candidates are evaluated (0-100 scale)

Skill Match Score

85

Evaluates how well candidate's skills match the applied role requirements.

90-100: All required skills + bonus skills

70-89: Most required skills present

50-69: Partial skill match

0-49: Weak or no match

Experience Score

78

Assesses if experience level is appropriate for the role.

90-100: Ideal experience level

70-89: Good experience, slightly under/over

50-69: Moderate, may need training

0-49: Insufficient experience

Education Score

82

Evaluates educational qualifications relevance to the role.

90-100: Perfect education for role

70-89: Relevant education level

50-69: Acceptable, somewhat relevant

0-49: Insufficient education

Resume Quality Score

88

Measures overall resume structure, clarity, and professionalism.

90-100: Excellent structure & clarity

70-89: Good resume quality

50-69: Average, some gaps

0-49: Poor quality

Overall Score

Average of all four scores

83
Out of 100

After Database Storage

HR Dashboard & Candidate Management Features

Dashboard Analytics

Real-time statistics, recent candidates, and pipeline overview

Candidate List

View all candidates with filtering, search, and pagination

Detailed Profiles

Complete candidate information, scores, and AI analysis

Status Management

Shortlist, reject, or update candidate status with reasons

Key Benefits

Time Saving

Automated processing eliminates manual resume review, saving hours daily.

AI-Powered

Intelligent analysis provides accurate candidate evaluation and scoring.

Zero Errors

Automated workflow ensures consistent data extraction and storage.

This presentation document explains the complete ResumeXray workflow

Built with using Laravel 12, N8N, Groq AI & MySQL