This article will show you the way of exporting your Myfrontdesk calendar to the Google Calendar using Event-o-matic, a simple-to-use Google Sheets Add-on.
Please check the article on how to install these add-on: How to install Event-o-Matic.
Note! Free version allows to create up to 25 calendar events per day.
Step 1. Go to the Reservations tab, and filter reservations for upcoming dates.
Step 2. Export reservations to Excel with fields that you want to be displayed on your Google Calendar.
Step 3. Select fields which you need to be on Google Calendar and Export reservations.
Step 4. Open the downloded file in a new spreadsheet.
Step 5. Click on Add-ons, hover over Event-o-Matic and select Configure.
Once the add-on is displayed, you can follow the instructions on how to proceed.
Step 6. 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.
Step 8. 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.
Step 9. 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.
The final 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.
You will need to update your Google Calendar manually as reservations will not be auto-adjusted.