Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Google spreadsheets connection error

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

3 Replies
undergrinder
Specialist II
Specialist II

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.

Anonymous
Not applicable
Author

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

undergrinder
Specialist II
Specialist II

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