{
  "name": "Manage WhatsApp vehicle service reminders and bookings with WATI and Google Sheets",
  "nodes": [
    {
      "id": "6c067f10-854c-46ac-897c-4534d8cbeaae",
      "name": "📋 Flow Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1728,
        5696
      ],
      "parameters": {
        "width": 660,
        "height": 720,
        "content": "## 🚗 WhatsApp Vehicle Service Reminder – Booking & History Tracking\n\n**How it works:**\n1. A scheduled trigger runs every morning and checks all vehicles in Google Sheets for upcoming or overdue servic"
      }
    },
    {
      "id": "098a806a-3eda-4fc6-851b-f4e22fa976ab",
      "name": "Sticky – Scheduled Reminder",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -352,
        6240
      ],
      "parameters": {
        "width": 1440,
        "height": 336,
        "content": "### 1️⃣ Scheduled Service Reminder\n**Schedule Trigger – 9AM Daily** fires every morning.\n**Sheets – Read All Vehicles** fetches every row from the Vehicles tab.\n**Check Service Due Code** applies two "
      }
    },
    {
      "id": "9e5ebd30-03bf-4aa3-841e-319d3245b5ab",
      "name": "Sticky – Appointment Reminder",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1248,
        6384
      ],
      "parameters": {
        "width": 1200,
        "height": 288,
        "content": "### 2️⃣ Day-Before Appointment Reminder\n**Schedule Trigger – 8AM Daily** fires separately every morning.\n**Sheets – Read Appointments** fetches all rows from the Appointments tab.\n**Check Tomorrow App"
      }
    },
    {
      "id": "b70b22d5-8872-4138-b0c1-2582a07181c7",
      "name": "Sticky – Inbound Routing",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        6640
      ],
      "parameters": {
        "width": 672,
        "height": 608,
        "content": "### 3️⃣ Inbound Reply Routing\n**Wati Trigger** receives all inbound WhatsApp messages from vehicle owners and garage staff.\n**Command Router Switch** detects the reply keyword and routes to the correc"
      }
    },
    {
      "id": "05706c60-7970-42c2-8b23-ece352f94839",
      "name": "Sticky – Book & Confirm",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        6640
      ],
      "parameters": {
        "width": 1520,
        "height": 608,
        "content": "### 4️⃣ Book Appointment & Confirm Slot\n**Sheets – Find Vehicle for Booking** reads Vehicles tab to get owner's vehicle details.\n**Parse Book & Generate Slots Code** finds the owner's vehicle by phone"
      }
    },
    {
      "id": "d89ab938-2d4f-45a1-bbbe-50359094498a",
      "name": "Sticky – Mileage Update",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1248,
        6800
      ],
      "parameters": {
        "width": 1200,
        "height": 336,
        "content": "### 5️⃣ Mileage Update\nOwner sends: *mileage 51650*\n**Sheets – Find Vehicle for Mileage** reads the owner's current vehicle record.\n**Parse Mileage Update Code** extracts the new km value, recalculate"
      }
    },
    {
      "id": "6fa7e405-9591-4182-acf0-854a75463146",
      "name": "Sticky – History, Status & Log",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        7280
      ],
      "parameters": {
        "width": 3136,
        "height": 400,
        "content": "### 6️⃣ History · Status · Log Service\n**History path** — *Sheets – Read Service History* fetches the ServiceHistory tab. **Build History View Code** filters by phone, sorts newest-first, formats last"
      }
    },
    {
      "id": "ab162e9b-6076-4f71-a377-1ccd4f0190db",
      "name": "Schedule Trigger – 8AM Daily",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1328,
        6544
      ]
    },
    {
      "id": "b36cb999-aa78-4eaf-b0d9-e583f15c40ee",
      "name": "Schedule Trigger – 9AM Daily1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -272,
        6400
      ]
    },
    {
      "id": "f3e0ef52-c8d8-46a5-a0a6-f580f5b21bb4",
      "name": "Sheets – Read All Vehicles1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -32,
        6400
      ]
    },
    {
      "id": "72f5f0fe-639f-456d-8faa-6662aa89efa7",
      "name": "Check Service Due1",
      "type": "n8n-nodes-base.code",
      "position": [
        208,
        6400
      ]
    },
    {
      "id": "34bca1ba-c9a7-4885-a88c-7105d48d1c09",
      "name": "Sheets – Mark Reminder Sent1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        448,
        6400
      ]
    },
    {
      "id": "a2cdb6c2-9e73-4b60-96db-c4562ab5a95f",
      "name": "WATI – Send Service Reminder1",
      "type": "n8n-nodes-wati.wati",
      "position": [
        688,
        6400
      ]
    },
    {
      "id": "614f5338-f786-48ba-9e6c-51cbd2e67648",
      "name": "Sheets – Read Appointments1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1568,
        6544
      ]
    },
    {
      "id": "ec881846-3be6-440e-add5-a1473362c946",
      "name": "Check Tomorrow Appointments1",
      "type": "n8n-nodes-base.code",
      "position": [
        1808,
        6544
      ]
    },
    {
      "id": "5e448930-4b70-428e-9b98-572609aaa5b8",
      "name": "WATI – Send Appointment Reminder1",
      "type": "n8n-nodes-wati.wati",
      "position": [
        2048,
        6544
      ]
    },
    {
      "id": "8127d61b-a6dc-457b-b280-17a9dfabcf10",
      "name": "Command Router1",
      "type": "n8n-nodes-base.switch",
      "position": [
        -768,
        6960
      ]
    },
    {
      "id": "428decda-0588-46e9-9970-057826740182",
      "name": "Sheets – Find Vehicle for Booking1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -304,
        6880
      ]
    },
    {
      "id": "e26ecfe3-40b1-428e-b861-32bd3d1bd180",
      "name": "Parse Book & Generate Slots1",
      "type": "n8n-nodes-base.code",
      "position": [
        -112,
        6880
      ]
    },
    {
      "id": "fc383e54-cff8-4905-8371-1dab9508b18f",
      "name": "WATI – Send Available Slots1",
      "type": "n8n-nodes-wati.wati",
      "position": [
        112,
        6880
      ]
    },
    {
      "id": "ae9f7c7b-0f8b-4f58-b4b0-f4e6dca6b701",
      "name": "Sheets – Find Vehicle for Confirm1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -320,
        7072
      ]
    },
    {
      "id": "41ca15c3-f6f8-437f-90a0-55a7416fd471",
      "name": "Handle Slot Confirmation1",
      "type": "n8n-nodes-base.code",
      "position": [
        -128,
        7072
      ]
    },
    {
      "id": "f026b12e-50f9-40c1-947e-7fef003a86ef",
      "name": "Sheets – Log Appointment1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        112,
        7072
      ]
    },
    {
      "id": "dc0da2c5-52b5-481f-bd33-2925ed777e0e",
      "name": "WATI – Confirm Appointment1",
      "type": "n8n-nodes-wati.wati",
      "position": [
        352,
        7072
      ]
    },
    {
      "id": "2fbbebec-6194-457c-beaa-2aa7168bb226",
      "name": "Sheets – Find Vehicle for Mileage1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1248,
        6960
      ]
    },
    {
      "id": "1251302e-c942-4ca4-bc8c-3ed8c7e01e3b",
      "name": "Parse Mileage Update1",
      "type": "n8n-nodes-base.code",
      "position": [
        1488,
        6960
      ]
    },
    {
      "id": "c143ac45-2b4d-446c-aef7-b3cbc2fe9a72",
      "name": "Sheets – Update Mileage1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1728,
        6960
      ]
    },
    {
      "id": "4584eeb8-67fb-4381-a479-9e78ee415a0a",
      "name": "WATI – Send Mileage Ack1",
      "type": "n8n-nodes-wati.wati",
      "position": [
        1968,
        6960
      ]
    },
    {
      "id": "aadfe8c1-4654-499c-9f5e-b3803bb85c30",
      "name": "Sheets – Read Service History1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -368,
        7440
      ]
    },
    {
      "id": "b7ef0826-3c2d-4ea7-926f-220e52d138e9",
      "name": "Build History View1",
      "type": "n8n-nodes-base.code",
      "position": [
        -128,
        7440
      ]
    },
    {
      "id": "06766d32-7353-4d05-910e-af4f0abd4270",
      "name": "WATI – Send History1",
      "type": "n8n-nodes-wati.wati",
      "position": [
        112,
        7440
      ]
    },
    {
      "id": "83ce8cd4-ba27-4a32-8cd7-13bdb9a0bb9a",
      "name": "Sheets – Read Vehicle for Status1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        368,
        7424
      ]
    },
    {
      "id": "6eded368-9e59-4a4d-875f-81431eed645f",
      "name": "Build Vehicle Status1",
      "type": "n8n-nodes-base.code",
      "position": [
        608,
        7424
      ]
    },
    {
      "id": "96aa6941-f598-4459-bf77-31b0746ddbaf",
      "name": "WATI – Send Vehicle Status1",
      "type": "n8n-nodes-wati.wati",
      "position": [
        832,
        7440
      ]
    },
    {
      "id": "2c703e1e-f31e-4482-bdb8-20be1333076f",
      "name": "Parse Log Service1",
      "type": "n8n-nodes-base.code",
      "position": [
        1088,
        7408
      ]
    },
    {
      "id": "57d19ea9-6445-47f5-acac-29d2736ca072",
      "name": "Sheets – Append Service Record1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1328,
        7408
      ]
    },
    {
      "id": "feed07d9-1360-4c53-a786-8fbfba09dcec",
      "name": "WATI – Confirm Service Logged1",
      "type": "n8n-nodes-wati.wati",
      "position": [
        1568,
        7408
      ]
    },
    {
      "id": "aa67610d-ef92-4bb0-b4db-6f51a121c13d",
      "name": "WATI – Send Help1",
      "type": "n8n-nodes-wati.wati",
      "position": [
        1792,
        7360
      ]
    },
    {
      "id": "162d1d59-73c0-4b86-8b54-b7b362261dc5",
      "name": "Wati Trigger",
      "type": "n8n-nodes-wati.watiTrigger",
      "position": [
        -1040,
        7040
      ]
    }
  ],
  "connections": {
    "Wati Trigger": {
      "main": [
        [
          {
            "node": "Command Router1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Command Router1": {
      "main": [
        [
          {
            "node": "Sheets – Find Vehicle for Booking1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Sheets – Find Vehicle for Mileage1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Sheets – Read Service History1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Sheets – Read Vehicle for Status1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Parse Log Service1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Sheets – Find Vehicle for Confirm1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "WATI – Send Help1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Service Due1": {
      "main": [
        [
          {
            "node": "Sheets – Mark Reminder Sent1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Log Service1": {
      "main": [
        [
          {
            "node": "Sheets – Append Service Record1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build History View1": {
      "main": [
        [
          {
            "node": "WATI – Send History1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Vehicle Status1": {
      "main": [
        [
          {
            "node": "WATI – Send Vehicle Status1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Mileage Update1": {
      "main": [
        [
          {
            "node": "Sheets – Update Mileage1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Handle Slot Confirmation1": {
      "main": [
        [
          {
            "node": "Sheets – Log Appointment1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets – Update Mileage1": {
      "main": [
        [
          {
            "node": "WATI – Send Mileage Ack1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets – Log Appointment1": {
      "main": [
        [
          {
            "node": "WATI – Confirm Appointment1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Tomorrow Appointments1": {
      "main": [
        [
          {
            "node": "WATI – Send Appointment Reminder1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Book & Generate Slots1": {
      "main": [
        [
          {
            "node": "WATI – Send Available Slots1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets – Read All Vehicles1": {
      "main": [
        [
          {
            "node": "Check Service Due1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets – Read Appointments1": {
      "main": [
        [
          {
            "node": "Check Tomorrow Appointments1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger – 8AM Daily": {
      "main": [
        [
          {
            "node": "Sheets – Read Appointments1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets – Mark Reminder Sent1": {
      "main": [
        [
          {
            "node": "WATI – Send Service Reminder1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger – 9AM Daily1": {
      "main": [
        [
          {
            "node": "Sheets – Read All Vehicles1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets – Read Service History1": {
      "main": [
        [
          {
            "node": "Build History View1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets – Append Service Record1": {
      "main": [
        [
          {
            "node": "WATI – Confirm Service Logged1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets – Read Vehicle for Status1": {
      "main": [
        [
          {
            "node": "Build Vehicle Status1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets – Find Vehicle for Booking1": {
      "main": [
        [
          {
            "node": "Parse Book & Generate Slots1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets – Find Vehicle for Confirm1": {
      "main": [
        [
          {
            "node": "Handle Slot Confirmation1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sheets – Find Vehicle for Mileage1": {
      "main": [
        [
          {
            "node": "Parse Mileage Update1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}