- Go to your gSheet you want to integrate in qliksense
example : ( https://docsdrive.google.com/spreadsheetsfile/d/1JopfGZMeZd4-2FKBQACkACYDgPIoaOy_w91sUj4601o/edit#gid=01jzXm8k_96GbaSW7iQ9-gmIWREWbwV3c73fVJGM0YBpw/view or https://docsdrive.google.com/spreadsheetsfile/d/1CECuNQAlAYffAWQElEiuvbgG3NyQcJLRwHHFc3AafE4/edit?ts=5a7aed52#gid=9579595081u-jBgJb1Zch7DpoOTYVit4KifGAzm6717p6EXSqoF8s/view )
- Add sbs-is-appli-qlikview.support@solvay.com with 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
...
- Copy path following URL :
http://localhost:5555/data?connectorID=GoogleDriveConnector&table=GetSpreadsheet&worksheetKey= 1JopfGZMeZd4-2FKBQACkACYDgPIoaOy_w91sUj4601o %3a_ 0 &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) Your Spreadsheet Key (example 1CECuNQAlAYffAWQElEiuvbgG3NyQcJLRwHHFc3AafE4)
3) %3a_
4) Your Worksheet Key (example 957959508)
5) &appID=
- Click on Create and select desired columns
You have also the possibility to skip First X Rows of your gSheet with parameter &skipRows=X to add in your URL (at the end for example).
X correspond to the number of rows will be excluded from the output. (For example 1 or 2). By default Qlik Skip 0 rows and the first line is used like Header
(Example &skipRows=1)