Google Drive Setup Guide – Fivetran Support Portal

Follow our setup guide to connect Google Drive to Fivetran.

Prerequisiteslink

To connect Google Drive to Fivetran, you need:

In the connector setup form, enter the Destination schema name of your choice.
Enter your Folder URL. Make sure your URL looks similar to the one illustrated below and doesn’t have any extra characters after the folder ID. The URL specifies the folder path in your Google Drive in which you’d like Fivetran to look for files. We examine any files under the specified folder, except the nested subfolders, for files we can sync.
Find the auto-generated email address of the Fivetran service account and make a note of it. You will need it to share your Google Drive folder with Fivetran.

We create a Google service account for your Fivetran account because the service account authentication method provides fine-grained control over access to your data. You add the unique Fivetran service account as a read-only user to the specific folders that you want to sync.

NOTE: Make sure that the folder is not empty. We can’t sync empty folders.

Click the folder you want to sync and then click Share.
In the Share with people and groups window, enter the email address that you found in Step 1.
Select Viewer permissions and then click Send.

(Optional) Set a delimiter for your CSV files. The delimiter is a character used in CSV files to separate one field from the next. If you don’t set a delimiter, Fivetran will infer the delimiter for each file.
Click Save & Test. Fivetran will take it from here and sync your data from your Google Drive.