
In this section we're going to build an automated system that takes booking data from Airbnb and inputs it inside a Google Sheet file. Then, inside the sheet itself, you can apply all kinds of custom formulas that your business needs.
Learn to configure Zapier's email parser for Airbnb reservations by creating templates, mapping fields like guest name, check-in, check-out, guests, nights, payout, and taxes, and edit templates to correct misreads.
Add the forgotten nights field by updating the Google Sheets integration and refreshing fields. Retest and ensure nights data appears in Google Sheets after editing the template.
Compute total cleaning costs in Google Sheets by counting arrivals or departures in October 2018 and multiplying by 25, with options to adjust for hourly pay or non-fixed fees.
In this section we're going to build a system that sends automated SMS messages to your cleaning crew notifiying them about the next check-out dates. The messages will be sent directly from an Android phone as if you sent them yourself.
Install Auto Remote, test messaging via a web link to your phone, and enable permissions to trigger automatic texts for new reservations; then connect Zapier to Auto Remote.
Define a Tasker profile that triggers when the auto remote receives a message containing anti-birth 7, then run a task to send a message to Oxana.
Create a new Tasker task, add a send SMS action using the auto remote message variable, and test per listing profiles before notifying each cleaning person.
This section is all about "soft" automations
Automate guest messages after booking, sending a thank-you note and arrival instructions automatically via the porter app to prevent errors and save time.
Set up automated messages by creating A/B rules triggered at events like a confirmed reservation, check-in, or check-out, and apply templates across all listings.
Explore sms features to automate guest notifications and streamline cleaning crew updates for new reservations, comparing messaging automation with task lists and auto responses.
Display frequently asked information inside the apartment, such as Wi‑Fi codes and checkout times, and provide printed explanations or a tablet service like You're Welcome for guides and tours.
Discover how to drastically reduce guest key loss by communicating replacement costs, automating warnings via your porter, and, when needed, replacing the lock to deter losses.
Store spare keys in master lock boxes at safe, guest-accessible locations to enable self pick up and reduce risk, with key replacement fees and smart locks as a last resort.
Standardize white linen, use fast-drying sheets, add mattress protectors, minimize carpets and mirrors, and mount the TV to simplify cleaning and reduce fingerprints.
Install shower dispensers and stock refills in locked storage to reduce guest consumption and costs. Have housekeepers report missing items by text to control inventory and ensure pre-stocked essentials.
This course is for Airbnb hosts or managers who have multiple listings and need to save time on repetitive tasks. Everything inside this course comes from my own experience: I'm a part-time real-estate investor and I rent my properties on Airbnb. However, the more properties I was buying, the more time I was dedicating to hosting. And since this is not my main business activity, I put everything in place to automate and optimize it to the maximum. As of today, I arrived at a point where almost everything works in the background. Here are some of the tasks I automated:
Bookkeeping inside Google Sheets. Everything is filled and calculated automatically.
Cleaning crew dates notifications. They receive the next check-out dates automatically by text message.
Messaging with guests: 90% of it is automated, the rest is optimized so they don't need to ask me questions.
Self check-in: guests always arrive and depart by themselves, I never need to go myself.
Between the bookings: my cleaning crew is efficient and takes care of everything. Refills are optimized.
Better ratings. Thanks to a few tricks, my ratings are going up automatically.
And although in this course I will show you how to get your Airbnb booking data inside Google Sheets, you will also be able to do get it inside Xero and Quickbooks if you prefer to use that. This is not covered in this course but once you understand how it works with Google Sheets you will be able to easily reproduce the same system with QuickBooks and Xero. For everything else, I'm still working on the remaining manual tasks and I'll be updating the course when I come up with automated solutions. But for now, this can already help you free out a lot of time. Just please understand the following before taking the course:
I will be using paid services here, you can't make these things work for free.
Some parts are very technical but totally doable. There is no coding involved.
There might be glitches. You'll need to look for solutions and I'll try to help where I can.
So, as an Airbnb host, if you feel concerned by the problems I'm mentioning here, don't hesitate to take this course!