This article explains how to export the reservations in your Cloudbeds PMS calendar to your Google Calendar using Event-o-matic, a simple-to-use Google Sheets add-on.
Before getting started: Check the article on how to install the add-on: How to install Event-o-Matic.
- The app free version allows to create up to 25 calendar events per day.
Export and open the reservation list
1. Export reservations from Cloudbeds PMS
The first step is to access Cloudbeds PMS to select the list of reservations that needs to be exported. Follow the steps described in the following guide to export or print your guests list.
2. Open the new downloaded file in Google Sheets
- Open a new Google Sheets page
- Click on the Upload tab
- Click on Browse, and select the recently exported list of reservations to be open in Google Sheets
Set up Event-o-Matic and create events
1. Setting up Event-o-Matic
- Click on the Add-ons tab
- Hover over Event-o-Matic and click on Setup. Once the add-on is displayed, follow the instructions on how to proceed
2. Create events on Event-o-Matic
- Select the calendar in which events will be created. If the user is using a primary calendar, then the user’s email address should be selected from the list.
- Select the Sheet of data that contains all the calendar information
- Click on Next
3. Match the appropriate input
- Match the appropriate input with the column header designated in the spreadsheet. For example, if column header is named “Name” then you would select that under the “Event Title” drop-down menu.
- Click on Next
4. Create full day events
- You can create full day events instead of events with a start and end time. If your date and time appear in the same column, then select the box Date and time are combined. If they are in separate columns, leave the box unchecked
- Click Next
Final steps
1. Selection summary
- You will see a summary of all the selections made. You can go back to any previous step and change the settings by clicking on the appropriate blue check mark on the top timeline.
- Click to Preview
2. Preview screen
- This step will include a preview screen, which shows the date and time of the event, description of the event, email addresses of who will be invited to the event, the organizer’s Calendar, and the time zone.
- Click the big blue check mark, and the events will be created
- Additional column headers will have been created at this point: Event Status and Event Link
The Event Status: Will let the user know if the event was successfully created
- The Event Link: Will provide a link to the calendar event that you can use to open the event directly from the spreadsheet.
- You can check all reservations on your Google Calendar:
Update your Google Calendar manually, as reservations will not be auto-adjusted.
Comments
Article was straight forward but it's an awful lot of work to just sync calendars
This is pretty clunky. Surely there is just an iCal feed for a room?
Hello, Matthew Jackson!
Please contact our dedicated Support Team for further assistance with this request. They will be more than happy to help you.
Regards!
Article is closed for comments.