Personalize Candidate Feedback with GPT-4o, Google Sheets & Gmail for HR Teams

Description

This workflow automates personalized candidate communication for both shortlisted and rejected applicants. It fetches candidate details, processes resumes, checks for errors, and uses GPT-4o to generate professional HTML emails. Shortlisted candidates receive congratulatory onboarding plans, while rejected candidates receive polite rejections with learning resources.

What This Template Does (Step-by-Step)

• ⚡ Manual Trigger – Starts the workflow execution.
• 📑 Candidate Data Fetch (Google Sheets) – Pulls structured candidate data (name, email, resume link, skills, job info, status).
• 📥 Resume Downloader (Google Drive) – Downloads candidate resumes from sheet links.
• ✅ Resume File Check (If Condition) – Ensures the resume file is valid before proceeding.
• ⚠️ Error Logging (Google Sheets) – Records failed or missing resumes in a dedicated sheet for audit.
• 📄 PDF → Text Extractor – Extracts raw resume text for deeper AI analysis.
• 🧩 Candidate Data Builder (Code Node) – Combines Google Sheets data with extracted resume text into a single enriched JSON object.
• 🎯 Shortlisted vs Rejected (If Condition) – Splits candidates into two flows based on their status field.

Shortlisted Path

🎉 Congrats + Onboarding Plan (LLM Chain) – GPT-4o generates a congratulatory HTML email including:

• Identified skill gaps
• Recommended online courses (Coursera/Udemy/LinkedIn Learning)
• Next onboarding steps
  📧 Candidate Mailer – Shortlisted (Gmail) – Sends the onboarding email directly to the candidate.

Rejected Path

🙏 Polite Rejection + Learning Plan (LLM Chain) – GPT-4o generates a professional rejection email including:

• Empathetic rejection message
• Constructive feedback on skill gaps
• Learning resources to improve for future opportunities
  📧 Candidate Mailer – Rejected (Gmail) – Sends the polite rejection + learning plan to the candidate.

Prerequisites

• Google Sheets (candidate database + error log)
• Google Drive (resume storage)
• Gmail API (for sending candidate emails)
• Azure OpenAI (GPT-4o-mini model access)

Key Benefits

✅ Automates candidate communication (both shortlisted & rejected)
✅ Delivers professional, HTML-ready emails
✅ Enhances candidate experience with personalized learning plans
✅ Prevents silent rejections by providing constructive resources
✅ Improves employer branding with empathetic communication
✅ Error resilience via logging and validation steps

Perfect For

• Recruitment teams managing high candidate volume
• Companies looking to humanize rejections
• HR departments that want automated but personalized communication
• Organizations investing in candidate experience & employer brand