Connector

Turn Google BigQuery into a Live Reporting System for Google Sheets

OWOX Data Marts lets you manage, schedule, and reuse reporting-ready data marts built on Google BigQuery — and deliver them as live, governed reports in Google Sheets. This is not Connected Sheets. It’s a full reporting system.

Get Started Free

S01 · Step 1

Step 1: Connect Your Google BigQuery Data Storage

Start by using Google BigQuery as the single foundation for business reporting.

  • All reporting data lives inside your BigQuery project
  • No direct source-to-spreadsheet connectors that fragment logic
  • Business logic stays centralized, queryable, and reusable

Connect BigQuery

Step 1: Connect Your Google BigQuery Data Storage

S02 · Step 2

Step 2: Create a Data Mart in Google BigQuery

Create reporting-ready data marts directly on top of Google BigQuery.

  • Define data marts using SQL queries
  • Reuse existing BigQuery tables or views
  • Include connector-based datasets already stored in BigQuery

Create Data Mart

Step 2: Create a Data Mart in Google BigQuery

S03 · Step 3

Step 3: Prepare Business-Friendly Data for Google Sheets

Make your BigQuery data marts easy for business users to work with.

  • Rename fields using business-friendly aliases
  • Add clear descriptions to explain metrics and dimensions
  • Control which fields are exposed to stakeholders

Tweak Output Schema

Step 3: Prepare Business-Friendly Data for Google Sheets

S04 · Step 4

Step 4: Send & Schedule BigQuery Data to Google Sheets

Deliver Gold-layer, business-ready data from BigQuery directly into Google Sheets.

  • Keep Sheets connected to governed BigQuery data marts
  • Schedule automatic refreshes with full orchestration
  • Share spreadsheets with stakeholders without duplicating logic

Send to Google Sheets

Step 4: Send & Schedule BigQuery Data to Google Sheets

S05 · Step 5

Step 5: Reuse BigQuery Data Beyond Sheets

Your BigQuery data marts are not limited to spreadsheets.

  • Enable AI Insights generated from BigQuery data marts
  • Deliver insights to Email first (and add Slack, Microsoft Teams, or Google Chat if your team uses them)
  • Reuse the same data marts in Data Studio dashboards

Reuse Data Marts

Step 5: Reuse BigQuery Data Beyond Sheets

What users are saying

Every claim has a receipt.

Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.

A3re: trusting AI
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”
C9re: one source of truth
Mark SimmonsMark SimmonsCMO, Pürblack®
“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
E7re: getting time back
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“We regained time. And time is the one resource that never comes back.”

Build a Reporting System on Top of Google BigQuery

OWOX Data Marts helps teams turn Google BigQuery into a governed, reusable reporting system — with Google Sheets as one of many ways to deliver trusted data to the business.

Get Started Free

Trust

Data Partner You Can Trust

users

176K1

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

165K3

In Open Source We Trust

Customers

References

  1. Internal OWOX data as of 2026-10-02
  2. G2 reviews of OWOX
  3. npm installs stat