Google Drive

Updated on Feb 24, 2026

Note: Google Drive is currently supported only as a Destination. This guide doesn’t cover the DataPrep setup for Google Drive.

Description

Google Drive is a file storage and synchronization service developed by Google. Google Drive allows users to store files in the cloud, synchronize files across devices, and share files.

Setup guide

Follow our setup guide to connect Google Drive to Improvado.

Authorize your Google account

On the Google Drive connection page, click on the Sign in with Google button and authorize your Google account.

Complete configuration

After the successful authorization with Google, you’ll be redirected to the Destination connection form:

Enter a name for your Destination connection in the Title.
Enter the Folder.

{%dropdown-bodyname="folder"%}

A forward slash (/) means that you need to enter the root path.

{%dropdown-end%}

Select the File format from the dropdown.
Enter the Filename.
(Optional) Enter the Shared Drive ID.

{%dropdown-bodyname="shared_drive"%}

You can find this ID in the URL when you're viewing the drive in your browser (drive.google.com/drive/u/0/your_drive_id).

{%dropdown-end%}

Select the Separator from the dropdown.
Select the Partition by from the dropdown.

Select the necessary Use binary strings option from the dropdown.

‍

Additional information

Folder

Possible parameters:/{{workspace_id}}/{{workspace_title}}/{{data_source}}/{{dataclass}}/{{data_table_title}}/{{report_type}}/{{filename}}/{{YYYY}}/{{MM}}/{{DD}}{{YYYY_today}}/{{MM_today}}/{{DD_today}}‍

File format

Possible formats:

csv
csv+gzip
json
json+gzip
parquet
avro

Filename

Possible parameters:{{data_source}}-{{report_type}}-{{data_table_title}}-{{filename}}-{{dataclass}}-{{YYYY}}-{{MM}}-{{DD}}-{{H}}-{{M}}-{{S}}-{{timestamp}}-{{chunk_id}}‍

{{filename}} - is the same as the destination table name

Important: you cannot use {{DD}} for partition by month

{{filename}}-{{YYYY}}-{{MM}}-{{DD}} – for partition by day
{{filename}}-{{YYYY}}-{{MM}} – for partition by month

Important

{{YYYY}}/{{MM}}/{{DD}} partitioning is based on a date field in the exported data. If the dataset does not contain an actual date field (for example, no “date” column/field), these partition values cannot be derived and date-based partitioning will not work as expected. In that case, use {{YYYY_today}}/{{MM_today}}/{{DD_today}} to partition by the export run date instead.

Note

{{YYYY}}/{{MM}}/{{DD}} refer to the record’s date-based partition values (if applicable), while {{YYYY_today}}/{{MM_today}}/{{DD_today}} always use today’s date.

‍

Also, you can use “_” instead of “-” or do not use any symbols at all, for example:

{{filename}}_{{YYYY}}-{{MM}}-{{DD}}
{{filename}}{{YYYY}}{{MM}}{{DD}}

Separator

Possible delimiters that can separate data in your file:

comma
semicolon
tab

Partition by

Possible ways of splitting data:

Day
Month

‍