语音助手 - 餐厅预订、点餐与信息系统
这是一个Support Chatbot, AI Chatbot领域的自动化工作流,包含 10 个节点。主要使用 Wait, Webhook, Postgres, RespondToWebhook 等节点。 使用VAPI和PostgreSQL构建餐厅语音助手,支持预订和点餐
- •HTTP Webhook 端点(n8n 会自动生成)
- •PostgreSQL 数据库连接信息
{
"id": "FBguDlbJmbBGngKf",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "语音助手 - 餐厅预订、点餐与信息系统",
"tags": [],
"nodes": [
{
"id": "ca6c5397-c47e-4fde-b08a-c996fc5b242b",
"name": "触发器:语音请求 (VAPI)",
"type": "n8n-nodes-base.webhook",
"position": [
-20,
-380
],
"webhookId": "9f6b9125-0b75-41c2-87a9-1b6746c89e2e",
"parameters": {
"path": "9f6b9125-0b75-41c2-87a9-1b6746c89e2e",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2
},
{
"id": "bbb963c4-1fc3-4dbc-84c5-ed818197fc8a",
"name": "更新数据(餐桌预订/订单)",
"type": "n8n-nodes-base.postgres",
"position": [
420,
-380
],
"parameters": {
"table": {
"__rl": true,
"mode": "name",
"value": "id"
},
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"columns": {
"value": {},
"schema": [],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "upsert"
},
"credentials": {
"postgres": {
"id": "4Y4qEFGqF2krfRHZ",
"name": "Postgres-test"
}
},
"typeVersion": 2.6
},
{
"id": "97376776-cc21-434b-89b3-e373d4fcc0fe",
"name": "响应:预订/订单确认 (VAPI)",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
640,
-380
],
"parameters": {
"options": {},
"respondWith": "json",
"responseBody": "={\n \"results\": [\n {\n \"toolCallId\": \"{{ $('Trigger: Voice Request (VAPI)').item.json.body.message.toolCalls[0].id }}\",\n \"result\": \"{{ $json.status }}\"\n }\n ]\n}"
},
"typeVersion": 1.2
},
{
"id": "7cdb8cb3-94fd-4784-9b79-c9ae26fd7ae6",
"name": "等待响应",
"type": "n8n-nodes-base.wait",
"position": [
200,
-380
],
"webhookId": "70ef62ba-b15e-48d6-b6ea-031f1ad02176",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "f715f043-661b-4118-9763-642128d936ce",
"name": "等待响应1",
"type": "n8n-nodes-base.wait",
"position": [
420,
-120
],
"webhookId": "5282819f-e54d-415e-a2a2-384df4b9f71d",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "4a2f8aee-6e5a-44d5-873c-8b8c28aeff3b",
"name": "触发器:信息请求 (VAPI)",
"type": "n8n-nodes-base.webhook",
"position": [
-20,
-120
],
"webhookId": "efe2c13f-1ba5-46e1-9996-57bdc6041973",
"parameters": {
"path": "efe2c13f-1ba5-46e1-9996-57bdc6041973",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2
},
{
"id": "33a7e434-5228-4475-9b21-a5afb7c8656b",
"name": "获取餐厅信息 (Postgres)",
"type": "n8n-nodes-base.postgres",
"position": [
200,
-120
],
"parameters": {
"table": {
"__rl": true,
"mode": "name",
"value": "id"
},
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"options": {},
"operation": "select"
},
"credentials": {
"postgres": {
"id": "4Y4qEFGqF2krfRHZ",
"name": "Postgres-test"
}
},
"typeVersion": 2.6
},
{
"id": "09058c8d-e3f4-4caa-898a-123ef4ec3eba",
"name": "响应:餐厅详情 (VAPI)",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
640,
-120
],
"parameters": {
"options": {},
"respondWith": "json",
"responseBody": "={\n \"results\": [\n {\n \"toolCallId\": \"{{ $('Trigger: Info Request (VAPI)').item.json.body.message.toolCalls[0].id }}\",\n \"result\": \"{{ $json.available }}\"\n }\n ]\n}"
},
"typeVersion": 1.2
},
{
"id": "e5c43fa2-68c9-4303-bd74-6662cf95a05f",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-620
],
"parameters": {
"color": 4,
"width": 440,
"height": 340,
"content": "## 餐桌预订与订单处理"
},
"typeVersion": 1
},
{
"id": "4ec14fb4-e367-4b3f-bba4-50cc70c008d2",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-500,
-220
],
"parameters": {
"width": 480,
"height": 340,
"content": "## 餐厅信息提供者"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"timezone": "Asia/Kolkata",
"callerPolicy": "workflowsFromSameOwner",
"executionOrder": "v1"
},
"versionId": "01e81376-112a-42ae-bb2f-5037a2d5da94",
"connections": {
"Wait For Response": {
"main": [
[
{
"node": "Update Data (Table Booking / Orders)",
"type": "main",
"index": 0
}
]
]
},
"Wait For Response1": {
"main": [
[
{
"node": "Respond: Restaurant Details (VAPI)",
"type": "main",
"index": 0
}
]
]
},
"Trigger: Info Request (VAPI)": {
"main": [
[
{
"node": " Get Restaurant Info (Postgres)",
"type": "main",
"index": 0
}
]
]
},
"Trigger: Voice Request (VAPI)": {
"main": [
[
{
"node": "Wait For Response",
"type": "main",
"index": 0
}
]
]
},
" Get Restaurant Info (Postgres)": {
"main": [
[
{
"node": "Wait For Response1",
"type": "main",
"index": 0
}
]
]
},
"Update Data (Table Booking / Orders)": {
"main": [
[
{
"node": "Respond: Booking/Order Confirmation (VAPI)",
"type": "main",
"index": 0
}
]
]
}
}
}如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 客服机器人, AI 聊天机器人
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
Oneclick AI Squad
@oneclick-aiThe AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.
分享此工作流