Collect Google Sheets data into your warehouse

Each connector imports one spreadsheet tab into a table in your storage. It is meant for data people maintain by hand, such as goals, targets, plans and mappings.

• The header row becomes the column names. It is row 1 by default, and you can point to another row.
• A column name is cleaned to lowercase letters, digits and underscores. A blank header gets a generated name such as column_2.
• Every row carries _owox_row_number, the only unique key. You can add _owox_imported_at to the selected fields.
• By default the connector imports all columns, including ones added later. You can switch that off and choose columns.
• Types are inferred only from native numbers and booleans. Text such as 00123 or 2026-01-01 stays a string, and you can turn inference off so every column is a string.

Authentication is either OAuth or a service account. OAuth is the quick way to start. A service account keeps scheduled imports independent of any one person’s Google account. To start:

1. Add a storage to receive the data: Google BigQuery, Snowflake, AWS Redshift, AWS Athena or Databricks.
2. Create a Connector Data Mart, choose Google Sheets and select the spreadsheet and the tab.
3. Publish the Data Mart and run it for the first import.
4. Add a Connector Trigger to schedule recurring imports.

Every run is a full refresh, not an append. A sheet can have up to 100,000 data rows per refresh, and for a larger sheet the range setting imports part of it. A sheet with only a header row loads zero rows and clears the previous data. The connector documentation has the full setup guide.

Once the tab is in your warehouse, it behaves like any other table you own.

• Compare a targets tab with actual revenue in one Data Mart.
• Join a mapping tab, such as campaign names to channels, to your ad data.
• Add manual costs to a spend report without pasting them into every file.
• Keep the SQL behind each number one click away.

The sheet stays the place where people edit the numbers, and the warehouse holds the version every report reads.

A Report delivers one Data Mart to one destination, and each Data Mart can feed many destinations.

• Push mode: OWOX writes the data on a manual or scheduled run. Google Sheets, email, Slack, Microsoft Teams and Google Chat work this way.
• Pull mode: the tool asks OWOX for the data when a user refreshes it. Data Studio and Microsoft Excel work this way.
• AI assistants such as Claude and ChatGPT read the Data Mart, not the raw tables, so answers use your definitions.