University FAQ & calendar assistant with Telegram, MongoDB and Gemini AI

by Club de Inteligencia Artificial Politécnico CIAP ✓ · 8,591 views · created 2025-11-09 · Support Chatbot, AI Chatbot

What this workflow does

This AI workflow has 53 nodes and runs on a schedule (every 7 days) (plus 2 other triggers). Along the way it connects Telegram, MongoDB, Google Gemini and Google Sheets and 1 more. It also calls espol.edu.ec and ttsmp3.com over HTTP.

How it runs

Trigger: On a schedule (every 7 days) (plus 2 other triggers).

1. SCRRAPPING (HTTP Request): calls espol.edu.ec
2. BD_CALENDARIO (Google Sheets): uses Google Sheets
3. Switch: routes items into 3 branches
4. HTML: parses or builds HTML
5. ACTIVIDADES DE LA SEMANA (Code): runs custom JavaScript code
6. Respuesta Usuario (Switch): routes items into 2 branches
7. Guardado en cvs Feedback (Google Sheets): append
8. Comandos (Switch): routes items into 6 branches
9. Detector_Calendario_Pre (Code): runs custom JavaScript code
10. Split Out: splits a list into separate items

…plus 37 more steps. See the full node list below.

Services it uses

TelegramMongoDBGoogle GeminiGoogle SheetsGoogle Gemini Chat Model

HTTP calls to: espol.edu.ec, ttsmp3.com

Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).

Before you upgrade to n8n 3.0

Nodes used (16)

• Coden8n-nodes-base.code
• Switchn8n-nodes-base.switch
• Telegramn8n-nodes-base.telegram
• MongoDBn8n-nodes-base.mongoDb
• Telegram Triggern8n-nodes-base.telegramTrigger
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Google Sheetsn8n-nodes-base.googleSheets
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Google Sheets Tooln8n-nodes-base.googleSheetsTool
• AI Agent@n8n/n8n-nodes-langchain.agent
• Waitn8n-nodes-base.wait
• HTTP Requestn8n-nodes-base.httpRequest
• Edit Fields (Set)n8n-nodes-base.set
• Split Outn8n-nodes-base.splitOut
• HTMLn8n-nodes-base.html
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

🤖 Interactive Academic Chatbot (Telegram + MongoDB) Overview 📋 This project is a template for building a complete academic virtual assistant using n8n. It connects to Telegram, answers frequently asked questions by querying MongoDB, keeps the community…

View the original on n8n.io → Check your own copy