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.
The analytics system teams actually use
Marketplace users
175K+
teams running OWOX from the Google Workspace Marketplace
G2 rating
4.9
296 verified reviews on G2
Connector downloads
156K+
open-source connector installs via npm
GitHub stars
231
the platform is open source — star it, fork it, self-host it
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
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
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
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
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 Looker Studio dashboards
Related connectors
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.
Nodari 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.”
Mark SimmonsCMO, Pürblack®“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
Nodari RizunFounder & CEO, Pürblack®“We regained time. And time is the one resource that never comes back.”