Skip to main content

Connecting to Google Calendar (extractor)

Important

Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice.

Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

The Celonis Google Calendar extractor lets you bring data from your Google Calendar account into the Celonis Platform for process mining and analysis. It supports the following basic features:

Important

This extractor's use and transfer to any other app of information received from Google APIs adheres to Google API Services User Data Policy including the Limited Use requirements.

Prerequisites

This section details important prerequisites or prerequisite knowledge for using this extractor.

Google Calendar authentication methods

To connect the Celonis Platform with your Google Calendar account, you need to configure an authentication method. The Calendar REST API uses the OAuth2 authentication method and you have two options here:

  • Use Celonis Client to Connect (recommended): Enter your email address and Gmail password and then grant the Celonis Platform access when prompted by Google.

  • Using client ID and client secret: Using the Google Cloud Management Console to create a cloud project, configure the OAuth consent, and then create the credential information required by the Celonis Platform. For the steps here, see: Optional: Configuring OAuth 2.0 via Google Cloud Management Console.

Optional: Configuring OAuth 2.0 via Google Cloud Management Console

The Google Calendar REST API uses the OAuth 2.0 authentication method, requiring you to provide a username, password, client ID, and client secret. These authentication credentials can be created and configured via your Google Cloud Management Console, available to anyone with a Google account (including individual users).

To configure your authentication method:

  1. Create a Google Cloud project for the connection with the Celonis Platform, see: Google Workspace - Create a Google Cloud project.

    A screenshot showing the gmail settings screen.

  2. Enable the Google Calendar API for the project created in step 1, see: Google Workspace - Enable Google Workspace APIs.

    enable_google_calendar_API.png

  3. Configure the OAuth consent, see: Google Workspace - Configure the OAuth consent screen and choose scopes.

    A screenshot showing the gmail settings screen.

  4. Create access credentials, see: Google Workspace - Create access credentials.

    When prompted to enter a redirect URL, use the following:

    https://auth.redirect.celonis.cloud/extractor_redirect
    A screenshot showing the gmail settings screen.

  5. Copy the client ID and client secret displayed with your access credentials:

    A screenshot showing the gmail settings screen.

For further information about Gmail's REST API, see: Google Workspace - Gmail API Overview.

Google Calendar endpoints

The following Google Calendar endpoints are used:

Note

This extractor uses the Google Calendar REST API. For further information about the Google Calendar REST API, see: Google Workspace - Google Calendar API overview.

  • Get Calendar list

  • Get Events

  • Get Settings

Configuring the Google Calendar extractor

This section describes the basic setup of configuring the Google Calendar extractor. To configure the extractor:

  1. From your data pool diagram, select Data Connections.

    A screenshot showing how to access the data connections screen from a data pool diagram.

  2. Select Add Data Connection and select Connect to Data Source.

    A screenshot showing how to add data connections from a data pool diagram.

  3. Select Cloud - Google Calendar.

  4. Enter the following connection details:

    • Name: Enter an internal reference for this data connection.

    • API URL: https://www.googleapis.com

    • Use Celonis Client to Connect: Enter your username and password, alternatively, provide the client ID and client secret configured in your prerequisites.

    • Client ID: Taken from the Google Cloud Management Console steps. This is only needed if you followed the optional prerequisites.

    • Client Secret: Taken from the Google Cloud Management Console steps. This is only needed if you followed the optional prerequisites.

    • Advanced Settings: Leave as defaulted.

    A screenshot showing the google calendar data connection configuration.

  5. Select Save.

  6. If configured correctly, the Google sign in page should load. Select the account you want to use and, when prompted, select the access level the Celonis Platform can have to your Google calendar account.

    The options here are:

    • View events on all your calendars.

    • See and download any calendar you can access using your Google Calendar.

    A screenshot showing the google account authentication approval screen.

  7. Select Continue.

    The connection between your Google Calendar account and the Celonis Platform is set.