Track Airbnb Booking Emails in a Spreadsheet or Notion (Automatically)

If you host on Airbnb, you already live out of a specific set of emails. Booking confirmed. Payout sent. Reservation reminder. Cancellation. Guest message. Airbnb sends one for every state change, and for a while that feels like enough, because the app shows you the same information. Then tax season arrives, or you add a second listing, or your cleaner asks for next week's turnover schedule, and you realize the data you need is scattered across a few hundred emails with no way to add them up.

I built Quicktion because I kept seeing people copy this stuff into a spreadsheet by hand, one reservation at a time. This post is about wiring your Airbnb emails straight into a spreadsheet or a Notion database so the log builds itself, and being honest about where that approach stops making sense.

Why hosts need a log outside Airbnb

Airbnb's dashboard is good at managing a single stay. It's bad at the things that happen around hosting.

Accounting is the obvious one. When you sit down to do taxes or hand numbers to a bookkeeper, you want total payouts for the year, broken down by listing, with cleaning fees separated from nightly rates. Airbnb gives you a transaction history you can export, but it's per-account and formatted their way. A spreadsheet column you control lets you run a SUM, a SUMIF per listing, and a monthly breakdown in about thirty seconds.

Cleaning and turnover schedules are the second reason. Your cleaner doesn't need access to your Airbnb account. They need a list: which unit, check-out date, next check-in. A shared sheet or a Notion view filtered to this week does that without exposing your booking platform.

And then there's the multi-platform problem, which is the big one. Plenty of hosts list the same unit on Airbnb, Booking.com, and Vrbo. Each platform has its own dashboard, its own payout schedule, its own way of showing a calendar. The one thing they all do is send you a confirmation email. Email is the common denominator. If you capture the email, you can merge three platforms into one calendar and one payout log, which no single platform's dashboard will ever do for you.

Set up a Gmail filter for Airbnb

The whole thing runs on a Gmail filter that catches Airbnb's mail and forwards it automatically. Airbnb sends most transactional mail from automated@airbnb.com, with some from express@airbnb.com and automated-noreply@airbnb.com.

In Gmail, open Settings, go to Filters and Blocked Addresses, and create a new filter. In the From field, use:

from:(automated@airbnb.com OR express@airbnb.com OR automated-noreply@airbnb.com)

If you only want the booking events and not every reminder, narrow it by subject:

from:automated@airbnb.com subject:(reservation OR booking OR payout OR cancelled)

On the next screen, choose "Forward it to" and pick your Quicktion forwarding address. Gmail requires you to verify a forwarding address once before it'll let a filter use it, so add your Quicktion address under Settings, Forwarding and POP/IMAP first, confirm it, then come back to the filter.

From here on, every Airbnb email that matches lands as a new row or page automatically. Nothing to click.

Forward into your destination

On the Quicktion side, you create a destination that points at wherever you want the bookings to live. That can be a Google Sheet, an Airtable base, or a Notion database. For a straightforward payout and turnover log, a spreadsheet is the natural fit, because the reporting is all sums and filters. If you want linked records (one guest across multiple stays, one listing across many bookings), Airtable or Notion gives you more structure.

Every plan auto-maps the basics on every saved email: subject, full body as rich text, sender, date, and any attachments. So even on the Free plan with no configuration, you get a dated, searchable record of every Airbnb email in your sheet. The Google Sheets integration page walks through connecting a spreadsheet if you haven't done it before.

Field mapping with AI Email Intelligence

The auto-mapped fields give you a log. What turns it into something you can actually run reports on is pulling the specifics out of the email body into their own columns. That's what AI Email Intelligence does, and it's a Pro feature. (For a general walkthrough of how prompt-based extraction works, see the AI email extraction guide.)

On the destination, you write a prompt once. Something like:

Extract these from the Airbnb email:

• Guest Name: the guest's first and last name
• Check-in: the arrival date
• Check-out: the departure date
• Nights: number of nights if stated
• Payout: the host payout amount as a number, no currency symbol
• Listing: which of my properties this booking is for

