Google Drive Connector

Sync CSV, TSV, Excel, and Google Sheets files from Google Drive folders with OAuth or GCP Service Account authentication and schema inference.

SourceBronze

Start Free View Documentation

Evaluating against Fivetran? See how Supaflow handles Google Drive pricing, connector quality, and Snowflake deployment side-by-side.

Supaflow vs Fivetran

Why Supaflow

All connectors included

Every connector is available on every plan. Pricing does not increase with connector count.

Pay for compute, not rows

Credit-based pricing. Usage scales with your pipelines, not with row counts.

One platform

Ingestion, dbt Core transformation, reverse ETL, and orchestration in a single workspace.

Capabilities

OAuth and Service Account Authentication

Connect via Google OAuth for personal/workspace accounts, or a GCP Service Account with a JSON key file. The service account must be shared as Viewer on the target Drive folder.

Multiple File Type Support

Reads CSV, TSV, Excel (.xlsx), and Google Sheets files. For CSV/TSV, each folder becomes a table with rows from all files combined. For Excel and Sheets, each worksheet becomes a separate table.

Automatic Schema Inference

Infers column types from file content. For CSV/TSV, files in the same folder can have different columns -- Supaflow unions them and fills missing values with null. System fields (_supa_file_name, _supa_file_id) are added to every row.

Incremental Sync via File Modification Time

Uses Google Drive modifiedTime metadata to detect changed files. After the initial full sync, only files modified since the last sync are re-read. Configurable lookback window catches late-modified files.

Supported Objects

File Types

CSV

Comma-separated values files. Configurable delimiter, quote character, encoding, and header settings.

TSV

Tab-separated values files. Tab delimiter is applied automatically.

Excel (.xlsx)

Excel workbooks. Each worksheet becomes a table. Files over 50 MB are skipped.

Google Sheets

Native Google Sheets. Each worksheet becomes a table. Exported to xlsx for processing.

How It Works

Prepare Google Cloud credentials

For Service Account: Create a GCP project, enable the Google Drive API (and Sheets API if syncing Google Sheets), create a service account, and download the JSON key file. Share the Drive folder with the service account email as Viewer.

Configure the source in Supaflow

Select OAuth or Service Account authentication. Provide the Google Drive folder URL (or folder ID) and select the file type (CSV, TSV, EXCEL, or GOOGLE_SHEETS). Configure CSV-specific settings like delimiter and encoding if needed.

Test and save

Click Test & Save to verify that Supaflow can access the Drive API and read the configured folder. Supaflow discovers files and infers table schemas from the content.

Use Cases

Spreadsheet data warehousing

Load CSV or Excel files from shared Drive folders into your warehouse on a schedule, replacing manual file-based imports and ad hoc uploads.

Google Sheets as a data source

Sync Google Sheets used by business teams into your warehouse so analysts can join sheet data with CRM, marketing, and transactional data using SQL.

Multi-file aggregation

Combine multiple CSV files in a folder into a single warehouse table. Useful when data arrives as daily or weekly file drops into a Drive folder.

Frequently Asked Questions

How are folders and files mapped to tables?

For CSV/TSV, each folder becomes a table and all files within it are combined. For Excel and Google Sheets, each worksheet becomes a table named as filename_worksheetname. Table names are normalized to lowercase with underscores.

What happens if CSV files in the same folder have different columns?

Supaflow unions all discovered columns across files and fills missing values with null. This allows files with slightly different schemas to be combined into one table.

Is there a file size limit?

Excel files larger than 50 MB are skipped with a warning. Google Sheets exceeding Google export limits (approximately 10 MB) are also skipped.