Skip to main content

Celonis Product Documentation

Connecting to Google Sheets (extractor)

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.

You can extract data from individual Google Sheets using our Google Sheet extractor. When configuring this extractor, you need to give the Celonis Platform permission to access your Google Sheet on your behalf. This means that you must be able to sign into the Google account during the configuration and allow the authentication request, rather than copying a URL provided by another team member.

To copy the sheet URL while viewing the Google sheet, click Share and then Copy link:

share_google_sheets.png

With access to a Google account and a share URL for a single Google Sheet:

  1. Click Data Connections.

    data_connections_within_data_pool_diagram.png

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

    add_data_connection.png

  3. Select Cloud - Google Sheets.

  4. Enter the following connection details:

    • Name: An internal reference for the data connection.

    • Spreadsheet URL: The full URL of the Google Sheet you want to extract data from.

    • Advanced Settings: Leave as default

    google_sheets_config.png

  5. Click Save.

  6. If configured correctly, the Google sign in page should load. Select the account you want to use and, when prompted for permission, click Allow.

    google_sheets_api_permission.png

    The Google sheet can now be accessed by the Celonis Platform.