Integrating with Google Sheets

Use the Google Sheets connector to import your spreadsheets into Drivetrain.

Prerequisites

Before connecting your Google account, ensure the following:

• You have Admin privileges in Drivetrain.

• Your Google account has access to the Sheets you want to import.

• You are signed into the same Google account in your browser that you’ll connect to Drivetrain.

• Your organization’s Google settings allow third-party app connections.

Setting Up the Integration

Step 1: Connect your Google Account

1. In Drivetrain, go to the Data page and click + to add a new connector.

2. Select Google Sheets from the list.

3. In the pop-up, click Connect Google Account.

4. Sign in to your Google account (or select it if already signed in).

5. Grant Drivetrain permission to access your Sheets and click Continue.

6. You’ll be redirected back to Drivetrain once the connection is successful.

Your Google account is now linked to Drivetrain.

Step 2: Import a Google Sheet

1. Open the Google Sheet you want to import.

2. Copy the URL of the sheet.

3. Back in Drivetrain, paste the sheet’s URL in the field provided and click Add.

4. Once added, the sheet will appear as a table in your data workspace.

Step 3: Add More Sheets

You can import additional sheets from the same Google account anytime.

1. Click Add data within the Google Sheets connector.

2. Paste another sheet’s URL.

3. Click Add.

Best Practices for Uploading Datasets

When importing a Google Sheet, Drivetrain automatically detects whether it’s a Transaction or Time series dataset. To ensure the upload completes successfully and the data is structured correctly, follow the format requirements below.

General requirements

These apply to all Google Sheets datasets:

• The table starts from cell A1.

• Row 1 contains clear, unique column headers.

• Column A is the first data column.

• Each sheet contains only one table.

• Supported date formats: YYYY-MM-DD, MM-DD-YYYY, YYYY/MM/DD, MM/DD/YYYY.

• The sheet must be accessible from the same Google account you connected to Drivetrain.

If your sheet is a Transaction dataset

Use this format when each row represents a record or event — for example, a deal, invoice, or journal entry.

• Each row corresponds to a unique transaction or record.

• Include all relevant columns for that record (such as dates, IDs, and status fields).

If your sheet is a Time series dataset

Use this format when your data tracks values across time periods — for example, ARR by month or sales by week.

• Each row corresponds to a unique entity (such as a customer, account, or region).

• The first column lists names or identifiers for each entity.

• Each time period (e.g., month) appears as a separate column.

• Use consistent, valid date headers for time columns.

• Drivetrain will automatically unpivot or flatten your data to make it suitable for analysis.

Syncing and Refresh

Once connected, your Google Sheets data is automatically synced with Drivetrain at regular intervals. You can also trigger a manual refresh at any time from the data workspace.

FAQ

Can I automatically refresh data from a Google Sheet?

Yes. Once a Google Sheet is connected, Drivetrain will sync it automatically at predefined intervals. You can also trigger a manual sync if you’ve updated the sheet recently.

Can I connect multiple Google Sheets?

Yes. You can connect multiple sheets from the same Google account by clicking Add data on the connector. See the exact steps here.

What if my Google Sheet dataset isn’t loading?

Check that:

• The sheet starts at cell A1 and has headers in the first row.

• It’s shared with the Drivetrain service account or has link access enabled.

• You’ve connected the same Google account that owns or can view the sheet.

• The sheet’s URL is accessible from your Drivetrain workspace.