Connection with Google Sheet

sakshi2106 — Mon, 20 Dec 2021 21:08:46 GMT

I am getting error while connecting google sheets using web connection. I already published the sheet publicly still it is giving error.

Please help

Re: Connection with Google Sheet

stevedark — Thu, 07 Jan 2021 17:16:15 GMT

Hi @sakshi2106

You will most likely be better off using Qlik Web Connectors to connect to your Google Spreadsheet.

This requires a separate download and install and it then provides a proxy that sits between Sense and the Google API, handling authentication.

More details are here:

https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Setup-deploy/Qlik_Web_Connectors_package.htm

I have downloaded a Google Spreadsheet by sharing it up as a CSV in the past, but have not done this for some time, as Qlik Web Connectors now means you can do it without making the data public.

Qlik Web Connectors can be found on the Qlik Download site, or the current version can be found here:

https://da3hntz84uekx.cloudfront.net/WebConnectors/2.98.1/0/_MSI/QlikWebConnectorsDecember2020.zip

I was interested in whether I could get this to work with one of my spreadsheets, and it works by appending /gviz/tq?tqx=out:csv after the key in the spreadsheets URL. I found the instructions for this here:

https://www.megalytic.com/knowledge/using-google-sheets-to-host-editable-csv-files

That would be a quick and easy fix, but I would still recommend QWC.

Hope that helps,

Steve

topic Re: Connection with Google Sheet in App Development

Connection with Google Sheet

Re: Connection with Google Sheet