BoostSolutions’ Calendar Rollup collects and organizes calendar events from SharePoint, Microsoft Exchange (2007SP1, 2010, 2013, 2016 and Exchange Online), Google or External Content Type into one calendar Web Part.
In this article, we will demonstrate how to add Google calendar to Calendar Rollup Web Part.
Add google calendar to Calendar Rollup Web Part
And there are some events in the Google calendar as following.
Download the trial version of Calendar Rollup and install it to your SharePoint server.
Navigate to site where you have added the Calendar Rollup Web Part to, on top right of web part, there’s an integrated dropdown menu, select Add Calendar.
Or, click Calendar Rollup Settings and click Add new calendar in the Calendar Rollup Settings page.
In the Add Calendar page, select the Google Calendar.
In the Add or Change a Calendar page, specify a calendar name in General Settings section.
In the Data source configuration section, configure the following settings.
Service Account Email Address: enter your Google service account email address.
User Account Email Address: : enter your google email address.
Private Key: click Upload P12 key… to browse and upload the key file.
Google now uses OAuth 2.0 for server-to-server interactions, in this scenario you specify a service account in Calendar Rollup to call Google API. Once you configure a service account and setup the connection, Calendar Rollup will retrieve calendar data from google on behalf of the service account.
Before configuration, there are some tips you need to know:
• Your Gmail address must be a business email address;
• You need to delegate domain-wide authority to the service account;
• Ensure that Calendar API is enable.
Click Test Connection button to validate the connection.
Once the connection is successful, select a Google calendar in Available Calendar drop-down list.
Keep other settings as default and click OK to add the calendar.
And then, you will find that the events of google calendar show on the Calendar Rollup Web Part.
On the Calendar Rollup Web Part, you also can add, edit or delete events and the changes will be updated to the original calendar source. We will demonstrate how to manipulate events in other articles.