Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to load data from Google Drive into Qlik Sense?

I have three Google Docs (Excel) and want to upload the data into Sense, can this be done?

20 Replies
Michael_Tarallo
Employee
Employee

Hi Jose - are the documents you speak of,  MS Excel documents (.xls / .xlsx files) uploaded to Google Drive?

Or are the Google spreadsheet Documents that are Excel-like?

Want to make sure before I give you a specific answer.

Thanks

Mike

Regards,
Mike Tarallo
Qlik
Michael_Tarallo
Employee
Employee

Hi Jose,

Using a Web File Connection and the URL to the document - I was able to get the data into Sense. I made this URL public - so you can test:

https://docs.google.com/spreadsheets/d/12mI4rOSP6EEOLFirKeh59e86s1od1mVdAg_xhnmhuds/edit?usp=sharing

8-11-2014 1-43-07 PM.jpg

8-11-2014 1-43-25 PM.jpg

8-11-2014 1-41-18 PM.jpg

You may / will have to rename the columns to what you want - it seems to reference them as column markers.

If I learn anything new - I will post it here and let you know.

Mike

Regards,
Mike Tarallo
Qlik
Not applicable
Author

Thanks Michael, your answer helped me a lot, however I am still having issues when trying to share the qvf and trying to share the .xls file uploaded to Google Drive.

I want other users to load the data and see the changes that others made to the Excel file.

Can this be done?

Michael_Tarallo
Employee
Employee

Hi Jose - glad to hear it. Please see this video to learn more about sharing apps with the free version of Qlik Sense Desktop:

Qlik Sense Desktop - Sharing Apps (video)

In order to do this, each person would need a copy of Sense Desktop and a copy of the QVF file - then they can perform the reload - in the Data Load Editor  (if using the public web connection for example) - to see the changes in the app.

We are thinking about this type of scenario and later this year will have a sharing service for this exact type of scenario. With certain limitations. Then you can also consider the Qlik Sense Enterprise server which allows complete online development, sharing, management and security and governance.

HTH

Let me know if you have any questions.


Regards,

Mike T

Regards,
Mike Tarallo
Qlik
johnpaul
Partner - Creator
Partner - Creator

Hi Michael,

Thanks, this worked for me as well, but I needed to make the document publicly readable.

Not sure if this can be done with a secure document

Michael_Tarallo
Employee
Employee

Hi John Paul,

I see. At the moment, that would require a specific connector to Google Docs. Other than passing the credentials inline - which is not recommended, you are correct. I will ping our product management team and inquire about plans in this area.

Thanks for your contributions.

Mike

Regards,
Mike Tarallo
Qlik
mountaindude
Partner Ambassador
Partner Ambassador

Google is changing their various Google Drive products to a new format.

They say "they will migrate all docs in the 2014-2015 timeframe". So it

could be tomorrow, could be in a year's time.

The old Drive format allowed for having restricted access set on a doc, and

still be able to get the doc's data via a simple http call (which could be

done from a QV load script).

In the new format only docs visible to everyone can be accessed that way

(just like you had also found out).

If you set access restrictions on a doc, for example sharing it with

certain people, or maybe with everyone in your organisation (if you have

Google docs for organisations), then the "old" way of retrieving the data

from QV's load script does no longer work.

The only way seems to be using Google's APIs to get the data.

Which is somewhat of a pain if you do it yourself... Lot's of API calls,

OAuth and similar things that needs to be taken care of.

QVSource, while being an add-on that cost money, does handle all that work

for you - and it has worked flawlessly for us so far, in this very scenario.

It would of course be nice if Google would enable the old way of geting

data from docs also in the new Drive file formats. Might be hard though, if

they made the change to improve security etc. The old way of retrieving

data was pretty insecure...

/Göran

On Tue, Nov 11, 2014 at 1:56 PM, Michael Tarallo <qcwebmaster@qlikview.com>

Please mark the post as a solution if it provided you with a solution to the topic at hand. Thanks!
Michael_Tarallo
Employee
Employee

Thank you for the valuable information Goran and for reminding me about QVSource!

John Paul - check this out:

Here is an example of using QVSource with Qlik Sense: Qlik Sense Desktop - Using QVSource Data Connectors (video)

Note there are connectors for Google products. The video can explain how to get started.

11-11-2014 9-21-55 AM.png

Regards,
Mike Tarallo
Qlik
chrisbrain
Partner - Specialist II
Partner - Specialist II

Thanks for mentioning our Google Drive & Spreadsheets Connector which supports the following features. If you think we are missing anything please let us know!

* List the spreadsheets and their worksheets and load the contents of these spreadsheets.

* List all files on your Google Drive or only those matching your query (see below).

* List all the file revisions for a document.

* Create or update a Google Spreadsheet from a CSV file - for example you could use a store command in your QlikView/Qlik Sense load script to create a CSV file containing data from your application and turn this into a spreadsheet on Google Drive.

** Using the above feature, roll your own simple report creation and distribution services for QlikView based data using Google Apps Script (see example below).

* Download (export) the raw contents of supported docs into QlikView/Qlik Sense.

* Download any Google Drive file to your local machine.

** Note that if you have published a [https://developers.google.com/apps-script/content_service|Google Apps Script] which returns content, you can also use the connector to read the response from this script.

* List and load your Google Spreadsheets into QlikView / Qlik Sense as tables.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense