Jitterbit Harmony Google Sheets Registration¶
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¶
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.
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.jsonto your downloads directory:
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 Account:
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_emailfound in the downloaded configuration key file:
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