January 22, 2026

WhatsApp + Google Sheets: bookings confirmed fast

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your phone keeps buzzing with “Can we book for 7?” and “Any tables tonight?”, and somehow every message becomes a mini project. You copy details into a sheet, check availability, reply, then realize you forgot to log one request and now two parties think they have the same table.

This is where WhatsApp booking automation earns its keep. It hits restaurant managers hardest, but front-of-house leads and small hospitality business owners feel it too. The outcome is simple: faster confirmations, fewer mistakes, and every request logged without you babysitting the process.

This workflow turns incoming WhatsApp messages into structured reservations in Google Sheets, checks availability, and sends a natural confirmation (or rejection) back. You’ll see how it works, what you need, and what to watch for before you put it in front of real guests.

How This Automation Works

See how this solves the problem:

n8n Workflow Template: WhatsApp + Google Sheets: bookings confirmed fast

Click to explore

flowchart LR

    subgraph sg0["WhatsApp Flow"]
        direction LR
        n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/whatsapp.svg' width='40' height='40' /></div><br/>Send message"]
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/whatsapp.svg' width='40' height='40' /></div><br/>WhatsApp Trigger"]
        n2@{ icon: "mdi:robot", form: "rounded", label: "AI Agent", pos: "b", h: 48 }
        n3@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n4@{ icon: "mdi:database", form: "rounded", label: "log reservation", pos: "b", h: 48 }
        n5@{ icon: "mdi:wrench", form: "rounded", label: "Calculator", pos: "b", h: 48 }
        n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter", pos: "b", h: 48 }
        n7@{ icon: "mdi:memory", form: "rounded", label: "Simple Memory", pos: "b", h: 48 }
        n6 --> n2
        n2 --> n0
        n5 -.-> n2
        n7 -.-> n2
        n4 -.-> n2
        n1 --> n6
        n3 -.-> n2
    end

    subgraph sg1["Schedule Flow"]
        direction LR
        n8@{ icon: "mdi:database", form: "rounded", label: "Get row(s) in sheet", pos: "b", h: 48 }
        n9@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", pos: "b", h: 48 }
        n10@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If", pos: "b", h: 48 }
        n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/whatsapp.svg' width='40' height='40' /></div><br/>Send message1"]
        n12@{ icon: "mdi:database", form: "rounded", label: "Update row in sheet", pos: "b", h: 48 }
        n13@{ icon: "mdi:database", form: "rounded", label: "Update row in sheet1", pos: "b", h: 48 }
        n14["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/whatsapp.svg' width='40' height='40' /></div><br/>Send message2"]
        n15@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter1", pos: "b", h: 48 }
        n10 --> n14
        n10 --> n15
        n15 --> n11
        n11 --> n13
        n14 --> n12
        n9 --> n8
        n8 --> n10
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n1,n9 trigger
    class n2 ai
    class n3 aiModel
    class n5 ai
    class n7 ai
    class n6,n10,n15 decision
    class n4,n8,n12,n13 database
    classDef customIcon fill:none,stroke:none
    class n0,n1,n11,n14 customIcon

The Challenge: Confirming bookings fast without double-booking

WhatsApp is great for guests because it’s quick and informal. For you, it’s chaos disguised as convenience. People send half the details (“table for four tomorrow”), change their mind mid-thread, or message from different numbers, and suddenly you’re scrolling through chat history trying to remember what was actually confirmed. Add peak hours and shift handoffs, and it gets messy fast. The real cost isn’t just time. It’s the mental load, the awkward apology when you overbook, and the lost revenue when a slow reply sends them to the restaurant down the street.

None of these alone is the problem. Together, they are.

You end up retyping the same booking details into Google Sheets, which is boring and easy to mess up.
Availability checks happen “in your head,” so mistakes show up later when it’s too late to fix them politely.
Reply speed depends on who is on shift, so the guest experience feels inconsistent day to day.
When you don’t log every request, you can’t track demand patterns or spot which time slots sell out first.

The Fix: WhatsApp messages become confirmed reservations in Google Sheets

