Host Tools
Add Host Tools bookings to Google Sheets
This query returns the bookings on a listing between two dates.
Developer info
- API endpoint slug
- hosttools.find_bookings
- Runtime method
- performQuery("hosttools.find_bookings"}
Query fields
Listing Dropdown list
- Label
- Listing
- Helper text
- The listing whose bookings you want.
- Slug
- listing
- Required
- true
- Can have default value
- false
From date Text input > ISO 8601 date and time
- Label
- From date
- Helper text
- The first stay date to include, such as 2026-10-01 or today.
- Slug
- from_date
- Required
- true
- Can have default value
- true
To date Text input > ISO 8601 date and time
- Label
- To date
- Helper text
- The last stay date to include, such as 2026-12-31 or in 3 months.
- Slug
- to_date
- Required
- true
- Can have default value
- true
Booking status Dropdown list
- Label
- Booking status
- Helper text
- Limit the results to one booking status, or leave it on Any status.
- Slug
- booking_status
- Required
- false
- Can have default value
- true
Ingredients
Guest name The guest's full name.
- Slug
- guest_name
- Filter code
- Hosttools.findBookings.GuestName
- Type
- String
- Example
- Ada Testguest
Check in date The check-in date, in the listing's local time zone.
- Slug
- check_in_date
- Filter code
- Hosttools.findBookings.CheckInDate
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06+05:00
Check out date The check-out date, in the listing's local time zone.
- Slug
- check_out_date
- Filter code
- Hosttools.findBookings.CheckOutDate
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06+05:00
Nights The number of nights in the stay.
- Slug
- nights
- Filter code
- Hosttools.findBookings.Nights
- Type
- String
- Example
- 3
Number of guests The total number of guests on the booking.
- Slug
- number_of_guests
- Filter code
- Hosttools.findBookings.NumberOfGuests
- Type
- String
- Example
- 2
Status The booking's status: accepted, pending, inquiry, or cancelled.
- Slug
- status
- Filter code
- Hosttools.findBookings.Status
- Type
- String
- Example
- accepted
Booking channel Where the booking came from, such as Airbnb, VRBO, Booking, Houfy, or internal.
- Slug
- booking_channel
- Filter code
- Hosttools.findBookings.BookingChannel
- Type
- String
- Example
- Airbnb
Confirmation code The booking's confirmation code, as shown to the guest.
- Slug
- confirmation_code
- Filter code
- Hosttools.findBookings.ConfirmationCode
- Type
- String
- Example
- HT-AE523544
Guest price The total price charged to the guest, in the listing's currency.
- Slug
- guest_price
- Filter code
- Hosttools.findBookings.GuestPrice
- Type
- String
- Example
- 450
Currency The currency code for the booking's prices, such as USD.
- Slug
- currency
- Filter code
- Hosttools.findBookings.Currency
- Type
- String
- Example
- USD
Booking Host Tools' ID for the booking. Use it with the "Look up a booking" query and the "Send a message to a guest" action.
- Slug
- booking_id
- Filter code
- Hosttools.findBookings.BookingId
- Type
- String
- Example
- 6ab19e07cba21a8bc75f79e1
