{ "nodes": [ { "name": "chatID", "type": "n8n-nodes-base.function", "notes": "username and language", "position": [ -100, 680 ], "parameters": { "functionCode": "// Telegram uses the following language codes: https://en.wikipedia.org/wiki/IETF_language_tag\r\n\r\nvar data = $node[\"Telegram Trigger\"].json;\r\nconst botlang = [\"ru\", \"en\"]; // Update this after adding new language in the dictionary\r\n\r\n// Assign the default language if the translation is not yet ready\r\nvar curlang = botlang.includes(data.message.from.language_code) ? data.message.from.language_code : \"en\";\r\n\r\nreturn [{json: {chatID : data.message.chat.id,\r\n lang : curlang\r\n}}];" }, "notesInFlow": true, "typeVersion": 1, "id": "node-26ded2bb" }, { "name": "Merge", "type": "n8n-nodes-base.merge", "notes": "Wait for dictionary to load", "position": [ 480, 460 ], "parameters": { "mode": "passThrough" }, "notesInFlow": true, "typeVersion": 1, "id": "node-6bb0ce9d" }, { "name": "Switch", "type": "n8n-nodes-base.switch", "notes": "check bot commands", "position": [ 620, 460 ], "parameters": { "rules": { "rules": [ { "value2": "/start" }, { "output": 1, "value2": "/help" } ] }, "value1": "={{$node[\"Merge\"].json[\"message\"][\"text\"]}}", "dataType": "string", "fallbackOutput": 3 }, "notesInFlow": true, "typeVersion": 1, "id": "node-5a88ea77" }, { "name": "IF", "type": "n8n-nodes-base.if", "position": [ 940, 300 ], "parameters": { "conditions": { "boolean": [ { "value1": "={{$json[\"empty\"]}}", "value2": "={{true}}" } ] } }, "typeVersion": 1, "alwaysOutputData": false, "id": "node-9b124939" }, { "name": "msg_greet", "type": "n8n-nodes-base.telegram", "position": [ 1260, 220 ], "parameters": { "text": "={{$evaluateExpression($node[\"botmessages\"].json[\"greeting\"][$node[\"chatID\"].json[\"lang\"]])}}", "chatId": "={{$node[\"Telegram Trigger\"].json[\"message\"][\"chat\"][\"id\"]}}", "additionalFields": {} }, "notesInFlow": true, "typeVersion": 1, "id": "node-61fbad3f" }, { "name": "msg_welcomeback", "type": "n8n-nodes-base.telegram", "position": [ 1260, 380 ], "parameters": { "text": "={{$evaluateExpression($node[\"botmessages\"].json[\"welcomeback\"][$node[\"chatID\"].json[\"lang\"]])}}", "chatId": "={{$node[\"Telegram Trigger\"].json[\"message\"][\"chat\"][\"id\"]}}", "additionalFields": {} }, "notesInFlow": true, "typeVersion": 1, "id": "node-f28a9967" }, { "name": "msg_help", "type": "n8n-nodes-base.telegram", "position": [ 1260, 540 ], "parameters": { "text": "={{$evaluateExpression($node[\"botmessages\"].json[\"help\"][$node[\"chatID\"].json[\"lang\"]])}}", "chatId": "={{$node[\"Telegram Trigger\"].json[\"message\"][\"chat\"][\"id\"]}}", "additionalFields": { "parse_mode": "Markdown" } }, "notesInFlow": true, "typeVersion": 1, "id": "node-60eef08b" }, { "name": "msg_wrongcommand", "type": "n8n-nodes-base.telegram", "position": [ 1260, 700 ], "parameters": { "text": "={{$evaluateExpression($node[\"botmessages\"].json[\"wrongcommand\"][$node[\"chatID\"].json[\"lang\"]])}}", "chatId": "={{$node[\"Telegram Trigger\"].json[\"message\"][\"chat\"][\"id\"]}}", "additionalFields": {} }, "notesInFlow": true, "typeVersion": 1, "id": "node-448e8b0e" }, { "name": "New user?", "type": "n8n-nodes-base.function", "position": [ 780, 300 ], "parameters": { "functionCode": "return [{json: {empty: Object.keys($node[\"CheckUser\"].json).length == 0}}];" }, "typeVersion": 1, "id": "node-db0c7cef" }, { "name": "CheckUser", "type": "n8n-nodes-base.nocoDb", "position": [ 380, 680 ], "parameters": { "table": "TG_users", "options": { "where": "=(TG_account_ID,eq,{{$node[\"chatID\"].json[\"chatID\"]}})" }, "operation": "getAll", "projectId": "n8n_multilang_bot_wzhb" }, "notesInFlow": true, "typeVersion": 1, "alwaysOutputData": true, "id": "node-a526a737" }, { "name": "LoadDictionary", "type": "n8n-nodes-base.nocoDb", "position": [ 60, 680 ], "parameters": { "table": "botmessages", "options": {}, "operation": "getAll", "projectId": "n8n_multilang_bot_wzhb", "returnAll": true }, "notesInFlow": true, "typeVersion": 1, "alwaysOutputData": true, "id": "node-63672991" }, { "name": "botmessages", "type": "n8n-nodes-base.function", "position": [ 220, 680 ], "parameters": { "functionCode": "\nlet data = {};\n\nfor (item of items) {\n data[item.json.botmessage]=item.json;\n}\n\nreturn data;" }, "typeVersion": 1, "id": "node-fc183e4f" }, { "name": "Telegram Trigger", "type": "n8n-nodes-base.telegramTrigger", "position": [ 240, 460 ], "webhookId": "21dac5fa-6e6b-43a0-b099-4f57537d2271", "parameters": { "updates": [ "message" ], "additionalFields": {} }, "typeVersion": 1, "id": "node-5ae9a888" }, { "name": "HTTP AddUser", "type": "n8n-nodes-base.httpRequest", "position": [ 1100, 220 ], "parameters": { "url": "{{ $env.BASE_URL }}", "options": { "bodyContentType": "json" }, "requestMethod": "POST", "authentication": "{{ $credentials.headerAuth }}", "bodyParametersUi": { "parameter": [ { "name": "TG_account_ID", "value": "={{$node[\"chatID\"].json[\"chatID\"]}}" }, { "name": "Last_language_used", "value": "={{$node[\"Telegram Trigger\"].json[\"message\"][\"from\"][\"language_code\"]}}" } ] } }, "typeVersion": 1, "id": "node-8c6ab98b" }, { "name": "HTTP UpdateUser", "type": "n8n-nodes-base.httpRequest", "position": [ 1100, 380 ], "parameters": { "url": "{{ $env.BASE_URL }}", "options": { "bodyContentType": "json" }, "requestMethod": "PATCH", "authentication": "{{ $credentials.headerAuth }}", "bodyParametersUi": { "parameter": [ { "name": "TG_account_ID", "value": "={{$node[\"chatID\"].json[\"chatID\"]}}" }, { "name": "Last_language_used", "value": "={{$node[\"Telegram Trigger\"].json[\"message\"][\"from\"][\"language_code\"]}}" } ] } }, "typeVersion": 1, "id": "node-c36fd717" }, { "name": "AddUser", "type": "n8n-nodes-base.nocoDb", "disabled": true, "position": [ 1460, 220 ], "parameters": { "table": "TG_users", "fieldsUi": { "fieldValues": [ { "fieldName": "TG_account_ID", "fieldValue": "={{$node[\"chatID\"].json[\"chatID\"]}}" }, { "fieldName": "Last_language_used", "fieldValue": "={{$node[\"Telegram Trigger\"].json[\"message\"][\"from\"][\"language_code\"]}}" } ] }, "operation": "create", "projectId": "n8n_multilang_bot_wzhb" }, "notesInFlow": true, "typeVersion": 1, "id": "node-3e0c90ee" }, { "name": "UpdateUser", "type": "n8n-nodes-base.nocoDb", "disabled": true, "position": [ 1460, 380 ], "parameters": { "id": "={{$node[\"CheckUser\"].json[\"id\"]}}", "table": "TG_users", "fieldsUi": { "fieldValues": [ { "fieldName": "TG_account_ID", "fieldValue": "={{$node[\"chatID\"].json[\"chatID\"]}}" }, { "fieldName": "Last_language_used", "fieldValue": "={{$node[\"Telegram Trigger\"].json[\"message\"][\"from\"][\"language_code\"]}}" } ] }, "operation": "update", "projectId": "n8n_multilang_bot_wzhb" }, "notesInFlow": true, "typeVersion": 1, "id": "node-48582685" }, { "name": "Note", "type": "n8n-nodes-base.stickyNote", "position": [ 1440, 80 ], "parameters": { "width": 440, "height": 460, "content": "## What's this?\nDue to some breaking API changes in NocoDB some of its node options are not working at the moment (MAY 2022). These two nodes were replaced by HTTP request nodes. Functionality is still the same." }, "typeVersion": 1, "id": "node-e95618b3" }, { "id": "error-6048ad5c", "name": "Error Handler", "type": "n8n-nodes-base.stopAndError", "typeVersion": 1, "position": [ 1000, 400 ], "parameters": { "message": "Workflow execution error", "options": {} } } ], "connections": {}, "name": "Production Workflow", "settings": { "executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3 }, "meta": { "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:51.057602", "updatedAt": "2025-09-29T07:07:51.057621", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production" }, "tags": [ "automation", "n8n", "production-ready", "excellent", "optimized" ], "description": "Production-ready workflow: Production Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation." }