Score WhatsApp PDF resumes with OpenAI GPT-4o-mini and Supabase

Name: Score WhatsApp PDF resumes with OpenAI GPT-4o-mini and Supabase
Availability: InStock
Author: Panth1823

Score WhatsApp PDF resumes with OpenAI GPT-4o-mini and Supabase 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

WhatsApp Resume Ranking Bot — AI-Powered Career Score via PDF Upload

Let job seekers check their resume strength directly on WhatsApp — no app, no sign-up, no friction. Users send a keyword, answer 2 quick questions, upload their PDF resume, and receive a personalized career score, ATS feedback, and rejection analysis in under 60 seconds.

Who is this for?

Career coaches, job portals, HR-tech startups, or recruitment agencies who want to offer a self-serve resume evaluation tool directly inside WhatsApp — where their audience already is.

What this workflow does

Listens for incoming WhatsApp messages via the WhatsApp Business Cloud API
Manages multi-turn conversation state in Supabase — tracks each user's progress through the flow (idle → name → role → resume → processing)
Guides the user step-by-step to provide their name, target job role, and PDF resume
Downloads the resume PDF from WhatsApp's media server using the Business API
Extracts resume text for analysis
Runs a Scoring Engine that calculates a career score (0–100) based on resume content and target role
Calls OpenAI (GPT-4o-mini) in parallel to generate rejection reasons and actionable improvement tips
Merges both results and formats a final WhatsApp message
Sends the personalized report back to the user — score, weaknesses, and what to fix

Prerequisites

A WhatsApp Business Cloud API account (Meta Developer App in Live mode)
A Supabase project with a whatsapp_sessions table
An OpenAI API key (GPT-4o-mini recommended)
A self-hosted n8n instance or n8n Cloud

Supabase table setup

Create a table called whatsapp_sessions with these columns:

Column	Type	Notes
`phone`	text	Primary key / unique
`state`	text	Conversation state (IDLE, WAITING_NAME, etc.)
`name`	text	User's name
`target_role`	text	Job role they're targeting
`started_at`	timestamptz	Session start time
`updated_at`	timestamptz	Last activity timestamp

Setup steps

Connect WhatsApp Business API credentials in n8n (Meta App token + Phone Number ID)
Connect OpenAI credentials in n8n
Update the Supabase URL and API key inside the Conversation State Manager Code node
Replace YOUR_PHONE_NUMBER_HERE in the Send nodes with your WhatsApp Phone Number ID
Set up Meta webhook pointing to your n8n WhatsApp Trigger URL, subscribed to messages
Activate the workflow — users can now send CHECK MY RANK to trigger the bot

Conversation flow

User: CHECK MY RANK
Bot: Intro + "Type YES to start"
User: YES
Bot: "What's your full name?"
User: Rahul Sharma
Bot: "Which job role are you targeting?"
User: Data Analyst
Bot: "Upload your resume as a PDF"
User: [uploads PDF]
Bot: "Analyzing... hang tight 🔍"
Bot: [sends career score + rejection reasons + tips]

Customization

Modify the Scoring Engine Code node to adjust how the score is calculated (weights for skills, experience, formatting, etc.)
Edit the OpenAI prompt to change the tone or depth of feedback
Add a Supabase insert after analysis to log all submissions for your own analytics
Extend the flow to offer a paid detailed report or booking link after the free score

⚠️ Important notes

The WhatsApp App must be in Live mode (not sandbox) to receive messages from non-whitelisted numbers — requires completing Meta Business Verification
Only PDF resumes are supported; DOCX files are rejected with a helpful prompt
Session state persists in Supabase, so users can resume mid-flow if they get disconnected
The bot handles concurrent users independently via phone number as the session key

Panth1823

12 workflows

Complexity

advanced

Published 06 Apr 2026

Likes 0

View on n8n.io Download Workflow

Install path: /data/workflows/14814/14814.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.

Score WhatsApp PDF resumes with OpenAI GPT-4o-mini and Supabase

Workflow preview

Overview

WhatsApp Resume Ranking Bot — AI-Powered Career Score via PDF Upload

Who is this for?

What this workflow does

Prerequisites

Supabase table setup

Setup steps

Conversation flow

Customization

⚠️ Important notes