Manage WhatsApp property maintenance tickets with WATI and Google Sheets

Empower your property management with a high-efficiency automated support desk. This workflow manages the complete maintenance lifecycle—from initial issue classification and ticket creation to team assignment, status updates, and tenant feedback—all centralized through WhatsApp using WATI and Google Sheets.

---

🎯 What This Workflow Does

Turns WhatsApp into an intelligent bridge between tenants, maintenance teams, and landlords:

- 📝 Instant Ticket Creation Tenants can report any property issue via WhatsApp. The system automatically classifies the problem (Plumbing, Electrical, etc.) and assigns a priority level based on keywords.

- 🚦 Smart Command Routing A master switch node handles incoming messages based on intent: - New Issue: Classifies and logs a new ticket. - update <id> <status>: Allows maintenance teams to update progress. - rate <id> <1-5>: Captures tenant satisfaction scores. - mystatus: Provides tenants a view of their active tickets. - dashboard: Gives landlords an overview of property health.

- 🛠️ Maintenance Coordination Simultaneously notifies the tenant of their Ticket ID and pings the relevant maintenance team with full issue details and an SLA deadline.

- 🚨 Proactive SLA Monitoring A daily morning trigger scans all open tickets for SLA breaches (e.g., High Priority overdue after 4 hours) and alerts the landlord and teams for immediate action.