Google Drive Connector

Sync structured files from Google Drive folders, or deliver pipeline output as CSV files, native Google Sheets, and Excel workbooks.

SourceDestinationSilver

Start for Free Source Documentation Destination Documentation

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

Supaflow vs Fivetran

Load Google Drive into Snowflake

Dedicated pages for destination-specific setup, buyer questions, and Snowflake sync behavior.

Google Drive to Snowflake

Sync CSV, TSV, Excel, and Google Sheets files from Drive into Snowflake.

View pipeline page

Google Sheets to Snowflake

Land every worksheet from Google Sheets as a Snowflake table with stable worksheet tracking.

View pipeline page

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

Managed, OAuth, and Service Account Authentication

Connect with a Supaflow-managed service account, Google OAuth, or your own GCP service account key. Folder sharing controls what Supaflow can read or write.

Source Reads for Files and Sheets

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. Every row records which file it came from.

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.

Spreadsheet and CSV Destination Writes

Write pipeline output as CSV files, native Google Sheets, or Excel workbooks. Choose one workbook per object or a shared pipeline workbook for spreadsheet output.

Supported Objects

Source 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.

Destination Output

CSV files

Append or replace CSV output in one Drive folder per destination object.

Google Sheets

Native in-place worksheets with append and truncate-and-load behavior.

Excel (.xlsx)

Excel workbooks updated in place in Google Drive.

How It Works

Choose an authentication method

Use the managed service account for the simplest setup, Google OAuth for a user-owned Drive workflow, or a GCP service account key when you manage the service account yourself.

Share the Drive folder

Grant read access for source syncs. For service-account destination writes, place the target folder in a Google Shared Drive and grant Content manager access or higher.

Configure the source or destination

For sources, select the file type and parsing settings. For destinations, provide the target folder URL, enable Allow Write Access, and choose CSV files, Google Sheets, or Excel output.

Test and save

Click Test & Save to verify Drive API access, folder sharing, and read or write permissions for the configured role.

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.

Spreadsheet delivery to business teams

Write curated pipeline output into shared Drive folders as Sheets, Excel, or CSV so finance, operations, and partner teams can work with familiar tools.

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.

Can Google Drive be used as a destination?

Yes. Supaflow writes CSV files, native Google Sheets, and Excel workbooks with append and truncate-and-load behavior. Service account destinations must use a Google Shared Drive with Content manager access or higher; OAuth can write to folders the authorizing user can edit.