Skip to end of metadata
Go to start of metadata

Overview

As the connection will be an application that interfaces with Google Sheets, you will need a Project ID, Client Email, and Private Key to access the Google Sheets API. To obtain these, you need to create a service account from your Google account.

Create a Google Account

If you don't have a Google account, you will need to create a Google account.

Enable the API

  1. Log in to the Google account that is to have access to the Google Drive with Google Sheets, and go to the Google Sheets API.

  2. Enable the Google Sheets API for the account by clicking Enable the Google Sheets API:

    Sheets new application

  3. In the resulting dialog, click Download Client Configuration to save the file credentials.json to your downloads directory:

    Sheets new application

  4. Using the link shown in the previous image, go to the API Console.

  5. Using the Google navigation menu (located in the upper left, to the left of the Google APIs logo), find the Service accounts menu item (under IAM & admin):

    Sheets new application

  6. Create a service account that will be given access to the Google Drive with Google Sheets. Click Create Service Account:

    Sheets new application

  7. Give the service account a name and a description, and click Create:

    Sheets new application

  8. Select Owner as a role:

    Sheets new application

    Sheets new application

  9. To create the private key required to access the Google Sheets, click Create Key:

    Sheets new application

  10. Specify the key type as JSON and click Create:

    Sheets new application

    Save the downloaded configuration key file in a safe location where you can access it.

  11. Now, share the Google Drive folder with Google Sheets using the client_email found in the downloaded configuration key file:

    Config Google Drive

    NOTE: The Google Drive folder with the Google Sheets you wish to access must be shared with the Google service account email that is used to create the connection. All spreadsheets accessed by the connection will be in that particular folder. Sharing at least one folder is required. Google Sheets outside the shared folder cannot be accessed.

All the credentials that are required will now have been generated and shared. For the Jitterbit Harmony Google Sheets Connector, these credentials are required:

  • Google service account project ID
  • Google service account client email
  • Google service account private key string

On This Page

Last updated:  Dec 20, 2019

  • No labels