Communication & Messaging
e-mail Chatbot with both semantic and structured RAG, using Telegram and Pgvector
e-mail Chatbot with both semantic and structured RAG, using Telegram and Pgvector
Complex
High
20
Nodes
Complex
Trigger
High
Complexity
7/22/2025
Added
Workflow Overview
Total Nodes
20
Node Types
15
Node Types
telegram
Respond on Telegram in batches
1 node
telegram Trigger
Telegram Trigger
1 node
split In Batches
Loop Over Items
1 node
if
Came from Telegram?
1 node
chat Trigger
When chat message received
1 node
vector Store P G Vector
Postgres PGVector Store
1 node
tool Workflow
Call the SQL composer Workflow
1 node
embeddings Ollama
Embeddings Ollama
1 node
set
Beautify chat response, Generate session id
2 nodes
code
Escape Markdown, Split text into chunks
2 nodes
no Op
No Operation, do nothing
1 node
sticky Note
Sticky Note, Sticky Note1, Sticky Note2, Sticky Note3
4 nodes
memory Buffer Window
Simple Memory
1 node
agent
AI Agent
1 node
lm Chat Open Ai
OpenAI Chat Model
1 node
Workflow JSON
17.78 KB
{
"id": "LPQsiqt476n7ne7f",
"meta": {
"instanceId": "8a3ba313628b26e4e4cf0504ff23322f235d6b433d92e59bcf8762764730ed80",
"templateCredsSetupCompleted": true
},
"name": "e-mail Chatbot with both semantic and structured RAG, using Telegram and Pgvector",
"tags": [],
"nodes": [
{
"id": "f0707b32-4d10-457c-9c5e-d120123da4cb",
"name": "Telegram Trigger",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-180,
180
],
"webhookId": "1ac710ec-9d76-432e-9cbe-c569db85363f",
"parameters": {
"updates": [
"message"
],
"additionalFields": {
"chatIds": "6865163996"
}
},
"credentials": {
"telegramApi": {
"id": "ODwnm0QOyG3qSae4",
"name": "Telegram mailsearch_plaintext_bot"
}
},
"typeVersion": 1.2
},
{
"id": "2ed04863-6ff8-4770-ad1a-1cab65ac7233",
"name": "Loop Over Items",
"type": ...Showing first 1000 characters. Click "Expand" to view the full JSON.