All-in-one Telegram/Baserow AI assistant 🤖🧠 Voice/Photo/Save notes/Long term mem

Telegram Personal Assistant with Long-Term Memory & Note-Taking

This n8n workflow transforms your Telegram bot into a powerful personal assistant that handles voice, photo, and text messages. The assistant uses AI to interpret messages, save important details as long-term memories or notes in a Baserow database, and recall information for future interactions.

---

🌟 How It Works

1. Message Reception & Routing - Telegram Integration: The workflow is triggered by incoming messages on your Telegram bot. - Dynamic Routing: A switch node inspects the message to determine whether it's voice, text, or photo (with captions) and routes it for the appropriate processing.

2. Content Processing - Voice Messages: Audio files are retrieved and sent to an AI transcription node to convert spoken words into text. - Text Messages: Text is directly captured and prepared for analysis. - Photos: If an image is received, the bot fetches the file (and caption, if provided) and uses an AI-powered image analysis node to extract relevant details.

3. AI-Powered Agent & Memory Management - The core AI agent (powered by GPT-4o-mini) processes the incoming message along with any previous conversation history stored in PostgreSQL memory buffers. - Long-Term Memory: When a message contains personal or noteworthy information, the assistant uses a dedicated tool to save this data as a long-term memory in Baserow. - Note-Taking: For specific instructions or reminders, the assistant saves concise notes in a separate Baserow table. - The AI agent follows defined rules to decide which details are saved as memories and which are saved as notes.

4. Response Generation - After processing the message and updating memory/notes as needed, the AI agent crafts a contextual and personalized response. - The response is sent back to the user via Telegram, ensuring smooth and natural conversation flow.