集成 Supabase 记忆与 OpenAI 助手的 Telegram 机器人
中级
这是一个AI领域的自动化工作流，包含 15 个节点。主要使用 If, Merge, Supabase, Telegram, HttpRequest 等节点，结合人工智能技术实现智能自动化。 集成 Supabase 记忆与 OpenAI 助手的 Telegram 机器人
前置要求
- •Supabase URL 和 API Key
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"nodes": [
{
"id": "9cc26a42-eb43-40c4-b507-cbaf187a5e15",
"name": "获取新消息",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
1120,
500
],
"webhookId": "464f0a75-56d1-402f-8b12-b358452e9736",
"parameters": {
"updates": [
"message"
],
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "rI0zyfIYVIyXt2fL",
"name": "Telegram Club"
}
},
"typeVersion": 1.1
},
{
"id": "098b6fcf-7cb6-4730-8892-949fedc946b3",
"name": "OPENAI - 创建线程",
"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": {
"id": "zJhr5piyEwVnWtaI",
"name": "OpenAi club"
}
},
"typeVersion": 4.2
},
{
"id": "fa157f8c-b776-4b20-bfaf-c17460383505",
"name": "创建用户",
"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": {
"id": "QBhcokohbJHfQZ9A",
"name": "Supabase club"
}
},
"typeVersion": 1
},
{
"id": "115e417f-5962-409b-8adf-ff236eb9ce2e",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
2080,
500
],
"parameters": {},
"typeVersion": 3
},
{
"id": "ba5c7385-8c80-43c8-9de2-430175bda70b",
"name": "OPENAI - 发送消息",
"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": {
"id": "fLfRtaXbR0EVD0pl",
"name": "OpenAi account"
}
},
"typeVersion": 4.2
},
{
"id": "024832bc-3d42-4879-a57f-b23e962b4c69",
"name": "OPENAI - 运行助手",
"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": {
"id": "fLfRtaXbR0EVD0pl",
"name": "OpenAi account"
}
},
"typeVersion": 4.2
},
{
"id": "bc191e2b-15f4-45b7-af2e-19ed1639b7f5",
"name": "OPENAI - 获取消息",
"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": {
"id": "zJhr5piyEwVnWtaI",
"name": "OpenAi club"
}
},
"typeVersion": 4.2
},
{
"id": "c22e05e5-f0a7-4a09-a864-acfc58469b30",
"name": "向用户发送消息",
"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": {
"id": "rI0zyfIYVIyXt2fL",
"name": "Telegram Club"
}
},
"typeVersion": 1.2
},
{
"id": "0673be1f-3cae-42a0-9c62-1ed570859043",
"name": "如果用户存在",
"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": "查找用户",
"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": {
"id": "QBhcokohbJHfQZ9A",
"name": "Supabase club"
}
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "6d01d7ed-e96b-47cf-9a5f-46608031baa2",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
800
],
"parameters": {
"color": 7,
"width": 600.723278204605,
"height": 213.15921994594194,
"content": "在 Supabase 中创建表的 SQL 查询："
},
"typeVersion": 1
},
{
"id": "1a996da0-6022-48d7-ba40-1d137547a3d7",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2340,
360
],
"parameters": {
"color": 3,
"width": 282.075050779723,
"height": 80,
"content": "在 [OpenAI](https://platform.openai.com/assistants) 中创建助手。"
},
"typeVersion": 1
},
{
"id": "b24d2008-7950-41f0-a7fa-50360c0c6854",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1040,
380
],
"parameters": {
"color": 3,
"width": 235.09282368774151,
"height": 80,
"content": "在 [Botfather bot](https://t.me/botfather) 中创建您自己的 Telegram 机器人"
},
"typeVersion": 1
},
{
"id": "9eb2491e-5ad9-4015-8ed9-611e72924503",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
680
],
"parameters": {
"color": 3,
"height": 80,
"content": "使用 SQL 查询在 [Supabase](https://supabase.com) 中创建表"
},
"typeVersion": 1
},
{
"id": "884b5a1b-007c-4752-becc-46c8fc58db92",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
120
],
"parameters": {
"color": 7,
"width": 280.2462120317618,
"height": 438.5821431288714,
"content": "### 设置步骤"
},
"typeVersion": 1
},
{
"id": "02db77ac-4909-4a56-a558-03c86d8b8552",
"name": "### 需要帮助？",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
-400
],
"parameters": {
"color": 7,
"width": 636.2128494576581,
"height": 494.9629292914819,
"content": ".png)"
},
"typeVersion": 1
},
{
"id": "a991a7c9-ea5f-4a25-aa92-6dc2fce11b05",
"name": "## 试试看！",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
120
],
"parameters": {
"color": 7,
"width": 330.5152611046425,
"height": 240.6839895136402,
"content": "### ... 或者观看设置视频 [5 分钟]"
},
"typeVersion": 1
}
],
"pinData": {
"Merge": [
{
"id": "4a5d71a4-a2f7-43e2-936f-37ee5bf5cc9e",
"telegram_id": 1468754364,
"date_created": "2024-10-04T08:29:07.458869+00:00",
"openai_thread_id": null
}
],
"Find User": [
{
"id": "4a5d71a4-a2f7-43e2-936f-37ee5bf5cc9e",
"telegram_id": 1468754364,
"date_created": "2024-10-04T08:29:07.458869+00:00",
"openai_thread_id": null
}
],
"Get New Message": [
{
"message": {
"chat": {
"id": 1468754364,
"type": "private",
"username": "low_code",
"first_name": "Mark"
},
"date": 1727961249,
"from": {
"id": 1468754364,
"is_bot": false,
"username": "low_code",
"first_name": "Mark",
"language_code": "en"
},
"text": "Hello, how are you?",
"entities": [
{
"type": "bot_command",
"length": 6,
"offset": 0
}
],
"message_id": 3
},
"update_id": 412281353
}
],
"Send Message to User": [
{
"ok": true,
"result": {
"chat": {
"id": 1468754364,
"type": "private",
"username": "low_code",
"first_name": "Mark"
},
"date": 1727971919,
"from": {
"id": 7999029315,
"is_bot": true,
"username": "test241234_bot",
"first_name": "Test bot"
},
"text": "Hello! I'm just a program, but I'm here and ready to help you. How can I assist you today?",
"message_id": 7
}
}
],
"OPENAI - Get messages": [
{
"data": [
{
"id": "msg_C7aXbSotAl6xCxjR9avi4wUz",
"role": "assistant",
"object": "thread.message",
"run_id": "run_9avgP4lZ1FRSsL3y9UO8HPa1",
"content": [
{
"text": {
"value": "Hello! I'm just a program, but I'm here and ready to help you. How can I assist you today?",
"annotations": []
},
"type": "text"
}
],
"metadata": {},
"thread_id": "thread_laO8JLPW6L1upYHW6fSRj8Bt",
"created_at": 1727971739,
"attachments": [],
"assistant_id": "asst_b0QhuzySG6jofHFdzPZD7WEz"
},
{
"id": "msg_fVGPVHR03QKheHXh54SFpmpm",
"role": "user",
"object": "thread.message",
"run_id": null,
"content": [
{
"text": {
"value": "Hello, how are you?",
"annotations": []
},
"type": "text"
}
],
"metadata": {},
"thread_id": "thread_laO8JLPW6L1upYHW6fSRj8Bt",
"created_at": 1727971467,
"attachments": [],
"assistant_id": null
}
],
"object": "list",
"last_id": "msg_fVGPVHR03QKheHXh54SFpmpm",
"first_id": "msg_C7aXbSotAl6xCxjR9avi4wUz",
"has_more": false
}
],
"OPENAI - Send message": [
{
"id": "msg_fVGPVHR03QKheHXh54SFpmpm",
"role": "user",
"object": "thread.message",
"run_id": null,
"content": [
{
"text": {
"value": "Hello, how are you?",
"annotations": []
},
"type": "text"
}
],
"metadata": {},
"thread_id": "thread_laO8JLPW6L1upYHW6fSRj8Bt",
"created_at": 1727971467,
"attachments": [],
"assistant_id": null
}
],
"OPENAI - Create thread": [
{
"id": "thread_laO8JLPW6L1upYHW6fSRj8Bt",
"object": "thread",
"metadata": {},
"created_at": 1727971362,
"tool_resources": {}
}
],
"OPENAI - Run assistant": [
{
"data": "event: thread.run.created\ndata: {\"id\":\"run_9avgP4lZ1FRSsL3y9UO8HPa1\",\"object\":\"thread.run\",\"created_at\":1727971737,\"assistant_id\":\"asst_b0QhuzySG6jofHFdzPZD7WEz\",\"thread_id\":\"thread_laO8JLPW6L1upYHW6fSRj8Bt\",\"status\":\"queued\",\"started_at\":null,\"expires_at\":1727972337,\"cancelled_at\":null,\"failed_at\":null,\"completed_at\":null,\"required_action\":null,\"last_error\":null,\"model\":\"gpt-4o-mini\",\"instructions\":\"You are ChatGPT\",\"tools\":[],\"tool_resources\":{\"code_interpreter\":{\"file_ids\":[]}},\"metadata\":{},\"temperature\":1.0,\"top_p\":1.0,\"max_completion_tokens\":null,\"max_prompt_tokens\":null,\"truncation_strategy\":{\"type\":\"auto\",\"last_messages\":null},\"incomplete_details\":null,\"usage\":null,\"response_format\":\"auto\",\"tool_choice\":\"auto\",\"parallel_tool_calls\":true}\n\nevent: thread.run.queued\ndata: {\"id\":\"run_9avgP4lZ1FRSsL3y9UO8HPa1\",\"object\":\"thread.run\",\"created_at\":1727971737,\"assistant_id\":\"asst_b0QhuzySG6jofHFdzPZD7WEz\",\"thread_id\":\"thread_laO8JLPW6L1upYHW6fSRj8Bt\",\"status\":\"queued\",\"started_at\":null,\"expires_at\":1727972337,\"cancelled_at\":null,\"failed_at\":null,\"completed_at\":null,\"required_action\":null,\"last_error\":null,\"model\":\"gpt-4o-mini\",\"instructions\":\"You are ChatGPT\",\"tools\":[],\"tool_resources\":{\"code_interpreter\":{\"file_ids\":[]}},\"metadata\":{},\"temperature\":1.0,\"top_p\":1.0,\"max_completion_tokens\":null,\"max_prompt_tokens\":null,\"truncation_strategy\":{\"type\":\"auto\",\"last_messages\":null},\"incomplete_details\":null,\"usage\":null,\"response_format\":\"auto\",\"tool_choice\":\"auto\",\"parallel_tool_calls\":true}\n\nevent: thread.run.in_progress\ndata: {\"id\":\"run_9avgP4lZ1FRSsL3y9UO8HPa1\",\"object\":\"thread.run\",\"created_at\":1727971737,\"assistant_id\":\"asst_b0QhuzySG6jofHFdzPZD7WEz\",\"thread_id\":\"thread_laO8JLPW6L1upYHW6fSRj8Bt\",\"status\":\"in_progress\",\"started_at\":1727971738,\"expires_at\":1727972337,\"cancelled_at\":null,\"failed_at\":null,\"completed_at\":null,\"required_action\":null,\"last_error\":null,\"model\":\"gpt-4o-mini\",\"instructions\":\"You are ChatGPT\",\"tools\":[],\"tool_resources\":{\"code_interpreter\":{\"file_ids\":[]}},\"metadata\":{},\"temperature\":1.0,\"top_p\":1.0,\"max_completion_tokens\":null,\"max_prompt_tokens\":null,\"truncation_strategy\":{\"type\":\"auto\",\"last_messages\":null},\"incomplete_details\":null,\"usage\":null,\"response_format\":\"auto\",\"tool_choice\":\"auto\",\"parallel_tool_calls\":true}\n\nevent: thread.run.step.created\ndata: {\"id\":\"step_b0iFvL1q1UEZDfBRbbNTiulO\",\"object\":\"thread.run.step\",\"created_at\":1727971739,\"run_id\":\"run_9avgP4lZ1FRSsL3y9UO8HPa1\",\"assistant_id\":\"asst_b0QhuzySG6jofHFdzPZD7WEz\",\"thread_id\":\"thread_laO8JLPW6L1upYHW6fSRj8Bt\",\"type\":\"message_creation\",\"status\":\"in_progress\",\"cancelled_at\":null,\"completed_at\":null,\"expires_at\":1727972337,\"failed_at\":null,\"last_error\":null,\"step_details\":{\"type\":\"message_creation\",\"message_creation\":{\"message_id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\"}},\"usage\":null}\n\nevent: thread.run.step.in_progress\ndata: {\"id\":\"step_b0iFvL1q1UEZDfBRbbNTiulO\",\"object\":\"thread.run.step\",\"created_at\":1727971739,\"run_id\":\"run_9avgP4lZ1FRSsL3y9UO8HPa1\",\"assistant_id\":\"asst_b0QhuzySG6jofHFdzPZD7WEz\",\"thread_id\":\"thread_laO8JLPW6L1upYHW6fSRj8Bt\",\"type\":\"message_creation\",\"status\":\"in_progress\",\"cancelled_at\":null,\"completed_at\":null,\"expires_at\":1727972337,\"failed_at\":null,\"last_error\":null,\"step_details\":{\"type\":\"message_creation\",\"message_creation\":{\"message_id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\"}},\"usage\":null}\n\nevent: thread.message.created\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message\",\"created_at\":1727971739,\"assistant_id\":\"asst_b0QhuzySG6jofHFdzPZD7WEz\",\"thread_id\":\"thread_laO8JLPW6L1upYHW6fSRj8Bt\",\"run_id\":\"run_9avgP4lZ1FRSsL3y9UO8HPa1\",\"status\":\"in_progress\",\"incomplete_details\":null,\"incomplete_at\":null,\"completed_at\":null,\"role\":\"assistant\",\"content\":[],\"attachments\":[],\"metadata\":{}}\n\nevent: thread.message.in_progress\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message\",\"created_at\":1727971739,\"assistant_id\":\"asst_b0QhuzySG6jofHFdzPZD7WEz\",\"thread_id\":\"thread_laO8JLPW6L1upYHW6fSRj8Bt\",\"run_id\":\"run_9avgP4lZ1FRSsL3y9UO8HPa1\",\"status\":\"in_progress\",\"incomplete_details\":null,\"incomplete_at\":null,\"completed_at\":null,\"role\":\"assistant\",\"content\":[],\"attachments\":[],\"metadata\":{}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\"Hello\",\"annotations\":[]}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\"!\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" I'm\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" just\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" a\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" program\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\",\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" but\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" I'm\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" here\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" and\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" ready\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" to\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" help\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" you\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\".\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" How\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" can\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" I\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" assist\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" you\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\" today\"}}]}}\n\nevent: thread.message.delta\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message.delta\",\"delta\":{\"content\":[{\"index\":0,\"type\":\"text\",\"text\":{\"value\":\"?\"}}]}}\n\nevent: thread.message.completed\ndata: {\"id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\",\"object\":\"thread.message\",\"created_at\":1727971739,\"assistant_id\":\"asst_b0QhuzySG6jofHFdzPZD7WEz\",\"thread_id\":\"thread_laO8JLPW6L1upYHW6fSRj8Bt\",\"run_id\":\"run_9avgP4lZ1FRSsL3y9UO8HPa1\",\"status\":\"completed\",\"incomplete_details\":null,\"incomplete_at\":null,\"completed_at\":1727971740,\"role\":\"assistant\",\"content\":[{\"type\":\"text\",\"text\":{\"value\":\"Hello! I'm just a program, but I'm here and ready to help you. How can I assist you today?\",\"annotations\":[]}}],\"attachments\":[],\"metadata\":{}}\n\nevent: thread.run.step.completed\ndata: {\"id\":\"step_b0iFvL1q1UEZDfBRbbNTiulO\",\"object\":\"thread.run.step\",\"created_at\":1727971739,\"run_id\":\"run_9avgP4lZ1FRSsL3y9UO8HPa1\",\"assistant_id\":\"asst_b0QhuzySG6jofHFdzPZD7WEz\",\"thread_id\":\"thread_laO8JLPW6L1upYHW6fSRj8Bt\",\"type\":\"message_creation\",\"status\":\"completed\",\"cancelled_at\":null,\"completed_at\":1727971740,\"expires_at\":1727972337,\"failed_at\":null,\"last_error\":null,\"step_details\":{\"type\":\"message_creation\",\"message_creation\":{\"message_id\":\"msg_C7aXbSotAl6xCxjR9avi4wUz\"}},\"usage\":{\"prompt_tokens\":39,\"completion_tokens\":25,\"total_tokens\":64}}\n\nevent: thread.run.completed\ndata: {\"id\":\"run_9avgP4lZ1FRSsL3y9UO8HPa1\",\"object\":\"thread.run\",\"created_at\":1727971737,\"assistant_id\":\"asst_b0QhuzySG6jofHFdzPZD7WEz\",\"thread_id\":\"thread_laO8JLPW6L1upYHW6fSRj8Bt\",\"status\":\"completed\",\"started_at\":1727971738,\"expires_at\":null,\"cancelled_at\":null,\"failed_at\":null,\"completed_at\":1727971740,\"required_action\":null,\"last_error\":null,\"model\":\"gpt-4o-mini\",\"instructions\":\"You are ChatGPT\",\"tools\":[],\"tool_resources\":{\"code_interpreter\":{\"file_ids\":[]}},\"metadata\":{},\"temperature\":1.0,\"top_p\":1.0,\"max_completion_tokens\":null,\"max_prompt_tokens\":null,\"truncation_strategy\":{\"type\":\"auto\",\"last_messages\":null},\"incomplete_details\":null,\"usage\":{\"prompt_tokens\":39,\"completion_tokens\":25,\"total_tokens\":64},\"response_format\":\"auto\",\"tool_choice\":\"auto\",\"parallel_tool_calls\":true}\n\nevent: done\ndata: [DONE]\n\n"
}
]
},
"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
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI智能助手：与Supabase存储和Google Drive文件对话
AI智能助手：与Supabase存储和Google Drive文件对话
If
Set
Wait
+20
62 节点Mark Shcherbakov
工程
与Supabase存储中文件对话的AI智能体
与Supabase存储中文件对话的AI智能体
If
Merge
Switch
+15
33 节点Mark Shcherbakov
工程
AI智能体用于会议实时洞察
AI智能体用于会议实时洞察
If
Set
Webhook
+6
19 节点Mark Shcherbakov
销售
AI智能助手与Airtable对话及数据分析
AI智能助手与Airtable对话及数据分析
If
Set
Merge
+12
41 节点Mark Shcherbakov
工程
使用Telegram、Airtable和GPT驱动的AI代理进行技术股票分析
使用Telegram、Airtable和GPT驱动的AI代理进行技术股票分析
Set
Switch
Webhook
+14
35 节点Mark Shcherbakov
财务
构建与销售AI自动化与智能体
构建与销售AI自动化与智能体
If
Set
Wait
+15
74 节点NICKYAI
其他
工作流信息
难度等级
中级
节点数量15
分类1
节点类型7
作者
Mark Shcherbakov
@lowcodingdevI am a business analyst with a development background, dedicated to helping small businesses and entrepreneurs leverage cloud services for increased efficiency. My expertise lies in automating manual workflows, integrating data from multiple cloud service providers, creating insightful dashboards, and building custom CRM systems.
外部链接
在 n8n.io 查看 →
分享此工作流