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-d...
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
