This workflow follows the HTTP Request → Supabase 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 →
{
"nodes": [
{
"id": "9cc26a42-eb43-40c4-b507-cbaf187a5e15",
"name": "Get New Message",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
1120,
500
],
"parameters": {
"updates": [
"message"
],
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.1
},
{
"id": "098b6fcf-7cb6-4730-8892-949fedc946b3",
"name": "OPENAI - Create thread",
"type": "n8n-nodes-base.httpRequest",
"position": [
1740,
640
],
"parameters": {
"url": "https://api.openai.com/v1/threads",
"method": "POST",
"options": {},
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"headerParameters": {
"parameters": [
{
"name": "OpenAI-Beta",
"value": "assistants=v2"
}
]
},
"nodeCredentialType": "openAiApi"
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "fa157f8c-b776-4b20-bfaf-c17460383505",
"name": "Create User",
"type": "n8n-nodes-base.supabase",
"position": [
1900,
640
],
"parameters": {
"tableId": "telegram_users",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "telegram_id",
"fieldValue": "={{ $('Get New Message').item.json.message.chat.id }}"
},
{
"fieldId": "openai_thread_id",
"fieldValue": "={{ $('OPENAI - Create thread').item.json.id }}"
}
]
}
},
"credentials": {
"supabaseApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "115e417f-5962-409b-8adf-ff236eb9ce2e",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
2080,
500
],
"parameters": {},
"typeVersion": 3
},
{
"id": "ba5c7385-8c80-43c8-9de2-430175bda70b",
"name": "OPENAI - Send message",
"type": "n8n-nodes-base.httpRequest",
"position": [
2240,
500
],
"parameters": {
"url": "=https://api.openai.com/v1/threads/{{ $('Merge').item.json.openai_thread_id }}/messages ",
"method": "POST",
"options": {},
"sendBody": true,
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "role",
"value": "user"
},
{
"name": "content",
"value": "={{ $('Get New Message').item.json.message.text }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "OpenAI-Beta",
"value": "assistants=v2"
}
]
},
"nodeCredentialType": "openAiApi"
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "024832bc-3d42-4879-a57f-b23e962b4c69",
"name": "OPENAI - Run assistant",
"type": "n8n-nodes-base.httpRequest",
"position": [
2440,
500
],
"parameters": {
"url": "=https://api.openai.com/v1/threads/{{ $('Merge').item.json.openai_thread_id }}/runs",
"method": "POST",
"options": {},
"sendBody": true,
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "assistant_id",
"value": "asst_b0QhuzySG6jofHFdzPZD7WEz"
},
{
"name": "stream",
"value": "={{true}}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "OpenAI-Beta",
"value": "assistants=v2"
}
]
},
"nodeCredentialType": "openAiApi"
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "bc191e2b-15f4-45b7-af2e-19ed1639b7f5",
"name": "OPENAI - Get messages",
"type": "n8n-nodes-base.httpRequest",
"position": [
2640,
500
],
"parameters": {
"url": "=https://api.openai.com/v1/threads/{{ $('Merge').item.json.openai_thread_id }}/messages",
"options": {},
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"headerParameters": {
"parameters": [
{
"name": "OpenAI-Beta",
"value": "assistants=v2"
}
]
},
"nodeCredentialType": "openAiApi"
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "c22e05e5-f0a7-4a09-a864-acfc58469b30",
"name": "Send Message to User",
"type": "n8n-nodes-base.telegram",
"position": [
2840,
500
],
"parameters": {
"text": "={{ $('OPENAI - Get messages').item.json.data[0].content[0].text.value }}",
"chatId": "={{ $('Get New Message').item.json.message.chat.id }}",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.2
},
{
"id": "0673be1f-3cae-42a0-9c62-1ed570859043",
"name": "If User exists",
"type": "n8n-nodes-base.if",
"position": [
1560,
500
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b6e69a1f-eb42-4ef6-b80c-3167f1b8c830",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.id }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.1
},
{
"id": "a4916f54-ae6b-495d-979b-92dca965e3bb",
"name": "Find User",
"type": "n8n-nodes-base.supabase",
"position": [
1360,
500
],
"parameters": {
"filters": {
"conditions": [
{
"keyName": "telegram_id",
"keyValue": "={{ $json.message.chat.id }}",
"condition": "eq"
}
]
},
"tableId": "telegram_users",
"operation": "getAll"
},
"credentials": {
"supabaseApi": {
"name": "<your credential>"
}
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "6d01d7ed-e96b-47cf-9a5f-46608031baa2",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
800
],
"parameters": {
"color": 7,
"width": 600.723278204605,
"height": 213.15921994594194,
"content": "SQL query to create table in Supabase:\n\n```\ncreate table\n public.telegram_users (\n id uuid not null default gen_random_uuid (),\n date_created timestamp with time zone not null default (now() at time zone 'utc'::text),\n telegram_id bigint null,\n openai_thread_id text null,\n constraint telegram_users_pkey primary key (id)\n ) tablespace pg_default;\n```"
},
"typeVersion": 1
},
{
"id": "1a996da0-6022-48d7-ba40-1d137547a3d7",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2340,
360
],
"parameters": {
"color": 3,
"width": 282.075050779723,
"height": 80,
"content": "Create assistant in [OpenAI](https://platform.openai.com/assistants).\n\n**Specify own assistant id here**\n"
},
"typeVersion": 1
},
{
"id": "b24d2008-7950-41f0-a7fa-50360c0c6854",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1040,
380
],
"parameters": {
"color": 3,
"width": 235.09282368774151,
"height": 80,
"content": "Create own Telegram bot in [Botfather bot](https://t.me/botfather)"
},
"typeVersion": 1
},
{
"id": "9eb2491e-5ad9-4015-8ed9-611e72924503",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
680
],
"parameters": {
"color": 3,
"height": 80,
"content": "Create table in [Supabase](https://supabase.com) with SQL query"
},
"typeVersion": 1
},
{
"id": "884b5a1b-007c-4752-becc-46c8fc58db92",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
120
],
"parameters": {
"color": 7,
"width": 280.2462120317618,
"height": 438.5821431288714,
"content": "### Set up steps\n1. **Create a Telegram Bot** using the [Botfather](https://t.me/botfather) and obtain the bot token.\n2. **Set up Supabase:**\n\t1. Create a new project and generate a ```SUPABASE_URL``` and ```SUPABASE_KEY```.\n\t2. Create a new table named ```telegram_users``` with the following SQL query:\n```\ncreate table\n public.telegram_users (\n id uuid not null default gen_random_uuid (),\n date_created timestamp with time zone not null default (now() at time zone 'utc'::text),\n telegram_id bigint null,\n openai_thread_id text null,\n constraint telegram_users_pkey primary key (id)\n ) tablespace pg_default;\n```\n3. **OpenAI Setup:**\n\t1. Create an OpenAI assistant and obtain the ```OPENAI_API_KEY```.\n\t2. Customize your assistant\u2019s personality or use cases according to your requirements.\n4. **Environment Configuration in n8n:**\n\t1. Configure the Telegram, Supabase, and OpenAI nodes with the appropriate credentials.\n\t2. Set up triggers for receiving messages and handling conversation logic.\n\t3. Set up OpenAI assistant ID in \"++OPENAI - Run assistant++\" node."
},
"typeVersion": 1
},
{
"id": "02db77ac-4909-4a56-a558-03c86d8b8552",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
-400
],
"parameters": {
"color": 7,
"width": 636.2128494576581,
"height": 494.9629292914819,
"content": ".png)\n## AI Telegram Bot with Supabase memory\n**Made by [Mark Shcherbakov](https://www.linkedin.com/in/marklowcoding/) from community [5minAI](https://www.skool.com/5minai-2861)**\n\nMany simple chatbots lack context awareness and user memory. This workflow solves that by integrating Supabase to keep track of user sessions (via ```telegram_id``` and ```openai_thread_id```), allowing the bot to maintain continuity and context in conversations, leading to a more human-like and engaging experience.\n\nThis Telegram bot template connects with OpenAI to answer user queries while storing and retrieving user information from a Supabase database. The memory component ensures that the bot can reference past interactions, making it suitable for use cases such as customer support, virtual assistants, or any application where context retention is crucial.\n\n"
},
"typeVersion": 1
},
{
"id": "a991a7c9-ea5f-4a25-aa92-6dc2fce11b05",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
120
],
"parameters": {
"color": 7,
"width": 330.5152611046425,
"height": 240.6839895136402,
"content": "### ... or watch set up video [5 min]\n[.png)](https://www.youtube.com/watch?v=kS41gut8l0g)\n"
},
"typeVersion": 1
}
],
"connections": {
"Merge": {
"main": [
[
{
"node": "OPENAI - Send message",
"type": "main",
"index": 0
}
]
]
},
"Find User": {
"main": [
[
{
"node": "If User exists",
"type": "main",
"index": 0
}
]
]
},
"Create User": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"If User exists": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
],
[
{
"node": "OPENAI - Create thread",
"type": "main",
"index": 0
}
]
]
},
"Get New Message": {
"main": [
[
{
"node": "Find User",
"type": "main",
"index": 0
}
]
]
},
"OPENAI - Get messages": {
"main": [
[
{
"node": "Send Message to User",
"type": "main",
"index": 0
}
]
]
},
"OPENAI - Send message": {
"main": [
[
{
"node": "OPENAI - Run assistant",
"type": "main",
"index": 0
}
]
]
},
"OPENAI - Create thread": {
"main": [
[
{
"node": "Create User",
"type": "main",
"index": 0
}
]
]
},
"OPENAI - Run assistant": {
"main": [
[
{
"node": "OPENAI - Get messages",
"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.
openAiApisupabaseApitelegramApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
This workflow enables seamless AI-powered conversations in Telegram by automatically processing incoming messages, generating intelligent responses via OpenAI, and storing interaction data in Supabase for easy management. It's ideal for developers or businesses building chatbots that handle customer queries, provide support, or engage users without manual intervention, saving hours of response time and enhancing user experience. The key step involves the Telegram trigger capturing new messages, followed by a chain of HTTP requests to OpenAI for creating threads, sending prompts, running the assistant, and retrieving responses before dispatching them back via Telegram.
Use this workflow when you need an event-driven chatbot that integrates Telegram with AI for real-time interactions, such as in support bots or informational services. Avoid it for simple message forwarding without AI, as the OpenAI calls add unnecessary complexity and cost. Common variations include swapping Supabase for another database like PostgreSQL or adding conditional logic to route messages to different assistants based on content.
About this workflow
Http Telegram. Uses telegramTrigger, httpRequest, supabase, telegram. Event-driven trigger; 17 nodes.
Source: https://github.com/Zie619/n8n-workflows — 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.
Telegram-auth. Uses telegramTrigger, telegram, supabase, httpRequest. Event-driven trigger; 18 nodes.
Telegram Trigger, Telegram, Supabase +1
Telegram-auth. Uses telegramTrigger, telegram, supabase, httpRequest. Event-driven trigger; 18 nodes.
Telegram Trigger, Telegram, Supabase +1
Http Telegram. Uses telegramTrigger, httpRequest, supabase, telegram. Event-driven trigger; 17 nodes.
Telegram Trigger, HTTP Request, Supabase +1
N8N Complete Final. Uses telegramTrigger, dataTable, telegram, mqtt. Event-driven trigger; 58 nodes.
Telegram Trigger, Data Table, Telegram +3
Pede Ai. Uses httpRequest, telegram, postgres, telegramTrigger. Event-driven trigger; 57 nodes.
HTTP Request, Telegram, Postgres +1