This workflow follows the Telegram → Telegram Trigger recipe pattern — see all workflows that pair these two integrations.
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 →
{
"name": "03 - Manual Entry",
"nodes": [
{
"parameters": {
"updates": [
"message"
],
"additionalFields": {
"download": false
}
},
"id": "telegram-trigger-manual",
"name": "Telegram Command Trigger",
"type": "n8n-nodes-base.telegramTrigger",
"typeVersion": 1,
"position": [
250,
300
],
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{$json.message.text}}",
"operation": "startsWith",
"value2": "/ekle"
},
{
"value1": "={{$json.message.chat.id}}",
"value2": "={{$env.ALLOWED_CHAT_ID}}"
}
]
}
},
"id": "check-command",
"name": "Check /ekle Command",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
450,
300
]
},
{
"parameters": {
"chatId": "={{$json.message.chat.id}}",
"text": "\ud83d\udcdd Manuel Kay\u0131t Giri\u015fi\\n\\nHangi t\u00fcr kay\u0131t eklemek istiyorsunuz?\\n\\n1\ufe0f\u20e3 Harcama\\n2\ufe0f\u20e3 Gelir\\n3\ufe0f\u20e3 Yat\u0131r\u0131m\\n\\nL\u00fctfen numara ile cevap verin (1, 2 veya 3)"
},
"id": "ask-type",
"name": "Ask Type",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1,
"position": [
650,
200
],
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "* * * * *"
}
]
}
},
"id": "wait-response-type",
"name": "Wait for Type Response",
"type": "n8n-nodes-base.wait",
"typeVersion": 1,
"position": [
850,
200
]
},
{
"parameters": {
"chatId": "={{$node[\"Telegram Command Trigger\"].json.message.chat.id}}",
"text": "\ud83d\udcb0 Tutar nedir? (\u00d6rnek: 850 veya 850.50)"
},
"id": "ask-amount",
"name": "Ask Amount",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1,
"position": [
1050,
200
],
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "* * * * *"
}
]
}
},
"id": "wait-response-amount",
"name": "Wait for Amount Response",
"type": "n8n-nodes-base.wait",
"typeVersion": 1,
"position": [
1250,
200
]
},
{
"parameters": {
"chatId": "={{$node[\"Telegram Command Trigger\"].json.message.chat.id}}",
"text": "\ud83d\udcc1 Kategori nedir? (\u00d6rnek: market, restoran, maa\u015f, hisse vb.)"
},
"id": "ask-category",
"name": "Ask Category",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1,
"position": [
1450,
200
],
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "* * * * *"
}
]
}
},
"id": "wait-response-category",
"name": "Wait for Category Response",
"type": "n8n-nodes-base.wait",
"typeVersion": 1,
"position": [
1650,
200
]
},
{
"parameters": {
"chatId": "={{$node[\"Telegram Command Trigger\"].json.message.chat.id}}",
"text": "\ud83d\udcdd A\u00e7\u0131klama? (\u0130ste\u011fe ba\u011fl\u0131, bo\u015f b\u0131rakmak i\u00e7in 'yok' yaz\u0131n)"
},
"id": "ask-description",
"name": "Ask Description",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1,
"position": [
1850,
200
],
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "* * * * *"
}
]
}
},
"id": "wait-response-description",
"name": "Wait for Description Response",
"type": "n8n-nodes-base.wait",
"typeVersion": 1,
"position": [
2050,
200
]
},
{
"parameters": {
"jsCode": "const typeMap = { '1': 'expense', '2': 'income', '3': 'investment' };\nconst type = typeMap[$node[\"Wait for Type Response\"].json.message.text] || 'expense';\nconst amount = parseFloat($node[\"Wait for Amount Response\"].json.message.text);\nconst category = $node[\"Wait for Category Response\"].json.message.text;\nconst description = $node[\"Wait for Description Response\"].json.message.text === 'yok' ? category : $node[\"Wait for Description Response\"].json.message.text;\nconst today = new Date().toISOString().split('T')[0];\n\nconst crypto = require('crypto');\nconst fingerprintString = `${today}_${amount}_${description}`;\nconst fingerprint = crypto.createHash('sha256').update(fingerprintString).digest('hex');\n\nreturn {\n json: {\n type: type,\n date: today,\n amount: amount,\n currency: 'TRY',\n category: category,\n description: description,\n fingerprint: fingerprint,\n confidence_score: 1.0,\n source: 'manual',\n raw_input: `Type: ${type}, Amount: ${amount}, Category: ${category}, Description: ${description}`,\n telegram_message_id: $node[\"Telegram Command Trigger\"].json.message.message_id\n }\n};"
},
"id": "prepare-data",
"name": "Prepare Data",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
2250,
200
]
},
{
"parameters": {
"operation": "executeQuery",
"query": "SELECT id FROM {{$json.type}}s WHERE fingerprint = '{{$json.fingerprint}}' LIMIT 1"
},
"id": "check-duplicate-manual",
"name": "Check Duplicate",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2,
"position": [
2450,
200
],
"credentials": {
"postgres": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{$json.length}}",
"operation": "equal",
"value2": 0
}
]
}
},
"id": "is-not-duplicate-manual",
"name": "Is Not Duplicate",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
2650,
200
]
},
{
"parameters": {
"operation": "executeQuery",
"query": "INSERT INTO {{$node[\"Prepare Data\"].json.type}}s (telegram_message_id, date, amount, currency, category, description, fingerprint, confidence_score, source, raw_input) VALUES ({{$node[\"Prepare Data\"].json.telegram_message_id}}, '{{$node[\"Prepare Data\"].json.date}}', {{$node[\"Prepare Data\"].json.amount}}, '{{$node[\"Prepare Data\"].json.currency}}', '{{$node[\"Prepare Data\"].json.category}}', '{{$node[\"Prepare Data\"].json.description}}', '{{$node[\"Prepare Data\"].json.fingerprint}}', {{$node[\"Prepare Data\"].json.confidence_score}}, '{{$node[\"Prepare Data\"].json.source}}', '{{$node[\"Prepare Data\"].json.raw_input}}') RETURNING id"
},
"id": "insert-db-manual",
"name": "Insert to Database",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2,
"position": [
2850,
200
],
"credentials": {
"postgres": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"chatId": "={{$node[\"Telegram Command Trigger\"].json.message.chat.id}}",
"text": "\u2705 Manuel kay\u0131t eklendi!\\n\\n\ud83d\udcca T\u00fcr: {{$node[\"Prepare Data\"].json.type}}\\n\ud83d\udcb0 Tutar: {{$node[\"Prepare Data\"].json.amount}} {{$node[\"Prepare Data\"].json.currency}}\\n\ud83d\udcc1 Kategori: {{$node[\"Prepare Data\"].json.category}}\\n\ud83d\udcdd A\u00e7\u0131klama: {{$node[\"Prepare Data\"].json.description}}\\n\ud83d\udcc5 Tarih: {{$node[\"Prepare Data\"].json.date}}"
},
"id": "send-success-manual",
"name": "Send Success Message",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1,
"position": [
3050,
200
],
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"chatId": "={{$node[\"Telegram Command Trigger\"].json.message.chat.id}}",
"text": "\u26a0\ufe0f Bu kay\u0131t zaten mevcut! Tekrar eklenmedi."
},
"id": "send-duplicate-manual",
"name": "Send Duplicate Message",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1,
"position": [
2850,
300
],
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Telegram Command Trigger": {
"main": [
[
{
"node": "Check /ekle Command",
"type": "main",
"index": 0
}
]
]
},
"Check /ekle Command": {
"main": [
[
{
"node": "Ask Type",
"type": "main",
"index": 0
}
]
]
},
"Ask Type": {
"main": [
[
{
"node": "Wait for Type Response",
"type": "main",
"index": 0
}
]
]
},
"Wait for Type Response": {
"main": [
[
{
"node": "Ask Amount",
"type": "main",
"index": 0
}
]
]
},
"Ask Amount": {
"main": [
[
{
"node": "Wait for Amount Response",
"type": "main",
"index": 0
}
]
]
},
"Wait for Amount Response": {
"main": [
[
{
"node": "Ask Category",
"type": "main",
"index": 0
}
]
]
},
"Ask Category": {
"main": [
[
{
"node": "Wait for Category Response",
"type": "main",
"index": 0
}
]
]
},
"Wait for Category Response": {
"main": [
[
{
"node": "Ask Description",
"type": "main",
"index": 0
}
]
]
},
"Ask Description": {
"main": [
[
{
"node": "Wait for Description Response",
"type": "main",
"index": 0
}
]
]
},
"Wait for Description Response": {
"main": [
[
{
"node": "Prepare Data",
"type": "main",
"index": 0
}
]
]
},
"Prepare Data": {
"main": [
[
{
"node": "Check Duplicate",
"type": "main",
"index": 0
}
]
]
},
"Check Duplicate": {
"main": [
[
{
"node": "Is Not Duplicate",
"type": "main",
"index": 0
}
]
]
},
"Is Not Duplicate": {
"main": [
[
{
"node": "Insert to Database",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Duplicate Message",
"type": "main",
"index": 0
}
]
]
},
"Insert to Database": {
"main": [
[
{
"node": "Send Success Message",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
},
"staticData": null,
"tags": [],
"triggerCount": 1,
"updatedAt": "2026-02-07T23:34:27.213Z",
"versionId": "1"
}
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.
postgrestelegramApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
03 - Manual Entry. Uses telegramTrigger, telegram, postgres. Event-driven trigger; 16 nodes.
Source: https://github.com/nebikiramanli/personal-finance-bot/blob/ed72282f85eb918b1c7e959e01cea3e30c696d96/n8n/workflows/03_manual_entry.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Pede Ai. Uses httpRequest, telegram, postgres, telegramTrigger. Event-driven trigger; 53 nodes.
HTTP Request, Telegram, Postgres +1
News Digest Bot - Multi-User (Postgres). Uses telegramTrigger, postgres, telegram, rssFeedRead. Event-driven trigger; 45 nodes.
Telegram Trigger, Postgres, Telegram +3
TextMain. Uses telegramTrigger, stopAndError, telegram, httpRequest. Event-driven trigger; 56 nodes.
Telegram Trigger, Stop And Error, Telegram +2
📄 Documentation: Notion Guide
Telegram Trigger, @Blotato/N8N Nodes Blotato, Telegram +1
Telegram Wait. Uses stickyNote, httpRequest, redis, noOp. Event-driven trigger; 36 nodes.
HTTP Request, Redis, Telegram +1