Google Calendar is a versatile time-management and scheduling application developed by Google. It enables users to create and manage events, set reminders, and share schedules with others, facilitating efficient organization of both personal and professional activities. Its key features include Event Creation & Management, Multiple Calendar Support, Sharing & Collaboration, Integration with other Google Services and Task Management, etc. Website : https://calendar.google.com/

This article provides an overview to get started with the Google Calendar connector in Peliqan. Please contact support if you have any additional questions or remarks.

• Google Calendar Sync Pipeline
• Connect to Google Calendar
• Google Calendar data sync to a data warehouse
• Data Activation in Peliqan
• Creating a normal event in a specific calendar
• Creating an online meeting event in a specific calendar
• Getting access to calendars of all users
• 1. Create a Google Cloud Project & Service Account
• 2. Enable Calendar API
• 3. Enable Domain-Wide Delegation
• 4. Grant OAuth Scopes in Google Admin Console
• 5. Add a connection in Peliqan
• Need further help

Google Calendar Sync Pipeline

Connect to Google Calendar

Connect Google Calendar through the Peliqan connectivity module:

Configuration options:

• Start Date (required)
• (Optional) table selection via ‘Advanced’

Once filled, Click on “Connect Google Calendar” to initiate OAuth Flow Authentication.

Google Calendar data sync to a data warehouse

Peliqan offers an out of the box data warehouse. Optionally the user can choose to sync Google Calendar data to their own data warehouse such as Snowflake, Google BigQuery, MS SQL etc.

Data will be synced to the chosen data warehouse and made available through the Peliqan UI for exploration.

Data Activation in Peliqan

Creating a normal event in a specific calendar

Creating an online meeting event in a specific calendar

Getting access to calendars of all users

If you want to sync calendar events from e.g. an ERP to the calendars of multiple employees (users), you can create a “private app” with domain-wide delegation, and use the Peliqan connector “Google calendar (domain-wide delegation)” which is available on request. Contact support: support@peliqan.io.

Follow the below steps.

1. Create a Google Cloud Project & Service Account

1. Go to Google Cloud Console.
2. Create a new project (or use an existing one).
3. Navigate to IAM & Admin > Service Accounts.
4. Click Create Service Account.
• Give it a name.
• Assign Project > Editor role (or more fine-tuned permissions).
5. After creation, go to Keys tab → Add Key → JSON.
• Download the JSON key file.

2. Enable Calendar API

• In API & Services > Library, enable Google Calendar API.

3. Enable Domain-Wide Delegation

1. In the Service Account settings → Edit the account.
2. Check Enable G Suite Domain-wide Delegation.
3. Note down the Client ID shown.

Note that Admin Privileges are required: You need super-admin access in Google Workspace to configure domain-wide delegation.

4. Grant OAuth Scopes in Google Admin Console

1. Go to Google Admin Console → Security → API Controls → Domain-wide Delegation:
• Click Add new.
• Enter the Client ID from your service account.
• Set OAuth Scopes:
Copy

https://www.googleapis.com/auth/calendar
https://www.googleapis.com/auth/calendar.readonly
https://www.googleapis.com/auth/admin.directory.user.readonly

5. Add a connection in Peliqan

Add a new connection using connector “Google calendar (domain-wide delegation)”.

Enter the following details in the Connection form:

• Client ID
• Open the JSON key file that you downloaded from the Service Account and copy/paste the file contents into the field “JSON key file content”.

Need further help

Please contact our support for any further assistance via support@peliqan.io.