Setup Guide - Google Sheets

Follow our setup guide to connect Google Sheets to DataChannel.

Prerequisites

Google Sheets uses service account authentication method. Therefore, to connect Google Sheets 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 Sheets API:

    • Go to the Google Cloud Console.

    • Search for and enable the Google Sheets API.

  2. Share the Google Sheet:

    • Open the Google Sheet you want to access.

    • Click Share.

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

      google sheets 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 Sheets API:

    • Go to the Google Cloud Console.

    • Search for and enable the Google Sheets 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 Sheet:

    • Open the Google Sheet you want to access.

    • Click Share.

    • 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 Sheets 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 Sheets. 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 Sheets API and shared the desired Google Sheet (as described in the pre-requisites above).

    google sheets 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 sheets new creds 2

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

    googlesheets 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.