Process Multiple Media Files in Telegram with Gemini AI & PostgreSQL Database

🤖📨 Telegram AI Assistant with Multi-File Media Group Handling, Smart File Processing & PostgreSQL Integration

> AI-powered Telegram bot for text, voice, video, documents & media — with database-driven grouping and Telegram-safe formatting.

📋 Description

This n8n template creates a next-generation Telegram AI assistant 🧠💬 capable of handling text messages, media files, and documents with advanced processing, PostgreSQL integration, and AI-powered responses.

It is designed to solve Telegram’s media group challenge 📦 — when multiple files are sent together, they are stored, processed, and combined into one coherent AI-generated reply.

✨ Key Features 📂 Multi-file media group management with PostgreSQL: media_group media_queue chat_histories 📑 Document parsing for CSV, HTML, ICS, JSON, ODS, PDF (with AI fallback), RTF, TXT, XML, and spreadsheets. 🎤 Voice & video transcription for AI analysis. 🖼️ Image, audio, and video description for richer AI context. 🛡️ Telegram-safe MarkdownV2 formatting with auto-splitting for messages over 4096 chars. ⚠️ Error fallback for unsupported file types.

💡 Acknowledgment

A huge thank you to Ezema Gingsley Chibuzo 🙌 for the inspiration of the first version of this workflow:
Create a Multi-Modal Telegram Support Bot with GPT-4 and Supabase RAG
Your pioneering work laid the foundation for this improved, database-powered multi-modal assistant 🚀

🏷 Tags telegram ai-assistant postgresql multi-file media-group
file-processing voice-transcription document-parser pdf-extraction
markdown-formatting n8n-template

💼 Use Case Use this template if you need an AI-powered Telegram bot that can: 📦 Handle multiple files sent in a single message (albums, multiple PDFs, etc.). 🧾 Extract & analyze content from many file formats. 🎙️ Transcribe voice and video messages. 🗂️ Maintain chat memory for contextual AI answers. 🛡️ Avoid Telegram formatting errors and length limit issues.

This workflow automates the full chain: Receive → Process → AI Analysis → Telegram-safe Reply.

💬 Example User Interactions

📄 Multiple PDFs with a caption** → AI extracts and summarizes all PDFs in one combined reply.
🎤 Voice message** → AI transcribes and replies with a contextual answer.
📊 CSV or spreadsheet file** → AI parses and summarizes the data.
🖼️ Multiple images** → AI describes each image and replies in a single message.

🔑 Required Credentials Telegram Bot API** (Bot Token)
PostgreSQL** (Connection credentials)
AI Provider API** (OpenAI, Google Gemini, or compatible LLM)

⚙️ Setup Instructions 🗄️ Create the PostgreSQL tables (Gray section SQL): media_group media_queue chat_histories 🔌 Configure the Telegram Trigger with your bot token. 🤖 Connect your AI provider credentials. 🗂️ Set up PostgreSQL credentials in the database nodes. ▶️ Deploy the workflow in n8n. 🎯 Start sending messages and files to your bot.

📌 Extra Notes ✅ Green section ensures only one trigger per media group.
📌 Yellow section guarantees captions and files are stored in the correct sequence.
✨ Purple section formats AI output to be Telegram-safe and split if needed.
🧠 AI prompt is not fixed, allowing full customization.

💡 Need Assistance?

If you’d like help customizing or extending this workflow, feel free to reach out:

📧 Email: johnsilva11031@gmail.com
🔗 LinkedIn: John Alejandro Silva Rodríguez