How to load data from google docs spreadsheet?

[#1]

Hi,

I have few files on google drive spreadsheet. Can someone kindly share a simply way of how to load the data from google drive

For example I have the same excel sheet on my drive locally and this is the loadscript for it

LOAD a,

     b,

     c,

     d

FROM

[test.xlsx]

(ooxml, embedded labels, table is [RAW DATA]);

How do I load the same file from google drive spreadsheet?

Arif

[#2]

how does it authenticate before accessing the file?

[#3]

Can we put some kind of authentication into the script that will authenticate everyone for loading the data?

[marcus_malinow]

Script - Not as far as I'm aware, though I haven't tried this fully.

Only suggestion would be to set up a Google account for your service account, then when logged in to your server as that account log in to Google. Make sure you save your password in IE. Perhaps QlikView will then be able to use that authentication.

[#5]

Can you please explain how can we load data from local google drive? There are files with gsheet extensions and I dont know how to load them in Qlikview.

Arif

[#6]

Hi Marcus,

I'm having the same issue. Please could you explain how to do this as I don't follow.

Thanks,

Jayne

[marcus_malinow]

Hi Jane

So, I have a spreadsheet at the URL https://docs.google.com/spreadsheets/d/1kIpJZ148hMFxN3nGPPKBhbQyov734um6ahBcMNG1xD0/edit#gid=0

I can use this script to load it:

LOAD *
FROM
[https://docs.google.com/spreadsheets/d/1kIpJZ148hMFxN3nGPPKBhbQyov734um6ahBcMNG1xD0]
(html, codepage is 1252, embedded labels, table is @2, filters(
Remove(Row, Pos(Top, 1))
));

Alternatively if you want to build the script yourself, In the script editor, click on the 'Web Files'' button at the bottom. Enter the URL to your Google spreadsheet and follow this wizard.

Marcus

[#8]

Thanks Marcus.

[korsikov]

do you solve a problem? how to specify the Google account you want to use click to download data from Google drive

Save Password in IE not help

[marcus_malinow]

Hi Alexander,

I investigated this fairly thoroughly last year and never managed to resolve it to my satisfaction.

If the document is secured, it didn't seem possible to provide authentication to gain access.

Using Google drive, the downloaded documents weren't in an understandable format.

Marcus

[korsikov]

I found a solution. shareable link - it does not need to enter the Google account