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. Export the CSV file with the reservations you have in the system.
Step 2. Open the downloded file in a new spreadsheet.
Step 3. 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 4. 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 5. 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” dropdown menu.
Step 6. 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 7. 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.