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.
   
   
   
   
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.
   
   
   
   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'. 
   
   
   
   
5. Insert 'Switch', as it will specify what type of event taking place in calendar.
   
   
   
   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
   
   
   
   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
   
   
   
   Case 3: Deleted
   
   

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!!