Connector
Turn Snowflake into a Live Reporting System for Google Sheets
OWOX Data Marts lets you manage, schedule, and reuse reporting-ready data marts built on Snowflake — and deliver them as live, governed reports in Google Sheets. This is not an export. It’s a 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 Snowflake Data Storage
Start by connecting a data storage where your Snowflake data will be prepared for Google Sheets.
- Choose a supported data warehouse such as BigQuery, Snowflake or Redshift
- Store your Snowflake query results in one central place
- Keep full ownership and control over your data
S02 · Step 2
Step 2: Create Snowflake Data Mart
Click on + New Data Mart, choose SQL as the definition type.
- Write a SQL query that selects the Snowflake data you need
- Use joins, filters, and transformations to prepare the dataset
- Define the output table where the result will be stored
S03 · Step 3
Step 3: Publish & Configure Google Sheets Destination
Once your data mart is ready, enable Google Sheets as a destination.
- Add Google Sheets as a Destination
- Then just tick the box in the Destinations section of a data mart
- Your data mart results will appear in a linked Google Sheet
S04 · Step 4
Step 4: Run & Schedule Data Delivery to Sheets
Control how and when Snowflake data is refreshed in Google Sheets.
- Run manually to check the output before scheduling
- Add a Trigger to automate data delivery on a schedule
- All runs are logged and visible in Run History
S05 · Step 5
Step 5: Go Beyond Google Sheets
Your Snowflake data is now available in Google Sheets. But why stop here?
- Use the same data mart in Looker Studio
- Blend Snowflake data with other sources like GA4 or ad platforms
- Enable AI Insights delivered to Slack, Teams, or Email
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.”