Your bookings in your own Google Sheet
Connect Google and Airflow writes your bookings to a spreadsheet in your own Drive, with one tab for each listing and a summary. It is a one-way export: changes you make in the sheet are not read back.
A spreadsheet Airflow keeps for you
Connect your Google account under Connections in your portal and Airflow creates a spreadsheet in your own Google Drive. It is your file: share it with your accountant or a co-host as you would any other sheet.
What is in it
- A Summary tab with each listing, its number of bookings and their total value.
- One tab for each listing, with one row for each booking: the guest and their email, check-in and check-out, nights and guests, the channel, and the booking status.
- The money columns: the total and payout in the channel's currency and in your accounting currency, the exchange rate used with its date and source, the nightly rate, cleaning fee, platform fee and commission.
- The invoice: its number and status from your accounting software, where there is one.
Bookings from other channels and bookings taken on your own booking page are both included.
When it updates
Select bookings in your Bookings list and press Send to Sheets to write them to the sheet whenever you like. On plans with a monthly task allowance, new bookings are also added automatically, about every 15 minutes, and the row of a booking deleted in Airflow is removed on the next pass. If the spreadsheet is deleted, Airflow makes a new one the next time you send to Sheets.
An export, not a second place to edit
Airflow never reads the sheet back, and the first row of every tab says so. If you change a cell, Airflow does not see it, and your change is lost the next time the tab is rewritten. To change a booking, change it in Airflow. If you want your own notes or formulas, keep them in a separate spreadsheet that reads from this one.
Tasks
Exports to Google Sheets use automated tasks. See pricing for how many and on which plans.
Key benefits
Why Google Sheets Export matters
Your data, in your Drive
The spreadsheet lives in your own Google account. Share it with your accountant or co-host like any other sheet.
Kept up to date
Send bookings to the sheet whenever you like. On plans with a monthly task allowance, new bookings are added automatically.
The money columns too
Each row carries both currencies, the exchange rate, fees, payout and invoice status, not only names and dates.
How it works
From bookings to a spreadsheet in three steps
Connect Google
In your portal, open Connections, choose Google Sheets and sign in with Google.
Airflow creates the sheet
A spreadsheet appears in your Drive with a Summary tab and one tab for each listing.
It fills as bookings arrive
Press Send to Sheets in your Bookings list to write your bookings to it. On plans with a monthly task allowance, new bookings are added automatically.
FAQ
Common questions about Google Sheets Export
If I edit the sheet, does Airflow pick up my changes?
No. It is a one-way export. Airflow never reads the sheet back, and an edit is overwritten the next time the tab is rewritten. To change a booking, change it in Airflow.
Which bookings are included?
Bookings from every channel and bookings taken on your own booking page, for every listing on your account. Each listing has its own tab.
How often does the sheet update?
Whenever you press Send to Sheets in your Bookings list. On plans with a monthly task allowance, new bookings are also added automatically, about every 15 minutes.
Does the export use tasks?
Yes, exports to Google Sheets use automated tasks. See the pricing page for how many.
More from Connections & Integrations
Related features
Guides & insights
From the blog
No-Shows and Guests Who Never Pay
Abandoned checkouts, offers that expire, and the stay nobody turned up for. What each one should do to your calendar, your books and your task allowance.
Read article →
Nobody Should Manage a Night Cap by Hand
Counting nights against a letting limit every month, for every property, forever, is a job that fails quietly. What it takes to hand it over safely — and what should still need your say-so.
Read article →
Which Nights Should You Give Up?
If a night cap means closing part of your year, the question is not how many nights but which ones. Rank the year by your own rate card and the answer changes by thousands.
Read article →Want your bookings in a spreadsheet?
Connect Google from your portal and Airflow creates the sheet for you.
Start your free trial See plans and pricing