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: - mediagroup - mediaqueue - chathistories - 📑 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 1. 🗄️ Create the PostgreSQL tables (Gray section SQL): - mediagroup - mediaqueue - chathistories 2. 🔌 Configure the Telegram Trigger with your bot token. 3. 🤖 Connect your AI provider credentials. 4. 🗂️ Set up PostgreSQL credentials in the database nodes. 5. ▶️ Deploy the workflow in n8n. 6. 🎯 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