Skip to main content
Skip table of contents

Google Drive


Import google sheets into Alli using the Google Drive datasource





API Documentation

Google Drive REST API v3

Sunset Date

None listed as of 10/06/23


Refresh Time (CST)

3 am, 11 am, 2 pm, 6 pm, 9 pm / Real Time

Default backfill


Alli Data Library


Getting Started

  1. Google Drive datasources require a Google account with access to Google Drive.

  2. This will lead to a page to select your Google account and to approve permissions for the Drive datasource.

The authenticated account will need to have access to the sheet for the datasource to work properly. Keep this in mind when using aliases to authenticate datasources.

3. The next step is to insert the Drive spreadsheet's url into the input box in this section.

If you would like to pull data from a specific sheet in Google Sheets, put the name of the sheet in the appropriate input box in the Additional Configuration section. If you do not input a sheet name it will default to the first sheet in the document.

Because of a limitation in the Google API, the sheet name must be fewer than 32 characters.

Define your Data

Defining your data for a Google Drive datasource is the same as a manual datasource outlined in this article.

JavaScript errors detected

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

If this problem persists, please contact our support.