QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

Google Drive and Spreadsheets

The Qlik Google Drive and Spreadsheets connector uses the Google Drive API to access your Google Drive metadata, such as the names of files and subfolders in your Google Drive account.

Note: The Google Drive and Spreadsheets connector is only available on cloud editions of Qlik Sense.

Ways to access your data

To access your Google Drive metadata, you need to authenticate the connector with your Google Drive account credentials. After you create a connection and select Google Drive and Spreadsheets as your data source, you are redirected to a Google Drive login page. Log in with your credentials to retrieve an authentication token, and enter it into the connector.

Creating a connection and selecting data

Loading data from tables

After you authenticate the connector with your account credentials, use the tables to fetch your data. Below are use cases for some of the available tables:

Table Description
ListFiles Use this to list the files and subfolders of a folder located in your Google Drive account.
ListFilePermissions Use this to list the file permissions for a specified File ID.
ListFileRevisions Use this to list the file revision history of a specified File ID.
ListSpreadsheets Use this to list the spreadsheet content located in your Google Drive account.
ListWorksheets Use this to list the spreadsheet content of a specified Spreadsheet Key.
GetWorksheet Use this to load the spreadsheet content of a specified Worksheet Key.
GetSheetInformation Use this to view the spreadsheet metadata information of a specified Spreadsheet Key.
GetSheetValues Use this to return a specified range of values, from a specified Spreadsheet Key.

To select and load data from a table, enter the required table parameters and click Preview data. Required parameters are marked with an asterisk (*). The table fields are displayed under the Data preview tab. You can select fields individually by selecting the box beside each field name. Select Insert script after you have made your selection.

Creating a connection and selecting data

Reference - Google Drive API documentation

You can refer to the Google Drive API documentation to learn more about the requirements and restrictions imposed by the Google Drive API.

Google Drive API Introduction

Troubleshooting

You receive an error message that you have reached the API rate limit

Possible cause

You have exceeded the API limits that are imposed by the Google Drive API.

Proposed action

To reduce the impact of reaching API rate limits, develop your app with the following in mind:

  • Extract only the data you need.
  • Reload one Google Drive-based application at a time.
  • Ensure that loops in your script that make API calls do not result in infinite loops.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?