Skip to main content

Google Drive and Spreadsheets Metadata

The Qlik Google Drive and Spreadsheets metadata 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.

Supported offerings

  • Qlik Sense Business
  • Qlik Sense Enterprise SaaS

Ways to access your data

You need to authenticate the connector with your Google Drive account credentials to access your Google Drive metadata. 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 data source connection

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:

Tables that can be loaded
Table Available in Description
ListFiles Data manager and Data load editor

Use this to list the files and subfolders of a folder located in your Google Drive account. You can select a drive ID from the drop-down.

ListFilePermissions Data load editor Use this to list the file permissions for a specified File ID.
ListFileRevisions Data load editor Use this to list the file revision history of a specified File ID.
ListSharedDrives Data load editor Use this to list the user's shared drives
ListSpreadsheets Data load editor Use this to list the spreadsheet content located in your Google Drive account. You can use a drive ID parameter to specify a shared drive, or leave it blank to indicate the default MyDrive. You can also type* (asterisk) to return data from all drives.

This will not return items from the trash bin.

ListWorksheets Data load editor Use this to list the spreadsheet content of a specified Spreadsheet Key.
GetWorksheetV2 Data load editor Use this to load the spreadsheet content of a specified Worksheet Key.
GetSheetInformation Data load editor Use this to view the spreadsheet metadata information of a specified Spreadsheet Key.
GetSheetValues Data load editor 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.