Workflow overview
Why this workflow matters
Useful for software delivery and engineering operations. Improves internal consulting operations and productivity.
π€π¨ 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 AlekSystem 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 AlekSystem-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 AlekSystem. π― 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
Best fit
Categories
Services
Use cases
Need another direction?