I recently built this full automation system using
make.com.
THIS IS WHAT IT DOES:
This
Make.com workflow fully automates guest support and staff dispatching for an Airbnb property management business. It captures guest complaints via Telegram, uses AI to categorize the issue, assigns an available team member via Google Sheets, and updates everyone instantly—all with zero manual effort.
How the Workflow Executes
Guest Complaint Intake
Trigger: A guest sends a message to a Telegram channel reporting an issue (e.g., a broken AC, leaky shower, or a cleaning request).
AI Intent Analysis & Logging
Make AI Agent & JSON: The workflow passes the message to an AI Agent that interprets the text, extracts the intent, and structures the data.
Logging: The request is immediately saved into a Google Sheet database.
Smart Department Routing
An If-Else router reads the AI's classification and splits the task into dedicated operational paths:
Maintenance Path: For infrastructure issues (AC, plumbing, etc.).
Cleaning Path: For housekeeping or turnover requests.
Automated Staff Assignment
The system searches the Company Workers List in Google Sheets to find an available team member belonging to the designated department.
It pairs the open ticket with the first available worker.
Instant Guest Reply & Availability Lock
Telegram Confirmation: The bot automatically replies to the guest to reassure them: "We've seen your issue, we've gotten your message, and we'll get back to you as soon as possible. We've got you covered!"
Status Update: The workflow instantly updates the assigned worker's tag to "Unavailable" in the Google Sheet to prevent double-booking.
Peace ✌️