Supported version: Cloud.
API Rate Limit: 60 requests per minute
Supported Authentication:
OAuth 2.0 Authentication
Application Registration on Google
This document explains the steps to register the application and how to use it on Gathr.
Step 1: Register application on Google API Console.
Important: It will require additional permissions from the Google Cloud Administrator or from IT department to register an application.
1. Login to the following URL:
https://console.developers.google.com/apis/credentials
2. Go-to ‘Credentials’
3. Click on ‘Create Credentials’
4. Choose ‘OAuth Client ID’
5. On ‘Create OAuth client ID’
a. Enter Application type: Web Application
b. Enter Name: Gathr (or any suitable application name)
c. Authorized redirect URIs : Redirect URL of Gathr host.
Ex.: https://HostName-123.gathr.one:48444/AccountManagementWebService/callback.html
Please NOTE that the "HostName-123.gathr.one" will be your organization's HostName.domainName for the server where Gathr is deployed. Please replace this part with your Gathr Server's HostName.domainName in the URL given above and then use it.
IMPORTANT: This URL should be accessible from the client machine from which end-user will access Gathr. You may need to create a DNS entry or configure proxy accordingly to make this URL accessible.
6. Copy Client ID and Client Secret and keep it safe. We will need this information while configuring the connector on Gathr.
7.Please enable Google Drive & Google Sheets API, refer https://support.google.com/googleapi/answer/6158841?hl=en
Step 2: Install Google Sheets Connector on Gathr.
1. Login into Gathr and go to Store(Top Right of your screen) Section.
2. Search for Google Sheets in the search box.
3. Scroll down to Connectors section and click on three dots to install the connector.
4. Once the connector is installed successfully, Click on Home or Apps Section on your screen.
5. Click on "Connectors" tab and check for "Google Sheets".
6. Double click on "Google Sheets" and click on Add Connection.
7. Click on Advanced(bottom right of the popup) and:
Validate the following details in the form:
a. Instance URL: https://sheets.googleapis.com/v4
b. Enter Application Key: Client ID received from Step 1- #6.
c. Enter Application Secret: Client Secret received from Step-1 #6.
d. Authorization URL:
https://accounts.google.com/o/oauth2/v2/auth?access_type=offline&prompt=consent
e. Access Token URL: https://oauth2.googleapis.com/token
f. Domain for Callback Authentication: Validate HostName with Domain Name used in step 1- #5.c
Example: HostName-123.gathr.one
g. Scope: openid profile email https://www.googleapis.com/auth/drive.file
https://www.googleapis.com/auth/drive
h. Click on ‘Save’.
i. On clicking ‘Save’, a pop-up will appear which requires Google user to login using the credentials and choose ‘Allow access’ if asked in the pop-up window.
Important: Please make sure, the pop-up is not blocked by the chrome browser.
8. Once it will be completed, it will ask for the URLs related to Google Sheets Connection:
Validate the following details in the form:
a. Instance URL: https://www.googleapis.com/drive/v3
b. Application Key: Client ID received from Step 1- #6.
c. Application Secret: Client Secret received from Step 1 #6.
d. Authorization URL:
https://accounts.google.com/o/oauth2/v2/auth?access_type=offline&prompt=consent
e. Access Token URL: https://oauth2.googleapis.com/token
f. Domain for Callback Authentication: Validate HostName with Domain Name used in above Step 1- #5.c
Example: HostName-123.gathr.one
g. Scope: openid profile email https://www.googleapis.com/auth/drive.file
https://www.googleapis.com/auth/drive
h. Click on ‘Save’.
i. On clicking ‘Save’, a pop-up will appear which requires Google user to login using the credentials and choose ‘Allow access’ if asked in the pop-up window.
Important: Please make sure, the pop-up is not blocked by the chrome browser.
Step 3: Use Google Sheet Connector
To start the analysis, go to an editable app and right-click on the Floor -> Connectors-> All Connectors -> Google Sheets ->
• Search
• Spreadsheets.