MS Flow - Sync Google With SharePoint Calendar List

This flow will sync data from Google Calendar and store in our SharePoint calendar list as soon as new entry is made in Google Calendar.

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
  1. Login to MS FLow using Office365 credentials.
  2. Create from blank > When an event is added, updated or deleted from a calendar.

    MS Flow - Sync Google with SharePoint Calendar List

  3. 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'. 

  4. Repeat same step above for End Time and select 'Changed Event List Item End Date-Time'. 

    MS Flow - Sync Google with SharePoint Calendar List

  5. 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.

  6. 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.
 
MS Flow - Sync Google with SharePoint Calendar List
Cheers!!