Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

saloniptieto
New Contributor II

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
Valued Contributor II

Re: Google spreadsheets connection error

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.

saloniptieto
New Contributor II

Re: Google spreadsheets connection error

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
Valued Contributor II

Re: Google spreadsheets connection error

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