Screen Resumes & Send Follow-ups with OpenAI GPT-4o, Google Sheets & Gmail

Description

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

🧠 How It Works

This workflow automates the process of screening resumes using AI, logging results to Google Sheets, and sending follow-up emails via Gmail.

User uploads their resume via a form (PDF only).
Resume content is extracted and sent to OpenAI for evaluation.
AI scores the resume based on:
Role-specific must-have qualifications
Soft skills / strategic fit questions
Based on the score threshold, the candidate is classified as:
✅ Accepted → Saved to Accepted sheet + Gmail invite
❌ Rejected → Logged to Rejected sheet + Gmail rejection message
Output is stored in Google Sheets with detailed justification.

⚙️ Set Up Steps

🔑 Connect your OpenAI and Google Sheets credentials.
Replace the placeholder tags in the AI prompt:
COMPANY_NAME
ROLE_NAME
ROLE_DESCRIPTION
CRITERIA_1 to CRITERIA_5
Q1 to Q5
THRESHOLD (score to pass)
Customize Gmail messages (optional).
✅ Make sure your sheet has two tabs: Accepted and Rejected.

📌 Notes

Sticky Notes included in the flow explain:
What each node does
Where to replace variables
Tips for improving match scoring