Google Drive
Vendor/Partner | |
|---|---|
Version | V3 |
API Documentation | |
Sunset Date | None listed as of 07/03/2024 |
Channel(s) | All |
Refresh Time (CST) | 3 am, 11 am, 2 pm, 6 pm, 9 pm / Real Time |
Default backfill | N/A |
Alli Data Library |
|
This datasource will return “This file is too large to be exported.” If the total size of the spreadsheet is beyond what Google will return via the API. Even when only requesting a single sheet, the entire size of the workbook is the determining factor.
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
Why do I see duplicate rows in Alli compared to my actual Google Sheet?
The default uploading mechanism for Alli datasources is Add and update. As a result, Alli may be recognizing the existing Google Sheet rows as new rows and adding them to what already exists in Alli. If you’d prefer that Alli matches your Google Sheet exactly:
Go to the Advanced Settings section of the datasource setup page
Under the New Uploads, select Replace
Click Save
Click Load Data to overwrite what currently exists in Alli with exactly what is in your Google Sheet