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
- Enter your Google Account credentials to generate an Authentication Code
- Copy the code and paste it into the Qlik Web Connectors Authentication Code Field
- Click Save and Run the Table (It should return "true")
- To List all your Google SpreadSheets;
- Select "ListSpreadsheets" and Run the Table
- Data Preview will list all the SpreadSheets present
- Locate the SpreadSheet in which you are interested and Copy the "Key" value
- Now, select "GetSheetValues" table
- Paste the SpreadSheet Key which you have copied
- Select the Range. For eg: A5:A10 or (Use A1 notation e.g. Sheet1!A1:B2, Sheet1 or 'Sheet Name'!A1:B2)
- Select other options as required.
- Save Inputs & Run the Table.
- 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,
- URL: http://localhost:5555/
- Give it a name
- 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