OVERVIEW
The aim of this document is to provide a quick guide about how to set up Jet's Google Sheets integrations through webhooks.
Note - this integration can only support 40,000 rows at a time. Clients or Jet Staff may need to wipe/move data out of this sheet if they approach the limit.
STAGE 1: Setting up your Google Sheet
STAGE 2: Setting up your Google Project
STAGE 1: Setting up your Google Sheet
Create a Google Sheet
Create a new Google Sheet. With the appropriate headers for the fields you want to import will be along the first row, in the order in which your data will display.
When set up, the integration will have the same permissions as the creator of the webhooks itself, so please ensure this is being created with full Edit access on the desired sheet.
Please add ds.api@jetinteractive.com.au to your google sheet with full edit permissions.
STAGE 2: Setting up your Google Project
Create a Google Project
Open the Google Developers Console (https://console.developers.google.com). Click into your project list at the top left of the page, and select the option to create a New Project.
Give this project a name that is relevant to the purpose - we recommend using your Jet Account number & Account name, and including the date of activation in the description.
Eg: Project Name: 1000 Jet Interactive
Enable the Sheets API
From your Dashboard screen, select Enable APIs and Services.
From here, you can use the search function to search for Sheets.
Click into the result and select Enable.
Configure the consent screen
In your side panel, click on the OAuth consent screen to configure your security settings.
On the next page, you will be asked to enter the app information.
Match the App Name to the project name (see below) and the user support email will be ds.api@jetinteractive.com.au.
Enter the developer contact information as your email address or the contact of your developer, then click Save and Continue.
On the next page, you will need to configure the project scopes. Select ADD OR REMOVE SCOPES and a panel will open on the righthand side. Search for the following options:
- Profile
- openid
- https://www.googleapis.com/auth/spreadsheets
Here is what each option will look like:
email
profile
openid
https://www.googleapis.com/auth/spreadsheets - (make sure you select the live option not readonly)
When all 4 scopes are added, your page should look like the one below, with 3 non-sensitive entries and 1 sensitive.
Press Save and Continue, then scoll to the bottom of the summary page to go Back to Dashboard.
Enable Credentials
Drom your side panel, now select the option for Credentials.
Select Create credentials, and choose the option for OAuth client ID.
When asked to choose the type of ID, please select Web Application. Again, match the name to the project name.
Under Authorised redirect URIs, select and add the URL of
https://www.jetinteractive.com.au/
Then click CREATE down the bottom.
A screen will pop up containing your client ID & client secret codes.
Click Download JSON, and download these codes to your computer.
This will download to your computer in json format. Then send these details to the Jet support team or your account manager.
Webhook Creation
Once these steps have been completed, please inform the Jet support team or your account manager. They will then work with you to set up a webhook that sends data to this sheet with the data that you require and will guide you through the final steps.
- String - range #A2:A#
- String - majorDimension #ROWS#
- array - values
- array
- Add JSON values
Authentication
Use the following credentials for Jet owned (ds.api@jet..) google sheets.
"redirectURI": "https://www.jetinteractive.com.au/", "authURL": "https://accounts.google.com/o/oauth2/auth", "clientId": "169842596043-4k3lj3b4idmmsq8l3ap1o0q26ijo25ad.apps.googleusercontent.com", "authorizationCode": "4/0AeaYSHBMvgy0FRov5LZAPIquNB_ZSUrTkrJIFs3MHo3Ou4vOpsNNsrx1IWvyE2RBF7MkGA", "accessTokenURL": "https://oauth2.googleapis.com/token", "scope": "https://www.googleapis.com/auth/spreadsheets", "clientSecret": "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", "refreshToken": "1//0gPocC_fPuPEbCgYIARAAGBASNwF-L9IriaG9YlH2iPup8_q__vrZAadrr4R2oPShS2XkCiDVFchnkM7evDYdagZGnNq1HNnX0Bw"