This workflow follows the Chainllm → Chat 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": "Telegram Message Recap",
"nodes": [
{
"parameters": {
"updates": [
"message"
],
"additionalFields": {}
},
"type": "n8n-nodes-base.telegramTrigger",
"typeVersion": 1.1,
"position": [
40,
260
],
"id": "f9af3b7f-619a-4c21-9e68-85956200584d",
"name": "Telegram Trigger",
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"tableId": "telegram_chat_logs",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "from",
"fieldValue": "={{ $json.message.from.first_name }} ({{ $json.message.from.username }})"
},
{
"fieldId": "message",
"fieldValue": "={{ $json.message.text }}"
},
{
"fieldId": "group",
"fieldValue": "={{ $json.message.chat.title }}"
}
]
}
},
"type": "n8n-nodes-base.supabase",
"typeVersion": 1,
"position": [
600,
240
],
"id": "b18d015d-61a3-4f23-82d3-9335b5985b65",
"name": "Supabase",
"credentials": {
"supabaseApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 0 19 * * *"
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
-40,
-240
],
"id": "024f503e-0a3b-4437-a05f-ff3fa4778f03",
"name": "Schedule Trigger"
},
{
"parameters": {
"operation": "getAll",
"tableId": "telegram_chat_logs",
"returnAll": true,
"filters": {
"conditions": [
{
"keyName": "created_at",
"condition": "gte",
"keyValue": "={{new Date(Date.now() - 12 * 60 * 60 * 1000).toISOString()}}"
},
{
"keyName": "group",
"condition": "is",
"keyValue": "null"
}
]
}
},
"type": "n8n-nodes-base.supabase",
"typeVersion": 1,
"position": [
620,
-240
],
"id": "768c6e33-7bf9-4f41-a781-def3b0e94e4f",
"name": "Supabase1",
"credentials": {
"supabaseApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"aggregate": "aggregateAllItemData",
"include": "allFieldsExcept",
"fieldsToExclude": "id",
"options": {}
},
"type": "n8n-nodes-base.aggregate",
"typeVersion": 1,
"position": [
860,
-240
],
"id": "8edcafec-a8ad-49b3-a1ae-90da7db215fc",
"name": "Aggregate"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "c274b826-342a-4120-a139-123b1ca0994c",
"leftValue": "={{ $json.data }}",
"rightValue": 10,
"operator": {
"type": "array",
"operation": "lengthGt",
"rightType": "number"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1060,
-240
],
"id": "9e2c47fb-698f-4faf-b1c5-69ec59318d1d",
"name": "If enough message"
},
{
"parameters": {
"modelName": "models/gemini-1.5-pro-latest",
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"typeVersion": 1,
"position": [
1380,
-140
],
"id": "3709dfdb-7cf6-4633-8142-a6a92097ee42",
"name": "Google Gemini Chat Model",
"credentials": {
"googlePalmApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a3f8c234-da29-4d43-9965-9ed612c514cf",
"leftValue": "={{ $json.text }}",
"rightValue": "No meaningful ",
"operator": {
"type": "string",
"operation": "contains"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1640,
-360
],
"id": "e92b3056-5eca-480e-b63d-a7af8ba1ab59",
"name": "If No meaningful"
},
{
"parameters": {
"chatId": "581129983",
"text": "={{ $json.message }}",
"additionalFields": {
"appendAttribution": false,
"parse_mode": "HTML"
}
},
"type": "n8n-nodes-base.telegram",
"typeVersion": 1.2,
"position": [
2420,
-340
],
"id": "117dbbf1-b395-4487-8415-c248da91e453",
"name": "Telegram",
"alwaysOutputData": false,
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"content": "## Recap",
"height": 560,
"width": 2800
},
"type": "n8n-nodes-base.stickyNote",
"position": [
-140,
-460
],
"typeVersion": 1,
"id": "e3ad0b52-bf6b-4734-a176-a850443025af",
"name": "Sticky Note"
},
{
"parameters": {
"content": "Receive",
"height": 300,
"width": 1140,
"color": 4
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-120,
160
],
"id": "d24bd925-bacb-44a7-8aed-40fa7ca64ecf",
"name": "Sticky Note1"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "b8c8fefa-2edf-45d6-bda5-f8d70a50e73e",
"leftValue": "={{ $json.message.text }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
260,
260
],
"id": "711a7ecb-206f-4d83-8baf-61e3603228f8",
"name": "Has message"
},
{
"parameters": {},
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-40,
-420
],
"id": "3c5b239c-5d6a-4dc8-8c62-bc4999cd3e00",
"name": "When clicking \u2018Test workflow\u2019"
},
{
"parameters": {
"public": true,
"initialMessages": "Just send me any text, I will just ignore the message but send you some recap.",
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"typeVersion": 1.1,
"position": [
-40,
-60
],
"id": "f68d4241-ebf3-420d-8c88-c5d8a1d5d0fd",
"name": "When chat message received"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "2c54fc0b-daa3-4bac-913d-94254afe2918",
"leftValue": "={{ $json.chatInput }}",
"rightValue": "hey",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
260,
-60
],
"id": "a62cd976-716c-4e9c-a901-be53c37995b7",
"name": "If"
},
{
"parameters": {
"url": "https://dummyjson.com/quotes/random",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
520,
-40
],
"id": "be692f58-ccdf-419e-8b81-ad056d9d8103",
"name": "HTTP Request"
},
{
"parameters": {
"jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nfor (const item of $input.all()) {\n item.json.text = item.json.quote + \" - \"+item.json.author ;\n}\n\nreturn $input.all();"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
740,
-40
],
"id": "ffe5aaa8-769f-41ca-be84-18badac70729",
"name": "Code"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "b6e3c56a-31af-41a4-b438-ea3dc846bb8e",
"name": "text",
"value": "={{ $json.text }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
960,
-40
],
"id": "5655b70f-e9bc-4c2f-bf02-809cf56d346e",
"name": "Edit Fields1"
},
{
"parameters": {
"jsCode": "function splitTextForTelegram(text, maxLength = 4096) {\n const result = [];\n \n // If text is short enough, return as is\n if (text.length <= maxLength) {\n return [{ message: text, index: 0 }];\n }\n \n let startIndex = 0;\n let index = 0;\n let inTag = false;\n let buffer = '';\n \n for (let i = 0; i < text.length; i++) {\n // Track if we're inside an HTML tag\n if (text[i] === '<' && !inTag) {\n inTag = true;\n } else if (text[i] === '>' && inTag) {\n inTag = false;\n }\n \n buffer += text[i];\n \n // Check if we've reached maxLength or end of text\n if (buffer.length >= maxLength || i === text.length - 1) {\n // If we're in a tag, keep going until we close it\n if (inTag && i < text.length - 1) {\n continue;\n }\n \n // Find a safe breaking point if we're not at the end\n if (i < text.length - 1) {\n let safeCut = buffer.length;\n const lastSpace = buffer.lastIndexOf(' ');\n const lastNewline = buffer.lastIndexOf('\\n');\n const lastTagClose = buffer.lastIndexOf('>');\n \n // Prefer breaking at space or newline, but not inside tags\n if (lastSpace > lastTagClose) {\n safeCut = lastSpace + 1;\n } else if (lastNewline > lastTagClose) {\n safeCut = lastNewline + 1;\n } else if (lastTagClose > 0) {\n safeCut = lastTagClose + 1;\n }\n \n // Adjust the buffer and text position\n const chunk = buffer.substring(0, safeCut).trim();\n result.push({\n message: chunk,\n index: index++\n });\n \n // Move startIndex to after this chunk\n startIndex += safeCut;\n i = startIndex - 1; // -1 because the loop will increment\n buffer = '';\n } else {\n // If we're at the end, push whatever's left\n result.push({\n message: buffer.trim(),\n index: index++\n });\n buffer = '';\n }\n }\n }\n \n return result;\n}\n\n// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nfor (const item of $input.all()) {\n item.json.chunks = splitTextForTelegram(item.json.text);\n}\n\nreturn $input.all();"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1900,
-340
],
"id": "57c96b72-079e-4c81-8a69-0bd819d89578",
"name": "Code1"
},
{
"parameters": {
"fieldToSplitOut": "chunks",
"options": {}
},
"type": "n8n-nodes-base.splitOut",
"typeVersion": 1,
"position": [
2120,
-340
],
"id": "280b6760-0d6c-4c0e-8c24-31054e107997",
"name": "Split Out"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "fa276313-3461-43f1-b175-26dbb196423f",
"name": "text",
"value": "={{ $json.result.text }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
2480,
-140
],
"id": "89ebb95d-4e6f-4c23-a802-59f62237a401",
"name": "Output"
},
{
"parameters": {
"promptType": "define",
"text": "=T\u00f3m t\u1eaft chat log n\u00e0y trong ti\u1ebfng Vi\u1ec7t, chia theo nh\u00f3m. C\u00f3 ph\u1ea7n t\u1ed5ng quan b\u00ean tr\u00ean v\u00e0 kho\u1ea3ng th\u1eddi gian (GMT+7).\n\n\u0110\u1ea3m b\u1ea3o c\u1ea5u tr\u00fac sau:\n\nA. Cho t\u1eebng nh\u00f3m\n\n- T\u00f3m t\u1eaft cho nh\u00f3m\n- \u0110\u01b0a ra nh\u1eadn \u0111\u1ecbnh, \u0111\u00e1nh gi\u00e1 r\u1ee7i ro.\n- C\u00e1c quy\u1ebft \u0111\u1ecbnh, deadline, task n\u00e0o \u0111\u01b0\u1ee3c \u0111\u01b0a ra (vi\u1ebft r\u00f5 th\u00e0nh 1 m\u1ee5c cho t\u1eebng d\u1ef1 \u00e1n)?\n- C\u00e1c URL\n\nB. Nh\u00ecn chung\n\n3. Cho bi\u1ebft nh\u00f3m \u0111ang vui nh\u1ea5t (theo v\u0103n phong)\n4. Nh\u00f3m c\u00f3 nhi\u1ec1u v\u1ea5n \u0111\u1ec1 nh\u1ea5t (r\u1ee7i ro, tranh c\u00e3i, kh\u00f4ng th\u1ec3 quy\u1ebft \u0111\u1ecbnh)\n5. Nh\u00f3m c\u00f3 nh\u1ecbp \u0111\u1ed9 th\u1ea3o lu\u1eadn d\u00e0y \u0111\u1eb7c nh\u1ea5t\n\nC. \u0110\u1ecbnh d\u1ea1ng:\n\n- Tr\u1ea3 v\u1ec1 d\u1ea1ng html (ch\u1ec9 \u0111\u01b0\u1ee3c d\u00f9ng th\u1ebb b, i; kh\u00f4ng \u0111\u01b0\u1ee3c d\u00f9ng b\u1ea5t k\u1ef3 th\u1ebb n\u00e0o kh\u00e1c), kh\u00f4ng d\u00f9ng markdown; m\u1ee5c \u0111\u00edch \u0111\u1ec3 g\u1eedi qua telegram api v\u1edbi html parse mode.\n- Tr\u00ecnh b\u00e0y d\u1ec5 \u0111\u1ecdc s\u1eed d\u1ee5ng g\u1ea1ch \u0111\u1ea7u d\u00f2ng; d\u00f9ng d\u1ea5u - (cho bullet c\u1ea5p 1), d\u00f9ng d\u1ea5u + (cho bullet c\u1ea5p 2) thay cho *, ch\u1ec9 d\u00f9ng icon \u1edf c\u00e1c m\u1ee5c l\u1edbn.\n- S\u1eed d\u1ee5ng icon c\u00f3 m\u00e0u xanh l\u00e1 \u1edf \u0111\u1ea7u c\u00e1c t\u00ean group, v\u1edbi group c\u00f3 nhi\u1ec1u v\u1ea5n \u0111\u1ec1, ch\u1ecdn icon m\u00e0u v\u00e0ng, v\u1edbi c\u00e1c group c\u00f3 v\u1ebb tranh lu\u1eadn nhi\u1ec1u ho\u1eb7c c\u00f3 r\u1ee7i ro cao, ch\u1ecdn icon m\u00e0u \u0111\u1ecf.\n\nChat log:\n \n{{ JSON.stringify($json.data) }}",
"messages": {
"messageValues": [
{
"message": "=You are a Telegram group assistant. Here are messages from the group over the last 12 hours. Only summarize if meaningful discussion took place \u2014 like questions, planning, or decisions.\n\nIf the content is mostly greetings, jokes, or unrelated small talk, respond with:\n\"No meaningful content to summarize.\""
}
]
}
},
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"typeVersion": 1.5,
"position": [
1280,
-360
],
"id": "b5933962-e6aa-4441-8920-363daa8eb341",
"name": "AI recap"
},
{
"parameters": {
"content": "Tham gia Discord h\u1ed7 tr\u1ee3 c\u1ee7a ch\u00fang t\u00f4i t\u1ea1i: https://discord.gg/CbEbkYQb",
"height": 80,
"color": 4
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
760,
-600
],
"id": "dd48557f-d1c1-4615-a00b-7403d4100034",
"name": "Sticky Note2"
}
],
"connections": {
"Telegram Trigger": {
"main": [
[
{
"node": "Has message",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Supabase1",
"type": "main",
"index": 0
}
]
]
},
"Supabase1": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "If enough message",
"type": "main",
"index": 0
}
]
]
},
"If enough message": {
"main": [
[
{
"node": "AI recap",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "AI recap",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"If No meaningful": {
"main": [
[],
[
{
"node": "Code1",
"type": "main",
"index": 0
}
]
]
},
"Has message": {
"main": [
[
{
"node": "Supabase",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Supabase1",
"type": "main",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Telegram": {
"main": [
[
{
"node": "Output",
"type": "main",
"index": 0
}
]
]
},
"If": {
"main": [
[
{
"node": "Supabase1",
"type": "main",
"index": 0
}
],
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Code1": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Telegram",
"type": "main",
"index": 0
}
]
]
},
"AI recap": {
"main": [
[
{
"node": "If No meaningful",
"type": "main",
"index": 0
}
]
]
}
},
"active": true,
"settings": {
"executionOrder": "v1"
},
"versionId": "431e7b90-f4de-47da-8d66-11736fb1b842",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "bsqagw2PGd3cEKQY",
"tags": []
}
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.
googlePalmApisupabaseApitelegramApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Telegram Message Recap. Uses telegramTrigger, supabase, lmChatGoogleGemini, telegram. Event-driven trigger; 23 nodes.
Source: https://github.com/bnqtoan/workflows/blob/582abd68c061c79be577a742648d909f7fb9e08b/telegram-message-recap/Telegram_Message_Recap.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.
This workflow creates a multi-talented AI assistant named Simran that interacts with users via Telegram. It can handle text and voice messages, understand the user's intent, and perform various tasks.
MongoDB, Chain Llm, Google Gemini Chat +11
A Telegram bot that converts natural-language work descriptions into detailed cost estimates using AI parsing, vector search, and the open-source DDC CWICR database with 55,000+ construction work item
HTTP Request, Telegram, Telegram Trigger +6
leads. Uses supabase, gmail, formTrigger, httpRequest. Webhook trigger; 62 nodes.
Supabase, Gmail, Form Trigger +13
This workflow turns any URL sent to a Telegram bot into ready-to-publish social posts: Trigger: Telegram message (checks if it contains a URL). Fetch & parse: Downloads the page and extracts readable
Telegram Trigger, HTTP Request, Google Sheets +5
Auto-Generate Social Media Posts From Urls With Ai Telegram Multi-Platform Posting. Uses telegramTrigger, httpRequest, googleSheets, openAi. Event-driven trigger; 42 nodes.
Telegram Trigger, HTTP Request, Google Sheets +5