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.
Log in to the Google account that is to have access to the Google Drive with Google Sheets, and go to the Google
Enable the Google Sheets API for the account by clicking Enable the Google Sheets API:
In the resulting dialog, click Download Client Configuration to save the file credentials.json to your
Using the link shown in the previous image, go to the API Console.
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):
Create a service account that will be given access to the Google Drive with Google Sheets. Click Create Service
Give the service account a name and a description, and click Create:
Select Owner as a role:
To create the private key required to access the Google Sheets, click Create Key:
Specify the key type as JSON and click Create:
Save the downloaded configuration key file in a safe location where you can access it.
Now, share the Google Drive folder with Google Sheets using the client_email found in the downloaded
configuration key file:
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: