{
  "name": "Manage WhatsApp property maintenance tickets with WATI and Google Sheets",
  "nodes": [
    {
      "id": "9708565d-ec6a-4933-96a1-75998a3f62b7",
      "name": "📋 Main Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -48
      ],
      "parameters": {
        "width": 580,
        "height": 488,
        "content": "## 🏠 Tenant Support System – Maintenance Request Tracker\n\n**Tenant journey in 4 steps:**\n\n① Tenant WhatsApps an issue → ticket auto-created in Google Sheets\n② Ticket assigned to right maintenance team"
      }
    },
    {
      "id": "85564ffc-a450-4d3c-9466-1bbaaab885e4",
      "name": "Sticky – Ticket Creation",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        32
      ],
      "parameters": {
        "width": 868,
        "height": 616,
        "content": "### 🎫 Ticket Creation Path\nTenant texts any issue → **Classify Issue Code** uses keyword matching to auto-detect category (Plumbing / Electrical / Appliance / Security / Other) and priority (High / Me"
      }
    },
    {
      "id": "9930a9c6-cf6e-42fa-85df-edce3612876e",
      "name": "Sticky – Status Updates",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        720
      ],
      "parameters": {
        "width": 988,
        "height": 488,
        "content": "### 🔁 Status Update Path\nMaintenance team replies with *update <ticket-id> <status> <note>* → **Parse Update Code** extracts fields → **Sheets Update** changes ticket status → Two WATI messages sent: "
      }
    },
    {
      "id": "e26e0843-9fb8-43cc-9802-6a893660c073",
      "name": "Sticky – Feedback & Reports",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1232,
        1248
      ],
      "parameters": {
        "width": 908,
        "height": 648,
        "content": "### ⭐ Feedback & Landlord Dashboard\nWhen ticket marked *resolved* → tenant receives a rating prompt → tenant replies *rate <ticket-id> <1-5>* → rating logged in Sheets.\n\nLandlord texts *dashboard* → g"
      }
    },
    {
      "id": "12a863c5-8bac-4a24-8a3f-4e79b8b6146b",
      "name": "Sticky – SLA Monitor",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2400,
        864
      ],
      "parameters": {
        "width": 1160,
        "height": 440,
        "content": "### 🚨 SLA Breach Monitor\n**Schedule Trigger** runs every morning at 8AM.\nReads all open tickets → flags any ticket older than the SLA threshold per priority:\n- 🔴 High → 4 hours\n- 🟡 Medium → 24 hours\n-"
      }
    },
    {
      "id": "e910d4bb-a1d5-4303-8cb4-ab6b9fc88ed3",
      "name": "Master Router",
      "type": "n8n-nodes-base.switch",
      "position": [
        624,
        880
      ]
    },
    {
      "id": "fd7fcf42-47e0-4662-9771-f4c30ee4bb83",
      "name": "Classify Issue & Create Ticket",
      "type": "n8n-nodes-base.code",
      "position": [
        1264,
        352
      ]
    },
    {
      "id": "837321fe-bcd5-43bf-9c2b-56caf5169e94",
      "name": "Google Sheets – Create Ticket",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1504,
        352
      ]
    },
    {
      "id": "33807f78-b11b-4ef0-9878-4b98ce3d8c0d",
      "name": "WATI – Confirm to Tenant",
      "type": "n8n-nodes-wati.wati",
      "position": [
        1712,
        224
      ]
    },
    {
      "id": "0da128fb-8b49-464b-a600-a57f9f0bbfa5",
      "name": "WATI – Notify Maintenance Team",
      "type": "n8n-nodes-wati.wati",
      "position": [
        1712,
        416
      ]
    },
    {
      "id": "ddd1b7ad-9af2-4299-b79e-d1d1341299dd",
      "name": "Google Sheets – Read Tickets (Update)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1232,
        928
      ]
    },
    {
      "id": "a4975e18-e634-4293-81a3-e7facc774ba6",
      "name": "Parse Status Update",
      "type": "n8n-nodes-base.code",
      "position": [
        1456,
        928
      ]
    },
    {
      "id": "7dd2214e-71a4-4e8b-a94f-ea018d229bc6",
      "name": "Google Sheets – Update Ticket Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1696,
        928
      ]
    },
    {
      "id": "85ff89e9-cdda-4ae4-be5c-f328124b919a",
      "name": "WATI – Acknowledge Team",
      "type": "n8n-nodes-wati.wati",
      "position": [
        1920,
        832
      ]
    },
    {
      "id": "45bcbe7a-80b6-46d8-9b76-5663d4f0c52f",
      "name": "WATI – Notify Tenant of Update",
      "type": "n8n-nodes-wati.wati",
      "position": [
        1920,
        1008
      ]
    },
    {
      "id": "13bd3e03-fd28-41c2-bfe3-f1fe5251b0d1",
      "name": "Parse Rating",
      "type": "n8n-nodes-base.code",
      "position": [
        1312,
        1376
      ]
    },
    {
      "id": "9cb7e77f-8db2-4948-87e3-43020648b909",
      "name": "Google Sheets – Save Rating",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1552,
        1376
      ]
    },
    {
      "id": "75f17e80-623e-477d-8e36-ecc6db4f2cdc",
      "name": "WATI – Send Rating Thanks",
      "type": "n8n-nodes-wati.wati",
      "position": [
        1840,
        1376
      ]
    },
    {
      "id": "81203671-ef43-4218-89ca-bd91ad5c7f14",
      "name": "Google Sheets – Read My Tickets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1312,
        1536
      ]
    },
    {
      "id": "dee9ba78-1d4b-4bfd-87c0-bd0059d292b0",
      "name": "Build My Tickets View",
      "type": "n8n-nodes-base.code",
      "position": [
        1552,
        1536
      ]
    },
    {
      "id": "aea2f273-5455-4895-801d-14156d4cea68",
      "name": "WATI – Send My Tickets",
      "type": "n8n-nodes-wati.wati",
      "position": [
        1824,
        1536
      ]
    },
    {
      "id": "646cd7f6-7320-49fe-b260-48d760ed0986",
      "name": "Google Sheets – Read All Tickets (Dashboard)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1312,
        1696
      ]
    },
    {
      "id": "11af040b-24f2-45ff-83f1-79340bfd0fec",
      "name": "Build Landlord Dashboard",
      "type": "n8n-nodes-base.code",
      "position": [
        1552,
        1696
      ]
    },
    {
      "id": "5a791ebb-f34c-4391-b8fd-faedd270d24b",
      "name": "WATI – Send Dashboard",
      "type": "n8n-nodes-wati.wati",
      "position": [
        1792,
        1696
      ]
    },
    {
      "id": "9f7fc13e-880b-499a-8aee-340878112a99",
      "name": "Schedule Trigger – Daily SLA Check 8AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        2464,
        1088
      ]
    },
    {
      "id": "dfb02e9b-712e-4911-b7ec-611f09aae8f3",
      "name": "Google Sheets – Read Tickets (SLA)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2672,
        1088
      ]
    },
    {
      "id": "9af61a1c-e535-4209-ab00-f5369dbf7523",
      "name": "Check SLA Breaches",
      "type": "n8n-nodes-base.code",
      "position": [
        2912,
        1088
      ]
    },
    {
      "id": "63d80507-51ba-456e-bc72-e8458181785a",
      "name": "WATI – Send SLA Report to Landlord",
      "type": "n8n-nodes-wati.wati",
      "position": [
        3248,
        944
      ]
    },
    {
      "id": "027ffd3b-2912-4f76-aaf1-187df092dcf3",
      "name": "Split Team Alerts",
      "type": "n8n-nodes-base.code",
      "position": [
        3152,
        1152
      ]
    },
    {
      "id": "3cd2bc71-e6e8-4923-9f2e-f8d6f985c477",
      "name": "WATI – Alert Teams of SLA Breach",
      "type": "n8n-nodes-wati.wati",
      "position": [
        3392,
        1152
      ]
    },
    {
      "id": "7b78a766-e12b-46dc-a871-02d7bbe65c33",
      "name": "Wati Trigger",
      "type": "n8n-nodes-wati.watiTrigger",
      "position": [
        432,
        928
      ]
    }
  ],
  "connections": {
    "Parse Rating": {
      "main": [
        [
          {
            "node": "Google Sheets – Save Rating",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wati Trigger": {
      "main": [
        [
          {
            "node": "Master Router",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Master Router": {
      "main": [
        [
          {
            "node": "Google Sheets – Read Tickets (Update)",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Parse Rating",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Sheets – Read My Tickets",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Sheets – Read All Tickets (Dashboard)",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Classify Issue & Create Ticket",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Team Alerts": {
      "main": [
        [
          {
            "node": "WATI – Alert Teams of SLA Breach",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check SLA Breaches": {
      "main": [
        [
          {
            "node": "WATI – Send SLA Report to Landlord",
            "type": "main",
            "index": 0
          },
          {
            "node": "Split Team Alerts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Status Update": {
      "main": [
        [
          {
            "node": "Google Sheets – Update Ticket Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build My Tickets View": {
      "main": [
        [
          {
            "node": "WATI – Send My Tickets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Landlord Dashboard": {
      "main": [
        [
          {
            "node": "WATI – Send Dashboard",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Save Rating": {
      "main": [
        [
          {
            "node": "WATI – Send Rating Thanks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Classify Issue & Create Ticket": {
      "main": [
        [
          {
            "node": "Google Sheets – Create Ticket",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Create Ticket": {
      "main": [
        [
          {
            "node": "WATI – Confirm to Tenant",
            "type": "main",
            "index": 0
          },
          {
            "node": "WATI – Notify Maintenance Team",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Read My Tickets": {
      "main": [
        [
          {
            "node": "Build My Tickets View",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Read Tickets (SLA)": {
      "main": [
        [
          {
            "node": "Check SLA Breaches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Update Ticket Status": {
      "main": [
        [
          {
            "node": "WATI – Acknowledge Team",
            "type": "main",
            "index": 0
          },
          {
            "node": "WATI – Notify Tenant of Update",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Read Tickets (Update)": {
      "main": [
        [
          {
            "node": "Parse Status Update",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger – Daily SLA Check 8AM": {
      "main": [
        [
          {
            "node": "Google Sheets – Read Tickets (SLA)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets – Read All Tickets (Dashboard)": {
      "main": [
        [
          {
            "node": "Build Landlord Dashboard",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}