Skip to main content
Skip table of contents

Google Drive

Overview

Google Sheets, as part of Google Drive, is a cloud-based spreadsheet application that allows users to create, edit, and collaborate on spreadsheets in real-time, offering a user-friendly interface for data organization and analysis.

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 10/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

(error)

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 (Sheet Tab)

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:

  1. Go to the Advanced Settings section of the datasource setup page

  2. Under the New Uploads, select Replace

  3. Click Save

  4. Click Load Data to overwrite what currently exists in Alli with exactly what is in your Google Sheet

JavaScript errors detected

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

If this problem persists, please contact our support.