Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Loading Data From Google Sheet With Multiple Tabs

Hello All,

Please can you tell me, is it possible to load data from a Google Sheet which has more than one tab.

I have tried to do so by selecting 'Share' then 'Get shareable link', updating the privacy settings. Then, on Qlik, I chose to connect a Web File and then copy this link.

When I do this, only one table appears and none of the field names or values are correct.

Is there a way of loading the data correctly? Or do I have to save each tab as its own document?

Thank you in advance,

Alison

1 Reply
asavenko
New Contributor

Re: Loading Data From Google Sheet With Multiple Tabs

You need to use sheet parameter in gviz query to access the sheet by name:

Query Language Reference (Version 0.7)  |  Charts      |  Google Developers

Replace yourspredsheetkey and sheetname with your values to get html table:

https://docs.google.com/spreadsheets/yourspreadsheetkey/gviz/tq?tqx=out:html&sheet=sheetname

sheetname needs to be encoded to replace special symbols.

You can use very convenient Encode/Decode tool on the query language reference page above.

Community Browser