Automate candidate rejections with Google Sheets, GPT-4o-mini, Gmail & ClickUp
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, ClickUp, Azure OpenAI Chat Model and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Basic LLM Chain: sends a prompt to an LLM, with model: Azure OpenAI Chat Model
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- If: checks a condition and branches into true / false
- Basic LLM Chain: sends a prompt to an LLM, with model: Azure OpenAI Chat Model
- Code: runs custom JavaScript code
- Basic LLM Chain: sends a prompt to an LLM, with model: Azure OpenAI Chat Model
- Code: runs custom JavaScript code
- Create a task (ClickUp): uses ClickUp
…plus 5 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 (9)
- Google Sheets
n8n-nodes-base.googleSheets - Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - ClickUp
n8n-nodes-base.clickUp - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set
From the author
Description This workflow automates the candidate rejection process after interviews. It retrieves interview feedback from Google Sheets, uses AI to structure and score candidate data, applies a scoring threshold, and routes underperforming candidates into a…