Multilingual Telegram Bot with Dynamic NocoDB Responses
detail.loadingPreview
This n8n workflow creates a smart Telegram bot capable of communicating in multiple languages. It dynamically fetches bot messages and manages user data from a NocoDB database, providing personalized interactions for new and returning users.
About This Workflow
Unlock global communication with this powerful n8n workflow designed for a multilingual Telegram bot. This automation seamlessly integrates with Telegram to listen for incoming messages, intelligently detect the user's language, and provide responses tailored to their preference. All bot messages are dynamically loaded from a NocoDB database, allowing for easy updates and expansion of supported languages without workflow changes. Furthermore, it tracks new and returning users, storing their information and last-used language in NocoDB, enabling personalized welcome messages and enhanced user management. Respond to commands like /start and /help with localized content, making your bot truly universal.
Key Features
- Multilingual Telegram Communication: Automatically detects user language and responds in their preferred language (with fallback).
- Dynamic Content from NocoDB: Store all bot messages and translations in a NocoDB database for easy management and real-time updates.
- User Management & Personalization: Track new and returning users, store their language preferences in NocoDB, and deliver personalized welcome messages.
- Command Handling: Efficiently processes common Telegram commands like
/startand/helpwith localized responses. - Modular & Extensible: Easily add new languages and bot messages by simply updating your NocoDB tables.
How To Use
- Set up Telegram Credentials: Ensure your Telegram Bot API credentials are configured in n8n.
- Prepare NocoDB: Create two tables in your NocoDB instance:
botmessages(to store translations, e.g., columns likebotmessage,en,ru) andTG_users(to store user data, e.g.,TG_account_ID,Last_language_used). - Configure NocoDB Credentials: Add your NocoDB API credentials (including
projectIdandhttpHeaderAuth) to theLoadDictionaryandCheckUsernodes, andHTTP AddUserandHTTP UpdateUsernodes. - Update Supported Languages: Modify the
botlangarray in thechatIDfunction node to include all languages your bot will support (e.g.,["ru", "en", "es"]). - Customize Bot Messages: Populate your
botmessagestable in NocoDB with the desired messages for 'greeting', 'welcomeback', 'help', and 'wrongcommand' across all supported languages. - Activate Workflow: Enable the workflow to start processing Telegram messages.
Apps Used
Workflow JSON
{
"id": "0a6d2c04-f96e-4a6a-9a93-7dc7bba31806",
"name": "Multilingual Telegram Bot with Dynamic NocoDB Responses",
"nodes": 19,
"category": "Operations",
"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: 0a6d2c04-f96e...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.