Templates / Chat with your email history using Telegram, Mistral and Pgvector for RAG

Chat with your email history using Telegram, Mistral and Pgvector for RAG

Needs changes

by Alfonso Corretti ✓ · 4,591 views · created 2025-04-27 · Personal Productivity, AI RAG

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 16 nodes and runs on Telegram events (message) (plus 1 other trigger). Along the way it connects Telegram, Postgres PGVector Store, Embeddings Ollama and OpenAI Chat Model.

How it runs

Trigger: On Telegram events (message) (plus 1 other trigger).

  1. Generate session id (Edit Fields (Set)): sets or maps fields
  2. AI Agent: runs an AI agent, with model: OpenAI Chat Model; 2 tools (Postgres PGVector Store, Call the SQL composer Workflow); memory: Simple Memory
  3. Came from Telegram? (If): checks a condition and branches into true / false
  4. Split text into chunks (Code): runs custom JavaScript code
  5. Beautify chat response (Edit Fields (Set)): sets 1 field: output
  6. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  7. Escape Markdown (Code): runs custom JavaScript code
  8. Respond on Telegram in batches (Telegram): uses Telegram

Services it uses

TelegramPostgres PGVector StoreEmbeddings OllamaOpenAI Chat Model

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • AI Agent v1 (old agent modes) in AI Agent (v1.8): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).

Removed in 3.0Replace with
AI Agent v1 (old agent modes)
AI Agent (v1.8)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (14)

From the author

Who is this for? Everyone! Did you dream of asking an AI "what hotel did I stay in for holidays last summer?" or "what were my marks last semester like?". Dream no more, as vector similarity searches and this workflow are the foundations to make it possible…

Excerpt from Alfonso Corretti's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.