• Go to your gSheet you want to integrate in qliksense

example : (https://docs.google.com/spreadsheets/d/1JopfGZMeZd4-2FKBQACkACYDgPIoaOy_w91sUj4601o/edit#gid=0 or https://docs.google.com/spreadsheets/d/1CECuNQAlAYffAWQElEiuvbgG3NyQcJLRwHHFc3AafE4/edit?ts=5a7aed52#gid=957959508)

•  Add sbs-is-appli-qlikview.support@solvay.com with reader access right on the spreadsheet

Please share the gSheet to the good service account 

Warning : Be careful to have all different column names in your Spreadsheet. If two columns have the same name, it will not work !!

• In parallel create go to ‘Data Manager’ in one of your QlikSense app.

• Go to ‘Add Data’ on left side

• Or create new app and click on right side of hub page -> choice a name of apps

• Create a new connection on ‘Web File’

• Copy path following URL :

http://localhost:5555/data?connectorID=GoogleDriveConnector&table=GetSpreadsheet&worksheetKey=1JopfGZMeZd4-2FKBQACkACYDgPIoaOy_w91sUj4601o%3a_0&appID=

http://localhost:5555/data?connectorID=GoogleDriveConnector&table=GetSpreadsheet&worksheetKey=1CECuNQAlAYffAWQElEiuvbgG3NyQcJLRwHHFc3AafE4%3a_957959508&appID=

In blue you have standard URL must be filled for each gSheet source

In green you have dedicated URL depending from your gSheet worksheetKey

URL is splitted in 5 blocs : 

1) http://localhost:5555/data?connectorID=GoogleDriveConnector&table=GetSpreadsheet&worksheetKey=

2) Spreadsheet Key (example 1CECuNQAlAYffAWQElEiuvbgG3NyQcJLRwHHFc3AafE4)

3) %3a_

4) Worksheet Key (example 957959508)

5) &appID=

• Click on Create and select desired columns