Personalize candidate feedback with GPT-4o, Google Sheets & Gmail for HR teams

by Rahul Joshi ✓ · 189 views · created 2025-10-01 · HR

What this workflow does

This AI workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Google Drive, Azure OpenAI Chat Model and Gmail.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. 📑 Candidate Data Fetch (Google Sheets): uses Google Sheets
2. 📥 Resume Downloader (Google Drive): download
3. Resume File Check (If): checks a condition and branches into true / false
4. PDF → Text Extractor (Extract from File): extracts data from a file (pdf)
5. Error Logging (Google Sheets): append
6. Candidate Data Builder (Code): runs custom JavaScript code
7. Shortlisted vs Rejected (If): checks a condition and branches into true / false
8. Congrats + Onboarding Plan (Basic LLM Chain): sends a prompt to an LLM, with model: LLM Backend
9. Polite Rejection + Learning Plan (Basic LLM Chain): sends a prompt to an LLM, with model: LLM Backend
10. Candidate Mailer – Shortlisted (Gmail): uses Gmail

…plus 1 more step. See the full node list below.

Services it uses

Google SheetsGoogle DriveAzure OpenAI Chat ModelGmail

Before you upgrade to n8n 3.0

Nodes used (9)

• Manual Triggern8n-nodes-base.manualTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Google Driven8n-nodes-base.googleDrive
• Ifn8n-nodes-base.if
• Extract from Filen8n-nodes-base.extractFromFile
• Coden8n-nodes-base.code
• Azure OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatAzureOpenAi
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Gmailn8n-nodes-base.gmail

From the author

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…

View the original on n8n.io → Check your own copy