Google Drive
Vendor/Partner | |
|---|---|
Version | V3 |
API Documentation | |
Sunset Date | None listed as of 10/06/23 |
Channel(s) | |
Refresh Time (CST) | 3 am, 11 am, 2 pm, 6 pm, 9 pm / Real Time |
Default backfill | N/A |
Alli Data Library |
|
Getting Started
Google Drive datasources require a Google account with access to Google Drive.
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.