Then you tell it which columns to fill. Here's the kind of table you end up with:

The parser reads the body of each email and drops values into the matching columns. If the payout isn't in a particular email (say it's a reservation reminder rather than a payout notice), it leaves that cell blank instead of inventing a number. It can also read attached PDFs and images, which matters if a platform sends the booking details as an attachment rather than in the body.

Once those columns exist, the spreadsheet does the rest. A SUMIF on Payout by Listing gives you per-property revenue. Sort by Check-in and you've got your turnover calendar. Filter Check-out to this week and that's the list you hand your cleaner.

Tagging by platform

If you're on more than one platform, the pattern is one destination per source. Create a Quicktion destination for Airbnb, another for Booking.com, another for Vrbo, and point all three at the same sheet. On each destination, set a Default value on a Source column: "Airbnb", "Booking.com", "Vrbo". Then set a Gmail filter per platform that forwards its mail to the matching destination.

Every row now arrives pre-tagged with its platform. Group by Source and you can see which channel actually pays better after fees. Default values are a Pro feature; on Free you'd fill the Source column by hand, which is fine if you're only running one platform through Quicktion to test it.

What the free plan covers, and when to upgrade

Be realistic about volume here, because Airbnb is chatty. A single booking can generate a confirmation, a reminder, a payout notice, and a review request. That's four emails for one reservation.

The Free plan gives you 25 emails a month, one destination, and 30 days of history. A casual host with one listing and two or three bookings a month can genuinely run on that, especially if you filter down to just confirmations and payouts rather than every reminder. It's also the right way to test the setup: wire up one filter, watch a few rows land, confirm the parsing looks right.

A host with three listings will blow past 25 emails quickly. Pro is $12/month (or $120/year), and gives you 1,000 emails a month, unlimited destinations, and AI Email Intelligence. Practically, a three-listing operation fits inside 1,000 emails with room to spare, and the AI extraction plus per-platform destinations are the features that make the log worth having. Most hosts who stick with this end up on Pro for the extraction, not the volume.

One thing to be clear about: Quicktion processes emails as they arrive. It doesn't bulk-import your last two years of Airbnb history. You set up the filter, and from that point forward every booking gets logged. Existing emails stay in your inbox.

The alternatives, honestly

A few other ways to solve this, and where each one wins.

A manual spreadsheet. If you host one place a handful of times a year, honestly, just type it in. The overhead of any automation isn't worth it below a certain volume, and a hand-kept sheet is perfectly good. This post is for the point where hand-keeping starts to hurt.

A Zapier email parser. Zapier can parse forwarded emails into a sheet too. It works, and if you already live in Zapier it's a reasonable choice. In my experience the parser setup is fiddlier for unstructured email bodies, and the cost climbs once you're past the free task tier. Quicktion is purpose-built for the email-to-destination step, so the extraction is a prompt rather than a parser template you tune by hand. The email tracking spreadsheet guide covers the general pattern if you want to compare approaches.

A property management system. This is the honest ceiling. Once you're running 15 or 20-plus listings, a real PMS like Hospitable or Guesty is the right tool. They sync availability across platforms so you don't double-book, automate guest messaging, handle dynamic pricing, and coordinate cleaning teams. A spreadsheet fed by email does none of that. If hosting is your actual business rather than a side income, pay for the PMS. Email capture is for the hosts in between: past the point where a manual sheet works, not yet at the scale where a PMS pays for itself.

Getting started

Pick where the bookings should live, create a Quicktion destination pointed at it, and set one Gmail filter for automated@airbnb.com. Watch a few reservations land, confirm the columns look right, then add your other platforms as separate destinations. If you want the guest names, dates, and payouts broken into their own columns, that's AI Email Intelligence on the Pro plan.

You can sign up at quicktion.io and have the first filter running in about ten minutes. If you're leaning toward a spreadsheet for the accounting angle, the order confirmation tracking guide uses the same forwarding pattern and shows the formula side in more detail.