Turn Airbnb reservation emails into a spreadsheet
Airbnb emails you when a reservation is confirmed, changed or canceled. MailQL reads each into a row with the guest, dates, guests and your payout, so you can total a month's earnings or see every stay at a glance.
Free for 25 emails a month.
What each email becomes
| Platform | Status | Guest | Property | Check-in | Check-out | Payout |
|---|---|---|---|---|---|---|
| Airbnb | New | Mark Ellis | Bayfront Cottage | Oct 17, 2026 | Oct 20, 2026 | $612.40 |
All the columns: Platform, Status, Guest, Property, Check-in, Check-out, Guests, Payout, Confirmation. You can rename, add or remove any of them.
Set it up in two minutes
- Make a mailbox in MailQL and pick Rental bookings. You get an address like
bookings-k7f3qd@in.mailql.com. - In Gmail, open Settings → See all settings → Forwarding and POP/IMAP and add that address. Confirm it with the code MailQL shows you.
- Search Gmail for
from:(airbnb.com) subject:(reservation OR confirmed OR canceled OR altered), choose Create filter, and tick Forward it to your MailQL address. - New Airbnb reservation emails turn into rows as they arrive. Forward a few old ones by hand to fill the table now.
Good to know
- Cancellations and date changes become their own rows with Status set to Cancelled or Changed. Filter by status to see only what's current.
- Payout is what you earn after Airbnb's host fee, when the email shows it.
- Anything MailQL isn't sure of is highlighted for you to check, with the words from the email it came from.
- Download the table as CSV whenever you like, send each new row to a webhook (Zapier and Make included), or ask questions like "how many this month?".
Other emails it reads
Vrbo booking emailsBooking.com reservation emailsThumbtack lead emailsAngi lead emailsYelp quote requestsBark request emails
MailQL isn't affiliated with or endorsed by Airbnb. Names are trademarks of their owners, used here only to say which emails MailQL can read.