How to get Load and get Qlik Sense (Standard Mode) script from Qlik Google Drive and Spreadsheets Connector - Qlik Web Connectors

Rakesh_HB — Sun, 23 Jan 2022 22:45:03 GMT

Load the content of your Google Sheets into Qlik Sense Enterprise

Environment

Follow the below steps:

Install Qlik Web Connectors
Open Qlik Web Connectors (http://localhost:5555/web) and Select "Qlik Google Drive & Spreadsheets Connector"
Authenticate your Google Drive using "CanAuthenticate" Table
1. Enter your Google Account credentials to generate an Authentication Code
2. Copy the code and paste it into the Qlik Web Connectors Authentication Code Field
3. Click Save and Run the Table (It should return "true")
To List all your Google SpreadSheets;
1. Select "ListSpreadsheets" and Run the Table
2. Data Preview will list all the SpreadSheets present
3. Locate the SpreadSheet in which you are interested and Copy the "Key" value
Now, select "GetSheetValues" table
1. Paste the SpreadSheet Key which you have copied
2. Select the Range. For eg: A5:A10 or (Use A1 notation e.g. Sheet1!A1:B2, Sheet1 or 'Sheet Name'!A1:B2)
3. Select other options as required.
4. Save Inputs & Run the Table.
5. Data Preview Table will show you all the required data.

Load the content into the Qlik Sense application?

IMPORTANT: This script requires Qlik Sense February '18 release or later. This will only work if the Qlik Sense reload process is running from one of the following 'white listed' IP addresses:

You can add or remove addresses from this list from 'Start Page' ->'Settings' -> 'My Settings' -> 'Allowed IP Addresses'.

Select Qlik Sense (Standard Mode) beside Data Preview
Open Qlik Sense Application
Go to Data Load Editor
Create a new Connection and select "Web File" Connection (Another way of loading the data is shown here)
Edit the connection,
1. URL: http://localhost:5555/
2. Give it a name
3. Save it (Should save successfully)
Paste the generated/copied Data Load script
You should then ensure that you place the following line at the top of your script and replace YOUR_CONNECTION_NAME with the name of the connection that you have created.

let vQwcConnectionName = 'lib://YOUR_CONNECTION_NAME';
Load the data
Once the data is loaded successfully, the data from your Google Spreadsheet will be available to use in your analysis

article How to get Load and get Qlik Sense (Standard Mode) script from Qlik Google Drive and Spreadsheets Connector - Qlik Web Connectors in Official Support Articles

How to get Load and get Qlik Sense (Standard Mode) script from Qlik Google Drive and Spreadsheets Connector - Qlik Web Connectors

Environment

Load the content into the Qlik Sense application?