Automate end-to-end hiring with Keka, Google Sheets, Gmail and GPT-4
Ready for 3.0What this workflow does
This AI workflow has 152 nodes and runs on a schedule (every day) (plus 10 other triggers). Along the way it connects Google Sheets, Gmail and OpenAI.
How it runs
Trigger: On a schedule (every day) (plus 10 other triggers).
- Init Run Storage (Code): runs custom JavaScript code
- Read Master Recruitment For Feedback (Google Sheets): uses Google Sheets
- Jia Token Manager (Execute Sub-workflow): calls another n8n workflow
- Read Master Recruitment For Feedback (Google Sheets): uses Google Sheets
- Jia Token Manager (Execute Sub-workflow): calls another n8n workflow
- Read Master Recruitment For Feedback (Google Sheets): uses Google Sheets
- Read Master Recruitment For Feedback (Google Sheets): uses Google Sheets
- Read Master Recruitment For Feedback (Google Sheets): uses Google Sheets
- Read sheet with intetrview pending (Google Sheets): uses Google Sheets
- Keka Token Manager (Execute Sub-workflow): calls another n8n workflow
…plus 131 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set - OpenAI
@n8n/n8n-nodes-langchain.openAi - Merge
n8n-nodes-base.merge - Extract from File
n8n-nodes-base.extractFromFile - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Execute Sub-workflow
n8n-nodes-base.executeWorkflow
From the author
Complete End-to-End Process Description 🔹 Phase 1: Application Collection & Initial Notification The process begins when candidates apply for active job openings. All applications are automatically collected and stored in the Master Recruitment Sheet. This…