Introduction
If you use both Google Calendar and SharePoint, you may want to synch entries. In this blog, we'll learn how to configure a flow that will sync Google calendar with a SharePoint list. When a new entry is created in Google calendar, the entry will sync and added to a SharePoint list.
Steps
- Login to MS FLow using Office365 credentials.
- Create from blank > When an event is added, updated or deleted from a calendar.
![MS Flow - Sync Google with SharePoint Calendar List]()
- Add "Convert Time Zone" to configure date time settings. You need to do this as the list entry in SharePoint might differ from Google calendar beacuse of regional settings.
![MS Flow - Sync Google with SharePoint Calendar List]()
In Base time column, you need to specify 'chaged Event List Items Start DateTime'.
- Repeat same step above for End Time and select 'Changed Event List Item End Date-Time'.
![MS Flow - Sync Google with SharePoint Calendar List]()
- Insert 'Switch', as it will specify what type of event taking place in calendar.
![MS Flow - Sync Google with SharePoint Calendar List]()
Type "Changed Event List Item Action Type" which will check, if it was added/updated or deleted.
- Create 3 case for Create, Update and Delete.
Case1: Create
![MS Flow - Sync Google with SharePoint Calendar List]()
Note : I have created CalendarID as custom column in Calendar list to store ID of the calendar event. This ID will help me in doing update/delete event for the same event.
Case 2: Update
![MS Flow - Sync Google with SharePoint Calendar List]()
Case 3: Deleted
![MS Flow - Sync Google with SharePoint Calendar List]()
We are done with the configuration.
Now, If you add any calendar entry in Google calender, you can see the records being created in SharePoint list as well. See below.
Cheers!!