Google Drive Connector

Sync structured data from CSV, TSV, Excel (.xlsx), and Google Sheets files stored in Google Drive folders. Supports OAuth and GCP Service Account authentication with automatic schema inference.

SourceBronze

Start Free View Documentation

Why Supaflow

All connectors included

No per-connector fees. Every connector is available on every plan.

Pay for compute, not rows

Credit-based pricing. No per-row charges, no MAR surprises.

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.