Google Sheets Extension

Your analyst shouldn't be your export button.

OWOX Data Marts lets analysts define the data rules once — and business users pick exactly the columns they need, directly in Google Sheets. No tickets. No waiting. No SQL.

Get Started Free
Play yourself
Request a demo
Column picker UI available in 2 weeks. Start building your data marts library today.
The Opportunity

You Built Great Reports in Google Sheets. But You're Hitting the Ceiling.

Your Extension Data Marts work — they query BigQuery and push data to Sheets on schedule. But as your team grows, so do the gaps:

  • 🔍
    Not enough visibility
    You can't tell when a Data Mart last ran or why it failed.
  • 📤
    No way to re-use beyond Sheets
    No Looker Studio, no email digests, no Slack alerts...
  • 🗂️
    No centralized data mart management
    Scheduling, setup & access live in individual spreadsheets.
  • 🧠
    No Insights layer (AI & deterministic)
    You stare at tables, but nothing surfaces what changed or why.

OWOX Data Marts closes every one of these gaps — and auto-detects the Data Marts you already have.

Reuse SQL queries
Simplify your data stack
The Setup

Live in 3 Steps. No Migration Required.

Your existing SQLs, reports & refresh schedules stays untouched. OWOX allows you to re-use what's already there.

1

Select Your Storage

OWOX migrated your data marts together with GCP project. Just find it in the Storages tab — it's already there, named after your project ID.

2

Grant BigQuery Access

Just click connect with Google or paste your Service Account JSON. Choose auto-detect location and click Save. That's it.

3

Publish Your Data Marts

Your Extension Data Marts appear as Drafts. Open the three-dot menu, hit "Publish drafts" — and they're live with the full platform is unlocked.

Unlock My Existing Data Marts
Request a demo
AI Insights

Stop Staring at Tables. Get Answers Instead.

OWOX automatically suggests AI insight prompts for each published Data Mart based on its schema and output. Run them right in the interface to get a plain-language summary of what's in your data — or schedule them for regular delivery. No extra pipeline, no BI tool required.

Learn more about Insights →
Simplify your data stack
Simplify your data stack
Insights

Send Reports to Chats or Inbox

Add slack, MS teams or email destination for Insights, pick your recipients, set a schedule — daily, weekly, or monthly.

Then just control what you get with prompts & template.

OWOX then does all the dirty job for you, write SQL, run, analyze, format results, and delivers them by email.

Stakeholders get insights complimentary to a google sheets report.

See how email reports work →
Looker Studio

Power Live Dashboards with the Same SQL You Already Wrote

Enable the Looker Studio toggle on any Data Mart. Connect using the OWOX connector and a JSON config token. Unlike Sheets (push mode, static between runs), Looker Studio pulls live data from BigQuery every time the report opens.

Connect to Looker Studio →
Simplify your data stack
Supported Ad & Data Platforms
Facebook Ads
Google Ads
Linkedin Ads
tiktok ads
TikTok Ads
Microsoft Ads
Reddit Ads Connector
Reddit Ads
Shopify
Ecommerce
Raw API data → BigQuery → Reports in Spreadsheets
Connectors

3rd-Party Platform Data in BigQuery by Your Rules

Introducing - connector-based Data Marts so you can pull raw data from ad platforms (and other sources) directly into BigQuery on a schedule. Add that to your existing SQL Data Marts for cross-channel or performance reporting, or CAC modeling, or attribution - no extra tools needed.

Collect 3rd party data →
Scheduling

One Place to Manage Schedules & Accesses

When the person who saves a SQL Query leaves – whether that's an analyst or a business user – their Google credentials leave with them.

Reports stop refreshing.
Nobody notices until somebody asks where is the fresh data.

OWOX Data Marts moves all triggers and credentials to the organization level. Schedules are managed centrally, not buried in individual spreadsheets or tied to personal accounts.

Manage schedules in one place →
Simplify your data stack
Extension Alone vs. Extension + Data Marts

Extension Alone vs. Extension + Data Marts

Everything you already have, plus everything you've been missing.

CapabilityCapabilityExtension OnlyExtensionExtension + OWOX Data MartsExtension + ODM
SQL-based Data Marts in BigQuery✓✓
Push data to Google Sheets✓✓
Centralized scheduling & access management—✓
Full run history & error logs—✓
AI-powered Insights—✓
Email report delivery—✓
Looker Studio dashboards—✓
Slack / MS Teams / Google Chat / Email alerts—✓
Ad platform connectors—✓
Table-, view- & pattern-based Data Marts—✓
Snowflake, Redshift, Databricks & more dwhs—✓
Zero Risk

Full Backward Compatibility

You're not replacing the Extension. You're giving it an extra layer.
🛡️

Nothing Breaks

Your Extension Data Marts keep running exactly as they do today. OWOX reads your existing definitions — it doesn't replace them.

🔄

Bidirectional Sync

Data Marts stay linked between the Extension and the web app. Changes in one reflect in the other automatically.

🆓

Free to Start

Connect your storages and publish your Data Marts at no cost. Pay only when you scale beyond the free tier.

How Smart Teams Use OWOX

We've added 127 slack insights to our spreadsheet reports. The CMO is so happy with that Monday morning digest .

Head of Data,
SaaS Company

We manage 46 Data Marts from a single place now. Run history alone saved us hours of figuring our whether report was updated or not.

Head of Analytics,
Retail

We connect AWS Athena to Looker Studio for live dashboards. This is the only available connector that just works.

BI Lead,
E-commerce

Frequently Asked Questions

Will this break my existing Extension setup?
Do I need to rewrite my SQL?
Is there an extra cost?
What happens if I delete a Data Mart in OWOX Data Marts?
Can I create new Data Marts in OWOX Data Marts?
What destinations are supported?
You're 80% there already

Your Data Marts Are Already Waiting

OWOX has auto-created all your Extension Data Marts. Connect your storage, publish, and unlock the full platform in under 3 minutes.

Open OWOX Data Marts
Request a demo