- 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=
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
