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

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