Cloudbeds reporting in a live spreadsheet (planned)

Planned reports

What you will build on Cloudbeds

Each is one formula on live data. These are examples of the syntax: the column names will follow Cloudbeds's own fields once the integration ships.

=data.reservations.sum(nights, month, A2)

Occupancy by month. Room nights sold against nights available.

=data.reservations.count(id, stay_month, A2, booked, ">="&(TODAY()-7))

Pickup. Bookings made in the last 7 days for each future month.

=data.reservations.sum(room_revenue)/data.reservations.sum(nights)

ADR and RevPAR. Average daily rate and revenue per available room.

The data

Tables from Cloudbeds

Reservations · Rooms · Rates · Guests · Payments

How it will run

Your data stays in Cloudbeds

You will sign in with your Cloudbeds account and give Sheets read access. Sheets runs on our servers in the EU and reads your data through Cloudbeds's API when a sheet opens or refreshes. We plan to list it in the Cloudbeds Marketplace.

Want it?

Vote for Sheets for Cloudbeds

A thumbs up moves Cloudbeds up the roadmap. Leave your e-mail address too and we write once, when it ships.

FAQ

Questions

Is Sheets for Cloudbeds available?

Not yet. Cloudbeds is on the Sheets roadmap. Give it a thumbs up and leave your e-mail address on this page: we tell you when it is ready, and the votes decide what we build next.

What will Sheets read from Cloudbeds?

Your reservations, rooms and rates, as tables: Reservations, Rooms, Rates, Guests, and Payments. Each table becomes a data source that formulas, pivot tables and charts read live.

Will Sheets change anything in Cloudbeds?

It is planned read-only: Sheets reads your Cloudbeds data and does not change it.

What works today?

Sheets works today with QuickBooks Online, Xero, Shopify, WooCommerce, BigCommerce, HubSpot, FreshBooks, monday.com, and Asana.

Want Sheets for Cloudbeds?

Requests decide what we build next. We write once, when it is ready.

Tell me when it's ready

85 tools on the integrations page