This workflow starts the moment a guest messages your WhatsApp Business number. Instead of someone reading, interpreting, and manually formatting the request, an AI agent extracts the important parts (name, date, time, party size, and intent). The workflow then checks your reservation datastore (Google Sheets in this version) to see if the slot is open. If it’s available, it sends a friendly confirmation back on WhatsApp and logs the booking. If it’s not, it sends a rejection message and marks that outcome too, so your team has a clear record of what happened. There’s also a scheduled check in the workflow for status handling, which is useful for follow-ups and reminders when you decide to enable them.

The workflow starts with an inbound WhatsApp webhook, then filters message types so you’re not reacting to noise. AI parses and drafts the reply, Google Sheets stores and retrieves availability, and WhatsApp delivers the confirmation or rejection back to the guest in natural language.

What Changes: Before vs. After

What This Eliminates

Impact You’ll See

Copying guest messages into a sheet line by line.
Manually interpreting vague requests and chasing missing details.
Checking availability by scrolling through rows while the guest waits.
Forgetting to mark a booking as confirmed or rejected.

Most teams get replies out in about a minute instead of “when someone sees it.”
Your reservation log stays complete, so shift handoffs stop being a guessing game.
Double-bookings drop sharply because the same availability check runs every time.
Guests get clearer confirmations, which usually means fewer follow-up questions.
You can actually use the data later (busy times, party sizes, frequent requests).

Real-World Impact

Say you handle about 30 WhatsApp booking requests in a busy day. Manually, you might spend roughly 5 minutes per request reading the message, checking the sheet, typing a reply, and logging the details, which is about 2.5 hours total. With this workflow, you still spend a moment glancing at edge cases, but most requests run end-to-end automatically. Even if you only review 10 of them for safety, you’re getting close to 2 hours back on a busy day.

Requirements

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
WhatsApp Business Cloud API to receive and send WhatsApp messages.
Google Sheets for your reservation log and availability table.
OpenAI API key (get it from the OpenAI dashboard) to parse and draft responses.

Skill level: Intermediate. You’ll connect accounts, paste API credentials, and test with a few real messages to tune the prompts.

Need help implementing this? Talk to an automation expert (free 15-minute consultation).

The Workflow Flow

A guest messages your WhatsApp number. The workflow begins with an inbound WhatsApp trigger and immediately filters message types so only real booking requests move forward.

The message gets understood and cleaned up. An AI agent reads the free-form text, pulls out name/date/time/party size, and keeps context using a short memory buffer so the conversation can feel human instead of robotic.

Availability and logic happen in the background. The workflow fetches rows from Google Sheets, checks whether the requested slot is open, and can apply simple calculations like group discounts when you want that behavior.

The guest gets a clear answer. It sends a confirmation or rejection via WhatsApp, then updates Google Sheets to mark the request as notified, which keeps your log accurate for the next shift.

You can easily modify the data store (Google Sheets) to Airtable, MySQL, or Postgres, and you can also adjust the AI’s tone to match your brand. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the WhatsApp Trigger

Set up the inbound message trigger so the workflow can capture WhatsApp messages and route only text messages into the AI assistant.

Add the Inbound WhatsApp Hook node as your trigger and keep Updates set to messages.
Open Message Type Filter and confirm the condition uses Left Value {{ $json.messages[0].type }} with Operation contains and Right Value text.
Connect Inbound WhatsApp Hook → Message Type Filter to ensure only text messages are processed by the AI flow.

Credential Required: Connect your WhatsApp credentials for Inbound WhatsApp Hook.

⚠️ Common Pitfall: If the WhatsApp app is not connected or verified, the trigger will not receive incoming messages.

Step 2: Connect Google Sheets

Configure Google Sheets nodes to log reservations and read reservation status updates.

