Google Sheets integration

Google Sheets data, in your warehouse.

A built-in ingestr connector: add credentials, pick tables, schedule it.

name: raw.sheet1
type: ingestr
parameters:
  source_connection: google_sheets
  source_table: 'Sheet1'
  destination: snowflake
  incremental_strategy: merge

$ bruin run assets/raw/google_sheets.asset.yml

extract · Google Sheets Sheet1incremental
load · snowflake raw.Sheet1merged
checks · not_null, unique

Loaded and checked. Downstream models can run.

How it connects

Connected in three steps.

Google Sheets is a cloud-based spreadsheet application that can serve as a simple database.

01
Add a Google Sheets connection with its credentials.
02
Pick the tables to load and how: replace, append or merge.
03
Bruin runs it on your schedule and checks every load.

Connection parameters

credentials_path: Service account JSON file
spreadsheet_id: ID from sheet URL
sheet_name: Name of specific sheet tab

Every way Google Sheets works with Bruin

SourceBuilt-in ingestr sourceDocs →
DestinationBuilt-in ingestr destinationDocs →

Tables

4 tables, ready to load.

Sheet1
Data
Report
Import

Step-by-step

Pick a destination.

Google Sheets → Snowflake

Read the guide

Google Sheets → Google BigQuery

Read the guide

Google Sheets → Databricks

Read the guide

Google Sheets → Amazon Redshift

Read the guide

Google Sheets → PostgreSQL

Read the guide

Google Sheets → ClickHouse

Read the guide

Google Sheets → DuckDB

Read the guide

Google Sheets → MotherDuck

Read the guide

The platform

Part of the Bruin platform.

Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.

See the full platform

Sources

DatabasesWarehousesApps & APIsFiles & storageStreams & webhooksWeb scraping

Move

Data Ingestion

Model & govern

SQL & Python Data Quality Data Governance

Self-Healing Pipelines

Use

AI Data Analyst AI Dashboards Data Apps Scheduled Agents Reverse ETL

Bruin Cloud runs every step

Files & storage

More tools, same category.

All 27 Files & storage tools

Amazon S3 Built in Google Cloud Storage Built in Azure Blob Storage Built in Azure Data Lake Storage Built in SFTP Built in CSV files Built in Microsoft SharePoint Built in Google Drive Via API

Frequently asked

Questions about Google Sheets.

Does Bruin have a built-in Google Sheets integration?

Yes. Built-in ingestr source. Built-in ingestr destination.

Which Google Sheets tables can Bruin load?

Sheet1, Data, Report, Import.

Where can Google Sheets data go?

Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.

How fresh is the data?

As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.

Do we need Bruin Cloud?

No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.