客户响应器 IG/TG
中级
这是一个Support Chatbot, AI Chatbot领域的自动化工作流，包含 10 个节点。主要使用 Code, Webhook, GoogleSheets, RespondToWebhook, ChainLlm 等节点。 使用 GPT-4 和 Google Sheets 的自动化产品咨询响应器
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "vMvm0kfL6V7u4bPO",
"meta": {
"instanceId": "089a426694e95c86fd56db3433ae1586d34120d3ffcad01bcaa9ff768b7f5853",
"templateCredsSetupCompleted": true
},
"name": "客户响应器 IG/TG",
"tags": [],
"nodes": [
{
"id": "be329d21-b0fb-49a4-92ed-651f2297890c",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-340,
220
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-3.5-turbo",
"cachedResultName": "gpt-3.5-turbo"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "sSgwqUMSiCdMlx5r",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "aadcdcde-c6b2-4815-8088-4f310f4d0065",
"name": "OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
780,
200
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4",
"cachedResultName": "gpt-4"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "sSgwqUMSiCdMlx5r",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "760e2d6c-b121-4de8-bcf9-b117d2a771bc",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-700,
-340
],
"parameters": {
"color": 3,
"width": 2060,
"height": 860,
"content": "工作流节点描述："
},
"typeVersion": 1
},
{
"id": "e89e72bb-c8ad-406c-a9a5-1297ae4974c9",
"name": "接收请求",
"type": "n8n-nodes-base.webhook",
"position": [
-600,
0
],
"webhookId": "753f3fe9-b17b-4431-81c2-a011044768d0",
"parameters": {
"path": "/shoe-orders",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2
},
{
"id": "f0ee0564-5a40-4174-a80f-8c74d2d7e878",
"name": "解析请求 AI",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
-360,
0
],
"parameters": {
"text": "={{ $('Receive Request').first().json.body.message }}",
"batching": {},
"messages": {
"messageValues": [
{
"type": "=SystemMessagePromptTemplate",
"message": "=Extract shoe details from customer inquiry: brand name, model name, size, and color. Return only valid JSON format: {\"brand\": \"\", \"model\": \"\", \"size\": \"\", \"color\": \"\"}\n\nExamples:\n- \"Do you have Nike Air Max size 40?\" → {\"brand\": \"Nike\", \"model\": \"Air Max\", \"size\": \"40\", \"color\": \"\"}\n- \"Looking for white Adidas size 38\" → {\"brand\": \"Adidas\", \"model\": \"\", \"size\": \"38\", \"color\": \"white\"}\n\nCustomer message: {{ $json.message }}"
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "8805f637-67ed-40e7-97c2-02bb84da2f2d",
"name": "提取数据",
"type": "n8n-nodes-base.code",
"position": [
80,
0
],
"parameters": {
"jsCode": "const input = $input.first().json;\nconst parsedData = JSON.parse(input.text);\n\nreturn [{\n json: {\n brand: parsedData.brand || \"\",\n model: parsedData.model || \"\",\n size: parsedData.size || \"\",\n color: parsedData.color || \"\"\n }\n}];"
},
"typeVersion": 2
},
{
"id": "690c3190-4732-475a-8fad-00faa6897bf9",
"name": "产品数据库",
"type": "n8n-nodes-base.googleSheets",
"position": [
300,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1AczF58510i-QEppNi_UnzgqqfX0ickNJZjFW2Bu-6mI/edit#gid=0",
"cachedResultName": "Лист1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1AczF58510i-QEppNi_UnzgqqfX0ickNJZjFW2Bu-6mI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1AczF58510i-QEppNi_UnzgqqfX0ickNJZjFW2Bu-6mI/edit?usp=drivesdk",
"cachedResultName": "In Stock"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "up4mnfP28XT5t6r6",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.6
},
{
"id": "3da1277f-e726-4818-8ff6-e7e888d353ab",
"name": "过滤产品",
"type": "n8n-nodes-base.code",
"position": [
540,
0
],
"parameters": {
"jsCode": "const allItems = $input.all();\nconst search = $('Extract Data').first().json;\n\nconst filtered = allItems.filter(item => {\n const brandMatch = item.json.Brand?.toString()?.toLowerCase() === search.brand?.toLowerCase();\n const modelMatch = search.model ? item.json.Model?.toString()?.toLowerCase().includes(search.model?.toLowerCase()) : true;\n const sizeMatch = item.json.Size?.toString() === search.size;\n const colorMatch = search.color ? item.json.Color?.toString()?.toLowerCase().includes(search.color?.toLowerCase()) : true;\n \n return brandMatch && modelMatch && sizeMatch && colorMatch;\n});\n\nreturn filtered;"
},
"typeVersion": 2
},
{
"id": "37324505-d063-4d2a-9c2e-d195b54357eb",
"name": "AI 管理器",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
740,
0
],
"parameters": {
"text": "={{ $('Receive Request').first().json.body.message }}",
"batching": {},
"messages": {
"messageValues": [
{
"type": "=SystemMessagePromptTemplate",
"message": "=You are a friendly shoe store assistant. Based on the product data below, generate a helpful response about availability, pricing, and stock.\n\nProduct data: {{ JSON.stringify($input.all()) }}\n\nResponse style: Friendly, helpful, and informative. Include price, stock quantity, and suggest alternatives if item is out of stock."
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "d2e5c074-c68a-489c-8503-51cbda2bc267",
"name": "发送响应",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
1140,
0
],
"parameters": {
"options": {},
"respondWith": "text",
"responseBody": "={{ $json.text }}"
},
"typeVersion": 1.3
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "aa3fd2f1-d011-4c19-ab53-b2e3405a1c5c",
"connections": {
"AI Manager": {
"main": [
[
{
"node": "Send Response",
"type": "main",
"index": 0
}
]
]
},
"Extract Data": {
"main": [
[
{
"node": "Product Database",
"type": "main",
"index": 0
}
]
]
},
"Filter Products": {
"main": [
[
{
"node": "AI Manager",
"type": "main",
"index": 0
}
]
]
},
"Receive Request": {
"main": [
[
{
"node": "Parse Request AI",
"type": "main",
"index": 0
}
]
]
},
"Parse Request AI": {
"main": [
[
{
"node": "Extract Data",
"type": "main",
"index": 0
}
]
]
},
"Product Database": {
"main": [
[
{
"node": "Filter Products",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Parse Request AI",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "AI Manager",
"type": "ai_languageModel",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 客服机器人, AI 聊天机器人
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用WhatsApp AI助手和Google文档及Gemini自动处理客户支持
使用WhatsApp AI助手和Google文档及Gemini自动处理客户支持
If
Code
Webhook
+9
14 节点Jamot
客服机器人
我的工作流4
具有专业助手的 GPT-4 多智能体聊天的精美 Web 界面
Code
Switch
Webhook
+4
24 节点Hugo
客服机器人
构建用于Slack候选人评估的AI驱动聊天机器人
AI简历分析与候选人评估：Slack和Google表格集成
If
Code
Slack
+12
29 节点Trung Tran
AI 聊天机器人
PDF文档助手2.0
使用GPT和o4-mini分析法律文档，集成Gmail和Google Sheets
Code
Gmail
Webhook
+7
18 节点Swot.AI
AI 摘要总结
航空公司常见问题解答机器人
使用GPT-4和问题分类自动化航空公司客户支持
If
Code
Merge
+4
27 节点Oneclick AI Squad
客服机器人
具备多步骤工具执行的AI驱动HVAC排程代理
通过AI代理、Google日历和Gmail自动化HVAC服务排程
Wait
Gmail
Webhook
+11
30 节点Bhuvanesh R
客服机器人
工作流信息
难度等级
中级
节点数量10
分类2
节点类型7
作者
Dmytro
@dima-aiNot a professional developer, just someone who believes automation can make our already challenging lives a bit easier. I create practical n8n workflows that solve real business problems - from AI-powered customer service to inventory management. Based in Ukraine, I understand the value of efficiency and resourcefulness. My workflows are designed for small businesses and entrepreneurs who need smart solutions without breaking the bank.
外部链接
在 n8n.io 查看 →
分享此工作流