Intelligent Email Assistant: Your AI-Powered Telegram Chatbot
detail.loadingPreview
Revolutionize your email management with this AI-powered Telegram chatbot. It seamlessly blends semantic understanding with structured data retrieval to answer your queries intelligently and efficiently.
About This Workflow
This n8n workflow empowers you to interact with your email inbox via Telegram using a sophisticated AI assistant. It leverages a powerful combination of semantic search with Pgvector and structured data retrieval through a dedicated SQL workflow. When you send a message to your Telegram bot, it intelligently determines the best approach to find the information you need. Whether it's a broad question requiring semantic understanding or a specific query needing structured data, this workflow ensures you get accurate and relevant answers directly in your chat.
Key Features
- Dual RAG Approach: Combines semantic and structured retrieval for comprehensive email search.
- Telegram Integration: Interact with your AI assistant seamlessly through your Telegram app.
- Pgvector Power: Utilizes a robust vector database for efficient semantic similarity searches.
- SQL Data Access: Integrates with a structured database for precise, targeted email queries.
- Intelligent Query Routing: Automatically directs your requests to the most appropriate retrieval method.
How To Use
- Set up Telegram Trigger: Configure the
Telegram Triggernode with your bot's API token and desired chat ID. - Connect to Pgvector: In the
Postgres PGVector Storenode, provide your PostgreSQL connection details and specify your email embeddings table (emails_embeddings). ConfiguretoolNameandtoolDescriptionfor optimal retrieval. - Integrate SQL Search: Set up the
Call the SQL composer Workflownode. Ensure theworkflowIdpoints to your 'Generate email SQL queries' workflow and configure theworkflowInputsto map the natural language query. - Configure Embedding: Use the
Embeddings Ollamanode to process text for vectorization, ensuring it's connected to your Ollama API. - Process and Respond: The
Split text into chunksnode prepares long responses for Telegram, while theBeautify chat responsenode formats them. Finally, theRespond on Telegram in batchesnode sends the formatted answers back to your Telegram chat.
Apps Used
Workflow JSON
{
"id": "af138347-314c-4d23-a8f2-b8d1ae0d7e3d",
"name": "Intelligent Email Assistant: Your AI-Powered Telegram Chatbot",
"nodes": 13,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: af138347-314c...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.
Automate LinkedIn Content Promotion for Your Ghost Blog with AI
Effortlessly promote your latest Ghost blog posts on LinkedIn. This workflow leverages AI to generate engaging, professional LinkedIn messages based on your article content and saves them, along with article metadata, directly to a Google Sheet.