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