Connector

Enable business reporting from your Google BigQuery data

Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Google Sheets.

Google BigQueryConnected
Data MartPublishedone definition
Google SheetsDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

S01 · Step 1

Start from your Google BigQuery data

Connect your BigQuery project and pick the dataset that holds the data your sheets need.

  • Nothing to move or copy.
Google BigQueryYour data warehouseDataset
Unified Ad SpendConnected dataNothing to move or copy

S02 · Step 2

Build a reporting library in Google BigQuery

Each Data Mart is a ready report, described by AI, and joins to other Data Marts through the data model.

  • Business users browse reports, not tables.
Data martsUnified Ad SpendAISessionsAI
Unified Ad SpendData modelplatform_roas · platform_cpa
Unified Ad Spend + Sessions
SessionsJoined by a shared key

S03 · Step 3

Send Google BigQuery data to Google Sheets

Push a report from the OWOX UI, or pull it with the Sheets extension. Header notes explain every column.

  • Reports stay fresh, with no exports.
OWOXRun reportScheduled
ExtensionRefresh
Google SheetsNotes in headerscostInUsdclicksimpressions

S04 · Step 4

Keep Google Sheets connected to the same data

Ask in Claude, export to a sheet, share with the boss.

  • One source, every tool.
Unified Ad SpendOne source
ClaudeAsk in chat
Google SheetsExport to a sheet
Your bossShare the answer

Recent updates

Why OWOX

Why OWOX for Google BigQuery reporting

Spreadsheets stay the place where your team works, and the numbers come from BigQuery through a Data Mart instead of a pasted export.

  • You own the data. It lives in your own BigQuery project, not inside an ad platform or a CRM.
  • Your own columns survive. A refresh rewrites the imported range only; columns and formulas you added to the right of it stay.
  • Every refresh says where it came from. The first column carries the Data Mart name, the latest refresh time and a link to the report that writes the range.
  • Header notes explain each column. Each imported header carries the description from the output schema of the Data Mart.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

176K Source: Internal OWOX data as of 2026-10-02

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