Loading Data From Google Sheet With Multiple Tabs

[#1]

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

[asavenko]

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.