Google Calendar Sync Pipeline
Connect to Google Calendar
Connect Google Calendar through the Peliqan connectivity module:- Start Date (required)
- (Optional) table selection via ‘Advanced’
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
- Go to Google Cloud Console.
- Create a new project (or use an existing one).
- Navigate to IAM & Admin > Service Accounts.
- Click Create Service Account.
- Give it a name.
- Assign Project > Editor role (or more fine-tuned permissions).
- 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
- In the Service Account settings → Edit the account.
- Check Enable G Suite Domain-wide Delegation.
- Note down the Client ID shown.
4. Grant OAuth Scopes in Google Admin Console
- 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:
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”.
