Setup Guide - Google Drive

Follow this setup guide to connect Google Drive data to DataChannel.

Prerequisites

Google Drive uses service account authentication method. Therefore, to connect Google Drive to DataChannel, you need to first decide whether to use a DC managed Service Account or not.

Option 1: If using a DC-managed Service Account you will need to do the following:

  1. Enable the Google Drive API:

    • Go to the Google Cloud Console.

    • Search for and enable the Google Drive API.

  2. Share the Google Drive:

    • Open the Google Drive you want to access.

    • Click Share.

    • Enter the service account’s email address. (You can obtain this from the Google Drive Credential addition page on DataChannel Console.)

      google drive new creds 3

    • Set the permission (Editor or Viewer).

    • Click Send.

Option 2: If using a self-managed Service Account you will need to do the following:

  1. Enable the Google Drive API:

    • Go to the Google Cloud Console.

    • Search for and enable the Google Drive API.

  2. Create a Service Account:

    • Go to the Service Accounts page.

    • Click + Create Service Account.

    • Provide a name, ID, and optional description.

    • Create and continue.

  3. Generate a Service Account Key:

    • Go back to the Service Accounts page.

    • Select the service account you just created.

    • Go to the Keys tab.

    • Click Add key then Create new key.

    • Choose JSON as the key type and create.

    • Download the JSON key file and store it securely.

  4. Share the Google Drive:

    • Open the Google Drive storage file/folder you want to access.

    • Click Share.

    • Please note that you will be required to share the source file or folder (with read permission). Also, in case your pipeline configuration involves post processing action , you need to share the destination file/folder as well (with read and write permissions).

    • Enter the service account’s email address.

    • Set the permission (Editor or Viewer).

    • Click Send.

Use the downloaded JSON key file for authentication.

Setup instructions

  1. Select a data destination for your Google Drive Data. If you have not yet added a data warehouse, go to data warehouse tab and add a warehouse.

    Data Warehouse once selected cannot be changed.

  2. Authorise DataChannel to connect to your Google Drive. You will need to add Name and indicate whether you are using a DC managed Sevice account.

  3. If using a DC managed Service account, Service account email will be automatically listed. Please ensure that you have enabled the Google Drive API and shared the desired Google Drive Storage(as described in the pre-requisites above).

    google drive new creds 1

  4. In case you are not using a DC managed Service account, you can use a previously added service account or add a new one. Use the downloaded JSON key file for authentication (as per process described in the pre-requisies).

    google drive new creds 2

  5. Click on + Data Pipeline to start adding data pipelines to your account.

    googledrive data source detail

  6. Details of individual objects and reports are available here.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.