← All projects
/ Case study · Platform
Telegram bot + admin panel
A project designed as an alternative to a traditional portfolio: instead of browsing a website, projects are explored from Telegram, with navigation and content managed from an admin panel.
- Role
- Full-stack design and implementation (bot, REST API and admin panel).
- Duration
- 8 weeks
- Client
- Ministerio de Comunicación Pública
- Year
- 2024
Screenshots
QR code to open the bot 
Access token to try the bot 
Welcome message in Telegram 
Main commands menu 
The projects command in Telegram 
Topics inside the projects command 
A topic message rendered with HTML 
Admin panel: menus and topics (sample data) 
Message editor with Telegram formatting (sample data) 
Statistics by menu and topic (sample data) 
Desktop: fixed side menu and expandable menus (sample data) 
Message list and editor with bold, italic and links (sample data) 
Registered users and most-viewed content by period (sample data)
The problem
Managing a bot's content and navigation used to require code changes, which created operational friction and slowed publishing.
The solution
A platform with a Telegram bot plus an admin panel to edit menus, topics, messages and dynamic commands without constant deploys, centralising operations in a visual interface.
Technical details
Front end
- React
- TypeScript
- Vite
- MUI
- Recharts
Back end
- Node.js
- Express
- grammY
- JWT
Data
- MySQL
- TiDB Cloud
- Sequelize
Features
- Management of the welcome message, menus, topics and messages
- Dynamic commands for navigation in Telegram
- Global topics not tied to a single menu
- Message editor with Telegram formatting: bold, italic, underline, strikethrough, links and paste
- Responsive panel navigation: tabs on mobile, fixed side menu on desktop
- Token and user panel for secure administration
- Statistics by interactions and periods
Infrastructure
- Render (API + webhook)
- Netlify/Vercel (admin panel)
- Uptime monitoring with cron-job.org
Result
- Faster publishing of content in the bot
- Less operational friction in maintenance
- Centralised administration of the conversational flow