Open Append Reservation Log and set Operation to append.
Set Document to [YOUR_ID] and Sheet to gid=0 (Reservation).
Verify column mappings, including Date {{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Date', `The date should be in the following format "2025-06-09" `, 'string') }} and Timestamp {{ $now.format('yyyy-MM-dd-hh-mm') }}.
Open Fetch Sheet Rows and keep Combine Filters set to OR, with filters for Status Confirmed and the Notified column.
In Mark Notified Confirmed and Mark Notified Rejected, keep Operation set to update and set Notified to Yes.

Credential Required: Connect your Google Sheets credentials for Fetch Sheet Rows, Mark Notified Confirmed, Mark Notified Rejected, and Append Reservation Log. Since Append Reservation Log is an AI tool, ensure credentials are added to the parent Reservation Assistant AI configuration.

Step 3: Set Up Reservation Assistant AI

Configure the AI agent, language model, memory, and tools so it can collect reservation details and calculate discounts.

In Reservation Assistant AI, set Text to {{ $json.messages[0].text.body }} and keep Prompt Type as define.
Open OpenAI Chat Engine and set Model to gpt-4o-mini, Max Tokens to 2000, and Temperature to 0.5.
Ensure Conversation Memory Buffer uses Session Key {{ $('Message Type Filter').item.json.messages[0].from }} with Session ID Type customKey.
Confirm Discount Calculator Tool and Append Reservation Log are connected as AI tools to Reservation Assistant AI.

Credential Required: Connect your OpenAI credentials in OpenAI Chat Engine, which serves as the language model for Reservation Assistant AI.

Credential Required: For AI tools like Conversation Memory Buffer, Append Reservation Log, and Discount Calculator Tool, add credentials via the parent Reservation Assistant AI setup (not on the tool nodes themselves).

Step 4: Configure Reservation Status Routing and WhatsApp Replies

Set up the messaging flows for confirmations, rejections, and AI-generated replies.

Open Reservation Status Check and confirm the condition uses Left Value {{ $json.Status }} with Operation contains and Right Value Confirmed .
Configure Rejection Filter to check Left Value {{ $json.Status }} contains Rejected.
In Send Confirmation Notice, set Text Body to {{ $json['CustomerName '] }},Your reservation at {{ $json.Date }} is confirmed. Looking forward to meet you at your desired slot time {{ $json['Time slot '] }} and Recipient Phone Number to {{ $json.Phone.toString() }}.
In Send Rejection Notice, set Text Body to {{ $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 and Recipient Phone Number to {{ $json.Phone.toString() }}.
In Dispatch WhatsApp Reply, set Text Body to {{ $json.output }} and Recipient Phone Number to {{ $('Inbound WhatsApp Hook').item.json.messages[0].from }}.

Credential Required: Connect your WhatsApp credentials for Dispatch WhatsApp Reply, Send Confirmation Notice, and Send Rejection Notice.

Double-check that phoneNumberId is set to [YOUR_ID] in all WhatsApp send nodes to prevent delivery failures.

Step 5: Configure the Scheduled Status Check

Enable the scheduled job that polls Google Sheets for confirmed or rejected reservations and sends the appropriate WhatsApp notice.

Open Timed Workflow Trigger and set a schedule interval that matches how often you want to notify customers.
Ensure the execution path is Timed Workflow Trigger → Fetch Sheet Rows → Reservation Status Check → Send Confirmation Notice/Rejection Filter.
Confirm that Send Confirmation Notice flows to Mark Notified Confirmed, and Send Rejection Notice flows to Mark Notified Rejected.

Step 6: Test and Activate Your Workflow

Validate both the inbound WhatsApp flow and the scheduled status check before going live.

Click Execute Workflow and send a WhatsApp text message to trigger Inbound WhatsApp Hook. Confirm that Reservation Assistant AI produces a response and Dispatch WhatsApp Reply sends it.
Manually run Timed Workflow Trigger to validate that Fetch Sheet Rows returns rows and Reservation Status Check routes to the correct notice.
Check Google Sheets to confirm that Mark Notified Confirmed or Mark Notified Rejected updates the Notified column to Yes.
When everything works, toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Watch Out For

WhatsApp Business Cloud API credentials can expire or be missing the right permissions. If things break, check your Meta app settings and token validity first.
If you’re using Wait nodes or external scheduling (like reminders), processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in the OpenAI Chat Model are generic. Add your brand voice and booking rules early or you’ll be editing outputs forever.

Common Questions

How quickly can I implement this WhatsApp booking automation?

About 30 minutes if your WhatsApp and Google Sheets access is ready.

Can non-technical teams implement this booking automation?

Yes. No coding is required, but you do need to connect WhatsApp, Google Sheets, and your OpenAI key and then test with a few real booking messages.

Is n8n free to use for this WhatsApp booking automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API usage, which is usually small for short messages.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

How do I adapt this WhatsApp booking automation solution to my specific challenges?

You can swap the storage layer by replacing the Google Sheets “Fetch Sheet Rows” and “Append Reservation Log” parts with Airtable, MySQL, or Postgres. Most teams also tweak the Reservation Assistant AI prompt to match house rules like seating limits, deposit wording, or how you handle late arrivals. If you want reminders, enable the scheduled trigger path and adjust the message timing to “24 hours before” or whatever fits your service style.

Why is my WhatsApp connection failing in this workflow?

Usually it’s an expired Meta/WhatsApp token or the wrong permissions on the WhatsApp Business app. Refresh the credentials in n8n, then send a test message from a real phone number (not a simulator) to confirm the webhook is receiving events. If the trigger fires but replies fail, check the HTTP/WhatsApp send step for template restrictions or missing phone number IDs.

What’s the capacity of this WhatsApp booking automation solution?

On self-hosted n8n, capacity is mostly your server and WhatsApp API limits.

Is this WhatsApp booking automation better than using Zapier or Make?

Often, yes, especially when you want branching logic like “confirm vs reject,” memory across a conversation, and custom checks against your availability table. n8n also gives you the option to self-host, which is handy when message volume spikes and you don’t want per-task pricing surprises. Another practical win is control: you can inspect and modify each step of the flow, including how the AI interprets messy messages. Zapier or Make can still be fine for very simple “message in, row added” setups. Talk to an automation expert if you’re not sure which fits.

Once this is running, confirmations stop being a scramble and start being a system. The workflow handles the repetitive parts, and your team stays focused on service.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"name": "Automated Reservation Messaging Workflow",
"meta": {
"instanceId": "d95d3e4ca51e07b88e591d1f1c54589d8f9b263b69561cdf2522cd392c7b6761"
},
"nodes": [
{
"id": "flowpast-topbar-6379",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
85
],
"parameters": {
"color": 7,
"width": 1120,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "5fc9e0fb-70c7-4a69-b24b-7c791f4b3bf1",
"name": "Dispatch WhatsApp Reply",
"type": "n8n-nodes-base.whatsApp",
"onError": "continueRegularOutput",
"position": [
310,
200
],
"webhookId": "750581ca-8153-4d15-85bb-72af25176a37",
"parameters": {
"textBody": "={{ $json.output }}",
"operation": "send",
"phoneNumberId": "[YOUR_ID]",
"additionalFields": [],
"recipientPhoneNumber": "={{ $('Inbound WhatsApp Hook').item.json.messages[0].from }}"
},
"typeVersion": 1
},
{
"id": "250d747c-a938-47c6-92a7-5bba1b430ca7",
"name": "Inbound WhatsApp Hook",
"type": "n8n-nodes-base.whatsAppTrigger",
"position": [
1020,
190
],
"webhookId": "7de2c19b-818e-4e24-a2cb-f107a1be6fc6",
"parameters": {
"options": [],
"updates": [
"messages"
]
},
"typeVersion": 1
},
{
"id": "a2b3e9f9-cde6-41d9-87c9-e6f571df2a67",
"name": "Reservation Assistant AI",
"type": "@n8n/n8n-nodes-langchain.agent",
"onError": "continueRegularOutput",
"position": [
560,
185
],
"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\n[YOUR_URL]\n\nIf they press D for the location of the restaurant, provide them with this link: [YOUR_URL]\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\u2022 Visa Infinite Debit Card\n\u2022 Mastercard World Debit Card\n\nDiscount Cap: PKR 2,000\n\n20% Discount on Cards:\n\u2022 Visa Platinum Aura Card\n\u2022 Mastercard Platinum Debit Card\n\u2022 Visa Platinum Debit Card\n\nDiscount Cap: PKR 2,000\n\n15% Discount on Cards:\n\u2022 Visa Women Debit Card\n\u2022 Mastercard Titanium Debit Card\n\nDiscount Cap: PKR 2,000\n\n10% Discount on Cards:\n\u2022 Visa Gold Debit Card\n\u2022 Mastercard Classic Debit Card\n\u2022 Visa Silver Debit Card\n\nDiscount Cap: PKR 2,000\n\nDubai Islamic Bank\n\n50% Discount on Cards:\n\u2022 Visa Signature\n\nDiscount Cap: PKR 3,500\n\n30% Discount on Cards:\n\u2022 Visa Ayaan\n\nDiscount Cap: PKR 2,000\n\nZindigi (JS Bank)\n\n25% Cash Reward Terms & Conditions:\n\u2022 Zindigi customers: 25% cash reward, up to PKR 2,000 per month.\n\u2022 Non-Zindigi customers: 25% cash reward, up to PKR 500 (one-time).\n\u2022 Applicable on QR/Till ID payments at Zindigi RAAST merchants.\n\u2022 Cash reward will be posted on the next working day.\n\nAllied Bank\n\n40% Discount on Cards:\n\u2022 Premium Debit\n\nDiscount Cap: PKR 4,000\n\n20% Discount on Cards:\n\u2022 Platinum Debit\n\u2022 Titanium Debit\n\nDiscount Cap: PKR 2,000\n\nSamba Bank\n\n50% Discount on Cards:\n\u2022 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 Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
570,
360
],
"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": "Append Reservation Log",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
820,
360
],
"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 \u2013 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": "",
"cachedResultName": "Reservation"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Carnival crm portal"
}
},
"typeVersion": 4.6
},
{
"id": "76ad7647-6d2a-43b9-ab5e-e4acde05798e",
"name": "Discount Calculator Tool",
"type": "@n8n/n8n-nodes-langchain.toolCalculator",
"position": [
700,
400
],
"parameters": [],
"typeVersion": 1
},
{
"id": "88d5a878-2804-468e-ab7a-0deb015e1f01",
"name": "Message Type Filter",
"type": "n8n-nodes-base.filter",
"position": [
790,
210
],
"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": "Conversation Memory Buffer",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
420,
390
],
"parameters": {
"sessionKey": "={{ $('Message Type Filter').item.json.messages[0].from }}",
"sessionIdType": "customKey"
},
"typeVersion": 1.3
},
{
"id": "564f489c-51f4-45a6-8cb2-6af525237bc0",
"name": "Fetch Sheet Rows",
"type": "n8n-nodes-base.googleSheets",
"position": [
790,
545
],
"parameters": {
"options": [],
"filtersUI": {
"values": [
{
"lookupValue": "Confirmed",
"lookupColumn": "Status"
},
{
"lookupColumn": "Notified "
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Reservation"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Carnival crm portal"
},
"combineFilters": "OR"
},
"typeVersion": 4.6
},
{
"id": "f19ea81b-3ee3-4f23-84fb-39e097276c10",
"name": "Timed Workflow Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
1020,
540
],
"parameters": {
"rule": {
"interval": [
[]
]
}
},
"typeVersion": 1.2
},
{
"id": "76261254-6c6c-4046-abd8-b627ecbc5ff3",
"name": "Reservation Status Check",
"type": "n8n-nodes-base.if",
"position": [
560,
560
],
"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": "Send Rejection Notice",
"type": "n8n-nodes-base.whatsApp",
"position": [
120,
690
],
"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": "[YOUR_ID]",
"additionalFields": [],
"recipientPhoneNumber": "={{ $json.Phone.toString() }}"
},
"typeVersion": 1
},
{
"id": "d06c22b2-c5d5-4740-a394-8a78159c525c",
"name": "Mark Notified Confirmed",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
500
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $('Fetch Sheet Rows').item.json.Date }}",
"Notes": "={{ $('Fetch Sheet Rows').item.json.Notes }}",
"Phone": "={{ $('Fetch Sheet Rows').item.json.Phone }}",
"Guests": "={{ $('Fetch Sheet Rows').item.json.Guests }}",
"Status": "={{ $('Fetch Sheet Rows').item.json.Status }}",
"Slot ID": "={{ $('Fetch Sheet Rows').item.json['Slot ID'] }}",
"HandledBY": "={{ $('Fetch Sheet Rows').item.json.HandledBY }}",
"Notified ": "Yes",
"Timestamp": "={{ $('Fetch Sheet Rows').item.json.Timestamp }}",
"Time slot ": "={{ $('Fetch Sheet Rows').item.json['Time slot '] }}",
"CustomerName ": "={{ $('Fetch Sheet Rows').item.json['CustomerName '] }}",
"ReservationID": "={{ $('Fetch Sheet Rows').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": "",
"cachedResultName": "Reservation"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Carnival crm portal"
}
},
"typeVersion": 4.6
},
{
"id": "813c220c-c340-4270-9f7d-7d7883944651",
"name": "Mark Notified Rejected",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
720
],
"parameters": {
"columns": {
"value": {
"Date": "={{ $('Fetch Sheet Rows').item.json.Date }}",
"Notes": "={{ $('Fetch Sheet Rows').item.json.Notes }}",
"Phone": "={{ $('Fetch Sheet Rows').item.json.Phone }}",
"Guests": "={{ $('Fetch Sheet Rows').item.json.Guests }}",
"Status": "={{ $('Fetch Sheet Rows').item.json.Status }}",
"Slot ID": "={{ $('Fetch Sheet Rows').item.json['Slot ID'] }}",
"HandledBY": "={{ $('Fetch Sheet Rows').item.json.HandledBY }}",
"Notified ": "Yes",
"Timestamp": "={{ $('Fetch Sheet Rows').item.json.Timestamp }}",
"Time slot ": "={{ $('Fetch Sheet Rows').item.json['Time slot '] }}",
"CustomerName ": "={{ $('Fetch Sheet Rows').item.json['CustomerName '] }}",
"ReservationID": "={{ $('Fetch Sheet Rows').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": "",
"cachedResultName": "Reservation"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Carnival crm portal"
}
},
"typeVersion": 4.6
},
{
"id": "006c7ae0-9458-46f5-a256-d714027265bc",
"name": "Send Confirmation Notice",
"type": "n8n-nodes-base.whatsApp",
"position": [
320,
520
],
"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": "[YOUR_ID]",
"additionalFields": [],
"recipientPhoneNumber": "={{ $json.Phone.toString() }}"
},
"typeVersion": 1
},
{
"id": "b4f809cd-c1d7-4aeb-99ca-7fe3e19158dc",
"name": "Rejection Filter",
"type": "n8n-nodes-base.filter",
"position": [
320,
660
],
"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
}
],
"pinData": [],
"connections": {
"Reservation Status Check": {
"main": [
[
{
"node": "Send Confirmation Notice",
"type": "main",
"index": 0
}
],
[
{
"node": "Rejection Filter",
"type": "main",
"index": 0
}
]
]
},
"Message Type Filter": {
"main": [
[
{
"node": "Reservation Assistant AI",
"type": "main",
"index": 0
}
]
]
},
"Rejection Filter": {
"main": [
[
{
"node": "Send Rejection Notice",
"type": "main",
"index": 0
}
]
]
},
"Reservation Assistant AI": {
"main": [
[
{
"node": "Dispatch WhatsApp Reply",
"type": "main",
"index": 0
}
]
]
},
"Discount Calculator Tool": {
"ai_tool": [
[
{
"node": "Reservation Assistant AI",
"type": "ai_tool",
"index": 0
}
]
]
},
"Send Rejection Notice": {
"main": [
[
{
"node": "Mark Notified Rejected",
"type": "main",
"index": 0
}
]
]
},
"Send Confirmation Notice": {
"main": [
[
{
"node": "Mark Notified Confirmed",
"type": "main",
"index": 0
}
]
]
},
"Conversation Memory Buffer": {
"ai_memory": [
[
{
"node": "Reservation Assistant AI",
"type": "ai_memory",
"index": 0
}
]
]
},
"Append Reservation Log": {
"ai_tool": [
[
{
"node": "Reservation Assistant AI",
"type": "ai_tool",
"index": 0
}
]
]
},
"Timed Workflow Trigger": {
"main": [
[
{
"node": "Fetch Sheet Rows",
"type": "main",
"index": 0
}
]
]
},
"Inbound WhatsApp Hook": {
"main": [
[
{
"node": "Message Type Filter",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Engine": {
"ai_languageModel": [
[
{
"node": "Reservation Assistant AI",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Fetch Sheet Rows": {
"main": [
[
{
"node": "Reservation Status Check",
"type": "main",
"index": 0
}
]
]
}
},
"versionId": null
}