How to Integrate Qlik with Google Drive

This tutorial shows how to access files stored in Google Drive and load them into Qlik Sense for analysis.

Notes:

• Alternatively, a recommended approach is to sync your Google Drive folder to your local machine using the Google Drive desktop app, then load files from the synced folder.
• Another alternative is to download the file directly from Google Drive and load it as a local file.
  

1. Open Google Drive app on your browser or machine and sign in to sync your Drive files to a local folder.
2. Log in and open your Qlik Sense app, and click Data load editor from the top menu.
3. Click Create new connection in the Data connections panel on the right.
4. Select Google Drive from the list of connectors.
5. Click Authenticate to open the Google sign-in page. Log in to your account and grant Qlik permission to access your files.
6. Copy the authentication code provided by Google and paste it into the Qlik connector dialog, then click Verify.
7. Click Create to store the connection. You can now access the saved connection, browse the available tables, and select the ones you want to load into your app.