Data source

Google Sheets as a data source: load a tab into your data warehouse

Plans, targets and budgets live in a sheet because someone keeps them by hand.

  1. Open source. OWOX Data Marts is open source: you can read the code that loads and models your data, and run it yourself.
  2. You own the data. Google Sheets tables load into your data warehouse, under your account. If you leave OWOX, they stay where they are.
  3. MCP-ready. Once the data is in, Claude or ChatGPT can work from your Data Marts through OWOX MCP.

Hand this to your AI

Don't copy Google Sheets into your reports by hand. Have your AI assistant load it into your data warehouse.

Your assistant reads the sheet with you and loads it; OWOX keeps it in your data warehouse beside your actuals.

The prompt

set up Google Sheets as a source in OWOX Data Marts, load my plan sheet into my data warehouse and show me plan versus actual next to my other data

Why OWOX

Plan in a sheet, fact in your data warehouse

The fact is what your other sources load into your data warehouse: orders, revenue, ad spend. The plan is a sheet someone keeps by hand. Kept only in the sheet, the plan is correct in one place and missing in every other. Load the tab on a schedule and it becomes a table beside the fact.

  • Plan next to fact. Load the plan tab, say budget by month and channel, group the actual spend by month and channel, and plan versus fact is a join on those columns; spell and type the keys in the sheet the way the fact table does, or the join finds no match. The result can go back to a spreadsheet for the people who live there.
  • One tab, one table. Pick the spreadsheet and the tab, say which row holds the headers, and optionally limit the range. The headers become column names, and blank or duplicate headers get generated names instead of failing the load.
  • Sign in the way your team works. Sign in with OAuth to try it in minutes, or with a service account once the load runs unattended and must not depend on one person's Google account.
  • Text stays text. A value the sheet stores as text, such as a code with leading zeros, keeps its zeros, and numbers and booleans that the sheet stores natively get matching types.
  • Always the current tab. Every refresh reads the tab again in full, so the table follows the tab, and a tab left with only its headers loads as an empty table instead of leaving old rows behind.
  • Sized for hand-kept data. A refresh takes up to 100,000 data rows; narrow the range for a larger tab. The source is meant for goals, targets, plans and mappings, not for bulk data.

Where Google Sheets data goes

Recent updates

Other data sources

Trust

The Data Partner You Can Trust

users

166K Source: Internal OWOX data as of 2026-11-15

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers