使用AI在WhatsApp和Google表格上自动化餐厅预订
高级
这是一个Support Chatbot, AI Chatbot领域的自动化工作流，包含 23 个节点。主要使用 If, Filter, WhatsApp, GoogleSheets, Agent 等节点。 使用AI在WhatsApp和Google表格上自动化餐厅预订
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (23)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "6570b9a3c619b905a29a1c8dcd31f41add28a4b324f4ec6bd206e06c2b9731cf"
},
"nodes": [
{
"id": "5fc9e0fb-70c7-4a69-b24b-7c791f4b3bf1",
"name": "发送消息",
"type": "n8n-nodes-base.whatsApp",
"onError": "continueRegularOutput",
"position": [
1040,
0
],
"webhookId": "750581ca-8153-4d15-85bb-72af25176a37",
"parameters": {
"textBody": "={{ $json.output }}",
"operation": "send",
"phoneNumberId": "668904212970806",
"additionalFields": {},
"recipientPhoneNumber": "={{ $('WhatsApp Trigger').item.json.messages[0].from }}"
},
"typeVersion": 1
},
{
"id": "250d747c-a938-47c6-92a7-5bba1b430ca7",
"name": "WhatsApp触发器",
"type": "n8n-nodes-base.whatsAppTrigger",
"position": [
0,
0
],
"webhookId": "7de2c19b-818e-4e24-a2cb-f107a1be6fc6",
"parameters": {
"options": {},
"updates": [
"messages"
]
},
"typeVersion": 1
},
{
"id": "a2b3e9f9-cde6-41d9-87c9-e6f571df2a67",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"onError": "continueRegularOutput",
"position": [
624,
0
],
"parameters": {
"text": "={{ $json.messages[0].text.body }}",
"options": {
"systemMessage": "=Role\nyour role is to act as a reservation agent for The carnival all the buffet. you are a highly intellectual individual who can cater to any customer needs regarding reservation assisting customers in making reservations by getting all the details and logging \"\"log reservation\"\" tool and confirming if they would like to in pay advance to secure their reservation spot or arrive 15 minutes early. once you have confirmed all the details prompt the customer that the reservation has been logged they will recive the confirmation shortly \nDate and time is: {{ $now.format('yyyy-MM-DDDD-hh-mm-ss-') }}\n\nTask\n\nGuide customers through the reservation process by collecting necessary information such as name, phone number, slot timings, date, and number of persons for the reservation make sure to collect all of the above details.Use the \"log reservation\" tool to input this information\n\nWhen customers inquire about the menu, the discounts on the cards, provide them with the link \n\nhttps://www.instagram.com/p/DJKBhCatQ1Y/?img_index=1\n\nIf they press D for the location of the restaurant, provide them with this link: https://www.google.com/maps/place/The+Carnival+All+Day+Buffet/@31.5217381,74.3486342,17z/data=!3m1!4b1!4m6!3m5!1s0x3919053a9b6bc1fb:0xf473ee386cffadaa!8m2!3d31.5217381!4d74.3512091!16s%2Fg%2F11thhhd98r?entry=ttu&g_ep=EgoyMDI1MDUxMy4xIKXMDSoASAFQAw%3D%3D\n\nthe following variables are required to make a reservation (\"name\", \"phone number\", \"date\", \"number of persons\", \"slot timings\").\n\nMake sure to confirm the customer avaliblity (arrive early or pay now) before logging in the reservation in \"log reservation\" tool\n\nAdditionally, DISCOUNT CALCULATION\nCalculation of discount does not count in making a reservsation. calulating discount is a differetn part of your job not not combine it with logging reservations \n\nwhen calculating discount show all eligible debit-card names as a numbered list from ( the details have been provided below)\n\nInstruct the guest to reply with the number of their chosen card from ( the details have been provided below)\n\nWhen they send party size and card choice (gather both details in a single message) \n\nApply the given discount to the base price (2499) to get the discounted price.\n\nAdd 5% tax on the original base price (not the discounted price)\n\nMultiply the final per-head price (after discount + tax) by the number of people to get the total cost ( respect the discount cap on the cards)\n\nFormula (total_cost = ((2499 (1 - discount_rate)) + (2499 * 0.05)) * num_people) \n\nReturn only the final amount (hide intermediate math).\n\nmake sure your first message is like this:\n\nWelcome to The Carnival All Day Buffet.\n\nType A for Reservation,\n\nType B to get the Menu, Discount Information & Slot Timings,\n\nType C for Calculation of the Discount on the given Bank Cards,\n\nType D to get the google pin/location of the restaurant,\n\nRules\n\nAlways return phone numbers as a 12-digit string beginning with \"92\". If the number starts with \"0\", drop the 0 and prepend \"92\". If it already starts with \"92\", leave it unchanged.\"\nFORMAT_PHONE = phone.replace(/[^0-9]/g,\"\").replace(/^0/,\"92\").replace(/^92/,\"92\") example:\"923480010872\"\n\nCollect the following details from the customer: name, phone number, slot timings, date, number of persons if any one of the variable is missing prompt the customer to provide it for you and log them in \"log reservation\" make sure to log the details first and then send the relevant message.\n\ntell the customer their request have been logged and they will receive their confirmation shortly\n\nAlways set the status to \"Pending\" if the customer has confirmed the reservation \"Pending\" and if the customer has opted to pay in advance, set the status to \"Paid\" no other status is valid and will not go through.\n\nWhen you ask the customer for reservation details (name, phone number, date, number of persons, slot timings), you MUST always display the available slot timings as part of your message. The available slot timings are:\n\"12:00 PM-1:30 PM\n1:45 PM-3:15 PM\n3:30 PM-5:00 PM\n5:15 PM-6:45 PM\n7:00 PM-8:30 PM\n8:45 PM-10:15 PM\n10:30 PM-12:00 PM\"\nNever ask for slot timings without showing the customer this list in your message.\n\nTool\nOnce you have all the details for the reservation log them in \"log reservation\"\nyou also have a \"calculator\" tool to calculate the discounts on the card \n\nEXAMPLES \n\nQ: hey \n\nA: Welcome to The Carnival All Day Buffet.\n\nType A for Reservation,\n\nType B to get the Menu, Discount Information & Slot Timings,\n\nType C for Calculation of the Discount on the given Bank Cards,\n\nType D to get the google pin/location of the restaurant,\n\nQ: A\n\nA: it seems like you like to make a reservation please provide the following details in a single message \n\nname \n\nphone number \n\ndate \n\nnumber of persons\n\nslot timings. please select the number: (1-7)\n\"12:00 PM-1:30 PM\n1:45 PM-3:15 PM\n3:30 PM-5:00 PM\n5:15 PM-6:45 PM\n7:00 PM-8:30 PM\n8:45 PM-10:15 PM\n10:30 PM-12:00 PM\"\n\nQ: \"\"\n\nA:Thank you for the details. \n\nI will log the following reservation request: \n\nName: \"\"\n\nPhone Number: \"\" \n\nSlot Timing: \"\"\n\nDate: \"\" \n\nNumber of Persons: \"\"\n\nPlease confirm if all the details are correct before I proceed to submit your reservation request. \n\nAdditionally, would you like to arrive 15 minutes early before the reservation slot time, or would you prefer to pay in advance to secure your reservation spot?\n\nQ: yes confirm i will arrive early \n\nA: Your reservation has been logged successfully you will recive the confirmation message shortly. If their is anything else i can help you with please feel free to ask \n\n\nNotes\n\nensure that you do not ask too many repetitive questions \n\nthe per-head price for the restaurant is 2499\n\nWhen calculating disounts on the given cards provide the final amount do not show the math\n\nIf a query falls outside reservation management or the customer asks for a human, redirect the customer to a human representative for further support. have them call the same WhatsApp number on the sim.\n\nMaintain a friendly, courteous, and professional tone\n\nhave a spartan tone and aviod any emojis be professional\n\nHere are the debit cards details:\nMeezan Bank\n\n25% Discount on Cards:\n• Visa Infinite Debit Card\n• Mastercard World Debit Card\n\nDiscount Cap: PKR 2,000\n\n20% Discount on Cards:\n• Visa Platinum Aura Card\n• Mastercard Platinum Debit Card\n• Visa Platinum Debit Card\n\nDiscount Cap: PKR 2,000\n\n15% Discount on Cards:\n• Visa Women Debit Card\n• Mastercard Titanium Debit Card\n\nDiscount Cap: PKR 2,000\n\n10% Discount on Cards:\n• Visa Gold Debit Card\n• Mastercard Classic Debit Card\n• Visa Silver Debit Card\n\nDiscount Cap: PKR 2,000\n\nDubai Islamic Bank\n\n50% Discount on Cards:\n• Visa Signature\n\nDiscount Cap: PKR 3,500\n\n30% Discount on Cards:\n• Visa Ayaan\n\nDiscount Cap: PKR 2,000\n\nZindigi (JS Bank)\n\n25% Cash Reward Terms & Conditions:\n• Zindigi customers: 25% cash reward, up to PKR 2,000 per month.\n• Non-Zindigi customers: 25% cash reward, up to PKR 500 (one-time).\n• Applicable on QR/Till ID payments at Zindigi RAAST merchants.\n• Cash reward will be posted on the next working day.\n\nAllied Bank\n\n40% Discount on Cards:\n• Premium Debit\n\nDiscount Cap: PKR 4,000\n\n20% Discount on Cards:\n• Platinum Debit\n• Titanium Debit\n\nDiscount Cap: PKR 2,000\n\nSamba Bank\n\n50% Discount on Cards:\n• Samba Gold Mastercard\n\nDiscount Cap: PKR 2,500\n\nGolootlo\nFlat 10% Off on 1st and 2nd slots only."
},
"promptType": "define"
},
"typeVersion": 2
},
{
"id": "d449cc1c-0a79-4879-9ef4-8650bf49a264",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
608,
160
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "gpt-4o-mini"
},
"options": {
"maxTokens": 2000,
"temperature": 0.5
}
},
"typeVersion": 1.2
},
{
"id": "72fc3993-6e60-4e26-86f5-26a7476f5194",
"name": "记录预订",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
928,
144
],
"parameters": {
"columns": {
"value": {
"Date": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Date', `The date should be in the following format \"2025-06-09\" `, 'string') }}",
"Phone": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Phone', ``, 'string') }}",
"Guests": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Guests', ``, 'string') }}",
"Status": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Status', ``, 'string') }}",
"Timestamp": "={{ $now.format('yyyy-MM-dd-hh-mm')}}",
"Time slot ": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Time_slot_', `Time slot should be in the following format \"3:30 PM – 5:00 PM\"`, 'string') }}",
"CustomerName ": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('CustomerName_', ``, 'string') }}",
"ReservationID": "={{ `RES-${$now.setZone('Asia/Karachi').toFormat('yyLLdd-HHmm')}-${Math.random().toString(36).slice(2,8).toUpperCase()}` }}"
},
"schema": [
{
"id": "ReservationID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ReservationID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CustomerName ",
"type": "string",
"display": true,
"required": false,
"displayName": "CustomerName ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Time slot ",
"type": "string",
"display": true,
"required": false,
"displayName": "Time slot ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Guests",
"type": "string",
"display": true,
"required": false,
"displayName": "Guests",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HandledBY",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "HandledBY",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Slot ID",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Slot ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notified ",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Notified ",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"ReservationID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY/edit#gid=0",
"cachedResultName": "Reservation"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY/edit?usp=drivesdk",
"cachedResultName": "Carnival crm portal"
}
},
"typeVersion": 4.6
},
{
"id": "76ad7647-6d2a-43b9-ab5e-e4acde05798e",
"name": "计算器",
"type": "@n8n/n8n-nodes-langchain.toolCalculator",
"position": [
832,
192
],
"parameters": {},
"typeVersion": 1
},
{
"id": "88d5a878-2804-468e-ab7a-0deb015e1f01",
"name": "过滤器",
"type": "n8n-nodes-base.filter",
"position": [
304,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e231ce1b-505c-4006-acca-03deecad142a",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.messages[0].type }}",
"rightValue": "text"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "6f6bbfef-1ce2-4547-ad15-4b8069b9c73b",
"name": "简单记忆",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
720,
224
],
"parameters": {
"sessionKey": "={{ $('Filter').item.json.messages[0].from }}",
"sessionIdType": "customKey"
},
"typeVersion": 1.3
},
{
"id": "dfa06e51-a5c4-44dc-9587-a7fb2038e5a9",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
-112
],
"parameters": {
"width": 400,
"height": 112,
"content": "通过 Facebook 开发者应用接收消息，您需要创建业务管理器和 Facebook 开发者应用，并将您的 WhatsApp 连接到它，它会为您提供相关凭证"
},
"typeVersion": 1
},
{
"id": "4da74bf1-8a1a-4931-9b04-c4ee506d0d71",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
352,
-96
],
"parameters": {
"width": 352,
"height": 80,
"content": "基于纯文本过滤消息，您可以在此处设置任何类型的过滤器，并将其发送给 AI 助手，助手随后会生成回复"
},
"typeVersion": 1
},
{
"id": "0d4c2514-a7dc-4108-830c-d1f321771c4b",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
-96
],
"parameters": {
"height": 80,
"content": "一旦回复生成，它会将消息路由回发送者"
},
"typeVersion": 1
},
{
"id": "8c179aba-448c-40a9-a910-f71137771fd9",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
336
],
"parameters": {
"width": 480,
"height": 80,
"content": "OpenAI 连接用于大脑的简单记忆存储对话，它有两个工具：一个用于计算折扣的计算器和一个用于存储预订详情的 Google 表格文档"
},
"typeVersion": 1
},
{
"id": "564f489c-51f4-45a6-8cb2-6af525237bc0",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
416,
768
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "Confirmed",
"lookupColumn": "Status"
},
{
"lookupColumn": "Notified "
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY/edit#gid=0",
"cachedResultName": "Reservation"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY/edit?usp=drivesdk",
"cachedResultName": "Carnival crm portal"
},
"combineFilters": "OR"
},
"typeVersion": 4.6
},
{
"id": "f19ea81b-3ee3-4f23-84fb-39e097276c10",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
192,
768
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "76261254-6c6c-4046-abd8-b627ecbc5ff3",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
656,
768
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "be57c9ee-4ec0-473e-8c35-ba8f907e024b",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "Confirmed "
}
]
}
},
"typeVersion": 2.2
},
{
"id": "006f1f50-9485-4db7-9f31-f92a2bc18ddc",
"name": "发送消息1",
"type": "n8n-nodes-base.whatsApp",
"position": [
880,
864
],
"webhookId": "92d67f7b-ce29-4cbc-999d-f15a18e349a9",
"parameters": {
"textBody": "={{ $json['CustomerName '] }}, We regret to inform you your reservation on {{ $json.Date }} at slot {{ $json['Time slot '] }} Is rejected please conider another slot time, Thank you",
"operation": "send",
"phoneNumberId": "668904212970806",
"additionalFields": {},
"recipientPhoneNumber": "={{ $json.Phone.toString() }}"
},
"typeVersion": 1
},
{
"id": "d06c22b2-c5d5-4740-a394-8a78159c525c",
"name": "在表格中更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1104,
672
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $('Get row(s) in sheet').item.json.Date }}",
"Notes": "={{ $('Get row(s) in sheet').item.json.Notes }}",
"Phone": "={{ $('Get row(s) in sheet').item.json.Phone }}",
"Guests": "={{ $('Get row(s) in sheet').item.json.Guests }}",
"Status": "={{ $('Get row(s) in sheet').item.json.Status }}",
"Slot ID": "={{ $('Get row(s) in sheet').item.json['Slot ID'] }}",
"HandledBY": "={{ $('Get row(s) in sheet').item.json.HandledBY }}",
"Notified ": "Yes",
"Timestamp": "={{ $('Get row(s) in sheet').item.json.Timestamp }}",
"Time slot ": "={{ $('Get row(s) in sheet').item.json['Time slot '] }}",
"CustomerName ": "={{ $('Get row(s) in sheet').item.json['CustomerName '] }}",
"ReservationID": "={{ $('Get row(s) in sheet').item.json.ReservationID }}"
},
"schema": [
{
"id": "ReservationID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ReservationID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CustomerName ",
"type": "string",
"display": true,
"required": false,
"displayName": "CustomerName ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Time slot ",
"type": "string",
"display": true,
"required": false,
"displayName": "Time slot ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Guests",
"type": "string",
"display": true,
"required": false,
"displayName": "Guests",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HandledBY",
"type": "string",
"display": true,
"required": false,
"displayName": "HandledBY",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Slot ID",
"type": "string",
"display": true,
"required": false,
"displayName": "Slot ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notified ",
"type": "string",
"display": true,
"required": false,
"displayName": "Notified ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"ReservationID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY/edit#gid=0",
"cachedResultName": "Reservation"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY/edit?usp=drivesdk",
"cachedResultName": "Carnival crm portal"
}
},
"typeVersion": 4.6
},
{
"id": "813c220c-c340-4270-9f7d-7d7883944651",
"name": "在表格中更新行1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1104,
864
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $('Get row(s) in sheet').item.json.Date }}",
"Notes": "={{ $('Get row(s) in sheet').item.json.Notes }}",
"Phone": "={{ $('Get row(s) in sheet').item.json.Phone }}",
"Guests": "={{ $('Get row(s) in sheet').item.json.Guests }}",
"Status": "={{ $('Get row(s) in sheet').item.json.Status }}",
"Slot ID": "={{ $('Get row(s) in sheet').item.json['Slot ID'] }}",
"HandledBY": "={{ $('Get row(s) in sheet').item.json.HandledBY }}",
"Notified ": "Yes",
"Timestamp": "={{ $('Get row(s) in sheet').item.json.Timestamp }}",
"Time slot ": "={{ $('Get row(s) in sheet').item.json['Time slot '] }}",
"CustomerName ": "={{ $('Get row(s) in sheet').item.json['CustomerName '] }}",
"ReservationID": "={{ $('Get row(s) in sheet').item.json.ReservationID }}"
},
"schema": [
{
"id": "ReservationID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ReservationID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CustomerName ",
"type": "string",
"display": true,
"required": false,
"displayName": "CustomerName ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Time slot ",
"type": "string",
"display": true,
"required": false,
"displayName": "Time slot ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Guests",
"type": "string",
"display": true,
"required": false,
"displayName": "Guests",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HandledBY",
"type": "string",
"display": true,
"required": false,
"displayName": "HandledBY",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Slot ID",
"type": "string",
"display": true,
"required": false,
"displayName": "Slot ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notified ",
"type": "string",
"display": true,
"required": false,
"displayName": "Notified ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"ReservationID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY/edit#gid=0",
"cachedResultName": "Reservation"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1oG6mCFReg7CRgwjcnnSTSfy7u1TblEXVLuj3B_ElfiY/edit?usp=drivesdk",
"cachedResultName": "Carnival crm portal"
}
},
"typeVersion": 4.6
},
{
"id": "006c7ae0-9458-46f5-a256-d714027265bc",
"name": "发送消息2",
"type": "n8n-nodes-base.whatsApp",
"position": [
880,
672
],
"webhookId": "9ec00d01-9bb2-475a-ab90-33d540f7f41a",
"parameters": {
"textBody": "={{ $json['CustomerName '] }},Your reservation at {{ $json.Date }} is confirmed. Looking forward to meet you at your desired slot time {{ $json['Time slot '] }}",
"operation": "send",
"phoneNumberId": "668904212970806",
"additionalFields": {},
"recipientPhoneNumber": "={{ $json.Phone.toString() }}"
},
"typeVersion": 1
},
{
"id": "b4f809cd-c1d7-4aeb-99ca-7fe3e19158dc",
"name": "过滤器1",
"type": "n8n-nodes-base.filter",
"position": [
656,
928
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bc063fbf-34db-46b0-976b-99be846fe228",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "Rejected"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "ad3c315a-e734-412d-b3e0-319ef98a8c69",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
464,
-288
],
"parameters": {
"width": 352,
"height": 80,
"content": "# AI 助手工作流"
},
"typeVersion": 1
},
{
"id": "ce7db6fb-0a3a-4892-ae4a-2b1571c5ce2e",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
592
],
"parameters": {
"width": 624,
"height": 80,
"content": "# 预订确认工作流"
},
"typeVersion": 1
},
{
"id": "44e79618-822c-4318-8199-f445c2defb8f",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
1072
],
"parameters": {
"width": 832,
"height": 128,
"content": "此工作流有一个计划触发器；它在您选择的特定时间运行，从表格中获取数据并根据内置逻辑决定，如果状态为\"确认未发送\"，它会提取所有预订，并根据其状态向用户发送消息，if 模块决定预订是确认还是拒绝，并将其发送到相关字段"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[
{
"node": "Send message2",
"type": "main",
"index": 0
}
],
[
{
"node": "Filter1",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Filter1": {
"main": [
[
{
"node": "Send message1",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Send message",
"type": "main",
"index": 0
}
]
]
},
"Calculator": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Send message1": {
"main": [
[
{
"node": "Update row in sheet1",
"type": "main",
"index": 0
}
]
]
},
"Send message2": {
"main": [
[
{
"node": "Update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Simple Memory": {
"ai_memory": [
[
{
"node": "AI Agent",
"type": "ai_memory",
"index": 0
}
]
]
},
"log reservation": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"WhatsApp Trigger": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 客服机器人, AI 聊天机器人
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用GPT-4 nano、Telegram和Google Sheets的订阅跟踪与提醒
使用GPT-4 nano、Telegram和Google Sheets的订阅跟踪与提醒
If
Set
Telegram
+13
20 节点Ramon David
AI 聊天机器人
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
高级多代理AI个人助手（250+任务能力，WhatsApp + GPT）
高级多代理AI个人助手（250+任务能力，WhatsApp + GPT）
Set
Switch
Whats App
+26
213 节点Electrabot
个人效率
AI医疗助手 - 多智能体演示系统
集成WhatsApp、GPT-4和Google Sheets的多智能体医疗助手
If
Set
Code
+13
52 节点Fakhar Khan
AI 聊天机器人
AIAutomationPro终极RAG聊天机器人v1 n8n市场模板
多语言Telegram RAG聊天机器人，集成监督AI和自动化Google Drive流程
If
Set
Wait
+29
128 节点Daniel Ng
客服机器人
多服务任务自动化：基于GPT的代理系统通过WhatsApp
通过WhatsApp的基于GPT代理系统的多服务任务自动化
Set
Switch
Whats App
+25
214 节点Gain FLow AI
个人效率
