Integrating with Google Sheets

Prerequisites

Drivetrain Setup Step 1: Connect your Google Account Step 2: Import Sheet to Drivetrain Step 3: Add more Sheets to Drivetrain

FAQs

Prerequisites

• The table you want to import should start from the first cell (A1) on the sheet

• None of the column headers should be empty

• There should only be one table per sheet

• Admin privileges in Drivetrain

Drivetrain Setup

Step 1: Connect your Google Account

1. Click on + New Data Source

1. Select the Google Sheets Data Connector from the list of integrations by clicking +Connect

1. On the pop-up, click Connect Google Account

1. You will be redirected to the Google login page

2. If you're not signed into Google, do that now, then select the account from which you want to import the data If you are already signed in, simply select the account from which you want to import the data.

1. Or select the account from which you want to upload the sheet if you are already signed in

1. Give Drivetrain permission to access your data by clicking Continue

1. You will be redirected back to the Drivetrain Connected Integrations page which will ask you to paste the URL of the sheet you want to import

Step 2: Import Sheet to Drivetrain

1. Open Google Sheets and navigate to the sheet you want to import

2. Copy the URL of the sheet which needs to be imported

1. Paste your Google Sheet Link into the field provided and click Add

1. The sheet you added will now show up in the list of tables on Drivetrain!

Step 3: Add more Sheets to Drivetrain

You can add more tables by using the Add data option as shown below.

FAQ

Can I load/refresh data from a Google Sheet (Gsheet)?

Yes, you can connect your Google Sheet to Drivetrain. It'll be synced (i.e, refreshed) with the changes at predefined intervals. Alternatively, you can also trigger a manual sync. Refer to the Integrating with Google Sheets guide for more details.