Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Rakesh_Basappa
Support
Support

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

Load the content of your Google Sheets into Qlik Sense Enterprise

Environment

 

Follow the below steps:

  1. Install Qlik Web Connectors
  2. Open Qlik Web Connectors (http://localhost:5555/web) and Select "Qlik Google Drive & Spreadsheets Connector"
  3. 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")
  4. 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
  5. 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'.

 

  1. Select Qlik Sense (Standard Mode) beside Data Preview
  2. Open Qlik Sense Application
  3. Go to Data Load Editor
  4. Create a new Connection and select  "Web File" Connection (Another way of loading the data is shown here)
  5. Edit the connection,
    1. URL: http://localhost:5555/
    2. Give it a name
    3. Save it (Should save successfully)
  6. Paste the generated/copied Data Load script 
  7. 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';

  8. Load the data
  9. Once the data is loaded successfully, the data from your Google Spreadsheet will be available to use in your analysis

 

Version history
Last update:
‎2022-01-23 05:43 PM
Updated by:
Contributors