How to Export Reservations from your Myfrontdesk Calendar to Google Calendar?

1. Go to the Reservations tab, and filter reservations for upcoming dates.

2.  Click on the 'Export Reservations' button

3. Select the fields which you need to be on Google Calendar

4. Click on 'Export Reservations'

1. Open a new Google Sheets page.

2.  Upload the reservations file to Google Sheets.

1. Click on the 'Add-ons' Tab

2. Hover over Event-o-Matic and click on 'Setup'

Once the add-on is displayed, you can follow the instructions on how to proceed.

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.

Next, select the Sheet of data that contains all the calendar information.

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.

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.

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 checkmark on the top timeline.  

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 checkmark, and the events will be created!

Additional column headers will have been created at this point: Event Status and Event Link. Event Status will let the user know if the event was successfully created, and 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.