Skip to main content
Skip table of contents

Google Drive (Live)

Overview

The Google Drive Live datasource allows you to gather data from your Google Sheet in real-time rather than on a schedule.

Vendor/Partner

Google

Version

V3

API Documentation

https://developers.google.com/drive/api/v3/reference

Google Drive REST API v3

Sunset Date

None listed as of 01/04/2024

Channel(s)

All

Refresh Time (CST)

On change; 2AM

Default backfill

N/A

Alli Data Library

(error)

Before Getting Started

To get started with the Google Drive datasource, ensure you have the following:

  • A Google account with access to a Google Sheet

Required Authorization

Click the button to login to your Google account instance and provide Alli access to your Google Drive.

Additional Configurations

Link To Your Google Sheet

Enter the URL for the Google Sheet you would like to ingest data from into Alli.

Sheet Name

Optionally specify which sheet tab you would like to ingest data from into Alli. If left blank Alli will assume the first sheet tab in your workbook. Sheet tab names must be less than 32 characters.

Frequently Asked Questions

What is the difference between the Google Drive and the Google Drive Live datasource type?

The main difference between these datasource types is the freshness of the data in Alli. The standard Google Drive datasource updates data in Alli every day on a set schedule. The Google Drive Live datasource type is constantly updating data in Alli each time there is an update within the Google Sheet. This happens because each time the Google Sheet saves, it sends a notification to Alli that there are updates to the data and Alli should refresh it’s data.

What limitations should I be aware of with this datasource type?

Currently, this datasource type can only save data to your Redshift database.

How can I query the data from this datasource type?

The data can be queried through Alli Data Explorer’s Custom SQL option (Tutorial). Additionally, this data is saved in a slightly different location and requires the client slug to be slightly altered in the query in this format {client_slug}_external.{datasourcename}. For example, if I have a datasource in my Demo client named test_live_google_drive, I can query this data by doing: select * from demo_external.test_live_google_drive.

How is data updated in Alli?

The Google Drive Live datasource type will do a full replace of data on each load.

Does this datasource support parent-child relationships?

The Google Drive Live datasource type does not currently support parent-child relationships.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.