Skip to main content

Connecting to Google Sheets (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 Sheets extractor lets you bring data stored in individual Google Sheets 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 Sheets URL required

As part of the Google Sheets extractor configuration, you must provide the URL to the specific Google Sheet you want to extract data from.

Important

You must have direct access to the Google Sheet URL. Using a shared or restricted link that you cannot access will prevent successful authentication.

Google Sheets authentication methods

To establish the connection, you only need to provide the URL of the specific Google Sheet you want to extract data from. After configuring the extractor, a Google authorization window opens where you must grant Celonis Extractor for Google Sheets permission to access the file. Once access is approved, the connection is authenticated using your Google account credentials through OAuth 2.0.

Important

You must have direct access to the Google Sheet URL. Using a shared or restricted link that you cannot access will prevent successful authentication.

To grant access, in the Google authorization window, select the your account with permission to access the URL, and when prompted for permission, select Allow.

Configuring the Google Sheets extractor

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

Note

After configuring the extractor connection, the Google authorization window should open. Select your account with access to the provided URL, and when prompted for permission, select Allow. For more information, see Google Sheets authentication methods.