n8n workflow template · 21 nodes · Postgres
HR & IT Helpdesk Chatbot with Audio Transcription is a free n8n workflow template that starts from the Telegram Trigger node and works with Postgres, OpenAI and Telegram. It has 21 nodes, 12 of them AI nodes (Postgres PGVector Store, OpenAI Embeddings, Default Data Loader and Recursive Character Text Splitter). The notes inside the workflow say: “Begin by importing the PDF documents that contain your internal policies and FAQs—these will become the knowledge base for your Internal Helpdesk Assistant.” To run it, you add your own credentials for OpenAI API, Postgres and Telegram Bot API.
The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.
Read more about the HTTP Request Tool
Begin by importing the PDF documents that contain your internal policies and FAQs—these will become the knowledge base for your Internal Helpdesk Assistant. For example, you can store a company handbook or IT/HR policy PDFs on a shared drive or cloud storage and reference a direct download link here.
In this demonstration, we'll use the HTTP Request node to fetch the PDF file from a given URL and then parse its text contents using the Extract from File node. Once extracted, these text chunks will be used to build the vector store that underpins your helpdesk chatbot’s responses.
Example Employee Handbook with Policies
Read more about the In-Memory Vector Store
Vector stores power the retrieval process by matching a user's natural language questions to relevant chunks of text. We'll transform your extracted internal policy text into vector embeddings and store them in a database-like structure.
We will be using PostgreSQL which has production ready vector support.
How it works
This workflow processes Telegram messages to handle text and voice inputs, with a fallback for unsupported message types. Here’s how it works
"Sorry, I couldn’t process your message. Please try again."
The simplest and most important part:)
The text below comes from the sticky notes inside the workflow. We removed links, code samples and anything that looks like a key or token.
The setup needs to be run at the start or when data is changed
n8n's AI agents allow you to create intelligent and interactive workflows that can access and retrieve data from internal knowledgebases. In this workflow, the AI agent is configured to provide answers for HR and IT queries by performing Retrieval-Augmented Generation (RAG) on internal documents.
By integrating the AI agent with a vector store and chat memory, this workflow empowers your HR & IT helpdesk chatbot to provide quick, accurate, and conversational support to employees.
PostgrSQL is used for all steps to simplify development in production.
The 21 nodes in file order (sticky notes excluded). Branches and connections determine execution order in n8n:
Configure your own credentials after importing. Create each credential in n8n, then select it in the node.
Do you need somewhere to run it? Read our guide to self-hosted n8n.
We can adapt this workflow to your apps, data and process, then deploy and support it.
Contact Us