The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"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
},
{
"name": "Merge",
"type": "n8n-nodes-base.merge",
"notes": "Wait for dictionary to load",
"position": [
480,
460
],
"parameters": {
"mode": "passThrough"
},
"notesInFlow": true,
"typeVersion": 1
},
{
"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
},
{
"name": "IF",
"type": "n8n-nodes-base.if",
"position": [
940,
300
],
"parameters": {
"conditions": {
"boolean": [
{
"value1": "={{$json[\"empty\"]}}",
"value2": "={{true}}"
}
]
}
},
"typeVersion": 1,
"alwaysOutputData": false
},
{
"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": {}
},
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"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": {}
},
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"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"
}
},
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"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": {}
},
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"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
},
{
"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"
},
"credentials": {
"nocoDb": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1,
"alwaysOutputData": true
},
{
"name": "LoadDictionary",
"type": "n8n-nodes-base.nocoDb",
"position": [
60,
680
],
"parameters": {
"table": "botmessages",
"options": {},
"operation": "getAll",
"projectId": "n8n_multilang_bot_wzhb",
"returnAll": true
},
"credentials": {
"nocoDb": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1,
"alwaysOutputData": true
},
{
"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
},
{
"name": "Telegram Trigger",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
240,
460
],
"parameters": {
"updates": [
"message"
],
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"name": "HTTP AddUser",
"type": "n8n-nodes-base.httpRequest",
"position": [
1100,
220
],
"parameters": {
"url": "https://database.digigin.eu/api/v1/db/data/noco/n8n_multilang_bot_wzhb/TG_users",
"options": {
"bodyContentType": "json"
},
"requestMethod": "POST",
"authentication": "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\"]}}"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"name": "HTTP UpdateUser",
"type": "n8n-nodes-base.httpRequest",
"position": [
1100,
380
],
"parameters": {
"url": "=https://database.digigin.eu/api/v1/db/data/noco/n8n_multilang_bot_wzhb/TG_users/{{$node[\"CheckUser\"].json[\"id\"]}}",
"options": {
"bodyContentType": "json"
},
"requestMethod": "PATCH",
"authentication": "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\"]}}"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"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"
},
"credentials": {
"nocoDb": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"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"
},
"credentials": {
"nocoDb": {
"name": "<your credential>"
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"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
}
],
"connections": {
"IF": {
"main": [
[
{
"node": "HTTP AddUser",
"type": "main",
"index": 0
}
],
[
{
"node": "HTTP UpdateUser",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "New user?",
"type": "main",
"index": 0
}
],
[
{
"node": "msg_help",
"type": "main",
"index": 0
}
],
null,
[
{
"node": "msg_wrongcommand",
"type": "main",
"index": 0
}
]
]
},
"chatID": {
"main": [
[
{
"node": "LoadDictionary",
"type": "main",
"index": 0
}
]
]
},
"CheckUser": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"New user?": {
"main": [
[
{
"node": "IF",
"type": "main",
"index": 0
}
]
]
},
"botmessages": {
"main": [
[
{
"node": "CheckUser",
"type": "main",
"index": 0
}
]
]
},
"HTTP AddUser": {
"main": [
[
{
"node": "msg_greet",
"type": "main",
"index": 0
}
]
]
},
"LoadDictionary": {
"main": [
[
{
"node": "botmessages",
"type": "main",
"index": 0
}
]
]
},
"HTTP UpdateUser": {
"main": [
[
{
"node": "msg_welcomeback",
"type": "main",
"index": 0
}
]
]
},
"Telegram Trigger": {
"main": [
[
{
"node": "chatID",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
httpHeaderAuthnocoDbtelegramApi
About this workflow
Nocodb Telegram. Uses telegram, nocoDb, telegramTrigger, httpRequest. Event-driven trigger; 18 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →