topic Re: Google Spreadsheets integration in QlikView

Google Spreadsheets integration

lukacvetko — Fri, 20 Nov 2020 18:02:30 GMT

Hi guys,

I know there is QVSource Connector, but is there any other custom made way to integrate Google Spreadsheets into QlikView? I know there is a way to do it if you publish Spreadsheet for everyone to see, but that is not a solution that would help me.

If there is no direct way from Google Spreadsheets to QlikView, is there possibility to automate Google Spreadsheets export to excel?

Does anyone have any experience in this field?

Regards,

Luka

Re: Google Spreadsheets integration

Anonymous — Mon, 09 Feb 2015 15:28:44 GMT

Hello Luka, the problem is the authentication with google.

We have tried a lot of things in our site to achieve this goal, and the best we could find was the QVSource.

As you have said there is a way to do it with the token if you publish the spreadsheet, is a simple URL to configure inside the plain files wizard.

http :// spreadsheets.google.com/feeds/download/spreadsheets/Export?key=[FILE_TOKEN_ID]&exportFormat=csv

But if it's not done that way and you want security for your documents, you have to deal with Oauth2, we tried with VBS functions and we can't record the login and let the QV to load after the "login".

[Image Source: https://developers.google.com/accounts/docs/OAuth2]

The solution should be (after our thinking into it), to create some web (in asp or php) or webservice, to deal with the oauth and the download of the file, allowing QV to read the download file. In other words, create a clone of QVSource, and for us, much more time consuming than the cost of purchasing it.

P.D. I'm not related with the QVSource company.

Hope it helps.

Regards,

Re: Google Spreadsheets integration

lukacvetko — Wed, 11 Feb 2015 08:16:19 GMT

Hello Adrian,

Thank you for detailed reply. If we find any other solution, I'll post it.

Regards,

Luka