Supported version: Cloud.
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 Klera.
Step 1: Register application on Google API Console.
1. Login to the following URL:
https://console.developers.google.com/apis/credentials
IMPORTANT: You will need additional permissions from the Google Cloud Administrator or from IT department to register an application. Please enable Google Drive & Google Sheets API, refer https://support.google.com/googleapi/answer/6158841?hl=en
2. Go-to ‘Credentials’
3. Click on ‘Create Credentials’
4. Choose ‘OAuth Client ID’
5. On ‘Create OAuth client ID’
a. Application type: Web Application
b. Name: Klera
c. Authorized redirect URIs : Redirect URL of Klera host.
Ex.: https://HostName-123.Klera.com:48444/AccountManagementWebService/callback.html
Please NOTE that the "HostName-123.klera.com" will be your organization's HostName.domainName for the server where Klera is deployed. Please replace this part with your Klera 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 Klera. 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 in
the next step.
Step 2: Import Google Sheets Application Template on Klera.
1. Right click on the Floor -> Connectors -> Import
2. Browse the Application Template (Google Sheet connector).
This process will generate a dataset “REST Application Data Sources”.
Bring it on the Floor.
3. Right click on “Google Sheets Data Source” -> select Connectors -> Connections -> Configure
Enter the following details in the form:
a. Source Name: Google Sheets Data Source
b. Data Source Description: Google Sheet source
c. Instance URL: https://sheets.googleapis.com/v4
d. Authentication: OAuth2
e. Application Key: Client ID received from Step 1- #6.
f. Application Secret: Client Secret received from Step-1 #6.
g. Authorization URL:
https://accounts.google.com/o/oauth2/v2/auth?access_type=offline&prompt=consent
h. Access Token URL: https://oauth2.googleapis.com/token
i. Domain for Callback: HostName used in step 1- #5.c
Example: HostName-123.Kleramachine.com
j. Scope: openid profile email https://www.googleapis.com/auth/drive.file
https://www.googleapis.com/auth/drive
k. Add Account: Select 'Create New Account' from the dropdown.
l. Account Name: Provide an account name here.
m. Click on ‘Save’.
n. 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.
4. Right-click on “Google Drive Data Source” ->select Connectors -> Connections -> Configure.
Enter the following details in the form:
a. Source Name: Google Drive Data Source
b. Data Source Description: Google Drive
c. Instance URL: https://www.googleapis.com/drive/v3
d. Authentication: OAuth2
e. Application Key: Client ID received from Step 1- #6.
f. Application Secret: Client Secret received from Step 1 #6.
g. Authorization URL:
https://accounts.google.com/o/oauth2/v2/auth?access_type=offline&prompt=consent
h. Access Token URL: https://oauth2.googleapis.com/token
i. Domain for Callback: HostName used in above Step 1- #5.c
Example: HostName-123.Kleramachine.com
j. Scope: openid profile email https://www.googleapis.com/auth/drive.file
https://www.googleapis.com/auth/drive
k. Add Account: Select 'Create New Account' from the dropdown.
l. Account Name: Provide an account name here.
m. Click on ‘Save’.
n. 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 Application Template
To start the analysis, right-click on the Floor -> Connectors-> Imported Connectors-> Google Sheets
• Search
• Spreadsheets.