Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a requirement for fetching data from Google spreadsheets.
I am using Qlik web connector's Google spreadsheet connector for creating a connection, however I can't find the file in the spreadsheet /List of files section.
Is this because the file is shared with me?
I also tried to use Web connection using the shareable link , but getting error as - "The file could not be loaded as it does not contain any valid data tables"
Could anyone please help on this to fix the error.
Thanks in advance !
Regards,
Saloni
Hi Saloni,
last time I used Sense with GoogleSpreadsheet, only the public spreadsheets was available, because of different method of private sheets.
That time I used google api+python code.
I'm curios, has it been resolved yet?
G.
Hello Gabor,
How did you fix this issue?
Were you able to connect to the private sheets?
In my case, i requested for full rights to the sheets, but still no luck
Regards,
Saloni
Hi Saloni,
I checked my desktop version, if you tried with the WebFile connector, I think we can still not use that for private GSheet.
The following link will help you implement a solution for get tha data:
https://developers.google.com/sheets/api/quickstart/python
I have an example code for that somewhere (but it is created years ago, I don't know, whether that versiojn of API is still supported), but if you want, I'll find it and share with you.
My solution was a little python script, that get the data and save it in csv, that file is read by QlikSense.
The python script was called through LoadScript cmd -c python.... etc...
Kind regards,
Gabor