Build an OpenAI HR assistant for Telegram attendance and salary reports
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 41 nodes and runs on Telegram events (message) (plus 1 other trigger). Along the way it connects Telegram, Google Sheets, OpenAI Chat Model and Google Gemini Chat Model.
How it runs
Trigger: On Telegram events (message) (plus 1 other trigger).
- Route_New_vs_Existing (Switch): routes items into 3 branches
- Fetch_Today_Logs (Google Sheets): uses Google Sheets
- Fetch_All_Employees (Google Sheets): uses Google Sheets
- Msg_Ask_New_Emp_Data (Telegram): uses Telegram
- Agent_Onboarding (AI Agent): runs an AI agent, with model: Model_Onboarding; memory: Memory_Onboarding
- Agent_Classifier (AI Agent): runs an AI agent, with model: Model_Classifier; memory: Memory_Chat
- Filter: keeps only the items that match a condition
- Merge: merges the data from its input branches
- Validate_New_Emp_JSON (Code): runs custom JavaScript code
- Parse_AI_Response (Code): runs custom JavaScript code
…plus 23 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)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Telegram
n8n-nodes-base.telegram - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Switch
n8n-nodes-base.switch - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Filter
n8n-nodes-base.filter - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Merge
n8n-nodes-base.merge
From the author
What Problem Does It Solve? - HR managers waste hours manually logging attendance, calculating work hours, and tracking salary advances in spreadsheets. - Onboarding new staff often involves messy paperwork or scattered chat messages. - Salary calculations…