---
title: "Reddit Ads to Google Sheets with OWOX Data Marts"
canonical: "https://www.owox.com/blog/articles/free-reddit-to-google-sheets-connector"
updated: "2026-09-30"
---

# How to connect Reddit Ads to Google Sheets with OWOX Data Marts

There is no direct Reddit Ads to Google Sheets connector any more. The route that holds up is Reddit Ads, then a data warehouse, then Sheets – and OWOX Data Marts runs all of it.

[Data Integration](/blog/topics/data-integration) · Updated September 30, 2026 · [Vadym Kramarenko](/team/vadym-kramarenko) · 11 min read

![How to connect Reddit Ads to Google Sheets with OWOX Data Marts](https://cdn.owox.ai/www/webflow/697f591a33cbc9bff62dfb81_Reddit-to-GoogleSheets.png/public)

If you’ve tried to export Reddit Ads data to Google Sheets by hand, you know the pain: **CSV downloads, a reporting view you can’t reshape and no history you control**.

The route that holds up is not a direct pipe from Reddit Ads into a sheet. It is Reddit Ads, then a **data warehouse**, then Google Sheets. [OWOX Data Marts](https://www.owox.com/app-signup) runs that whole path: a Reddit Ads data mart loads your ad data into your data warehouse, and Google Sheets reads it from there – through a report, or through the OWOX Data Marts extension. The quickest start is OWOX Cloud, but you can also run OWOX Data Marts yourself as free open source.

## Why we made this free connector

At OWOX, we’ve always believed that businesses shouldn’t have to rent their own data. So the Reddit Ads connector is **free and open source**: run OWOX Data Marts yourself and there is no paid tier and no hidden features. The longer story is in [why we built free data connectors for analysts](https://www.owox.com/blog/articles/free-open-source-connectors-for-analysts).

### Join the open-source movement

We’re not just releasing a free connector – **we’re inviting you to help shape the future** of open [marketing analytics](https://www.owox.com/blog/articles/what-is-marketing-analytics) tools.

At OWOX, we believe that **data access and transparency should be a right, not a luxury**. That’s why this connector is **100% open-source** – giving you **full control** over how it works, what it does, and how far it can go.

> **If you like what we do, please ⭐ star our** [**GitHub repo**](https://github.com/OWOX/owox-data-marts) **to show your support – it helps us reach more analysts and grow the number of available connectors.**

Also, feel free to:

*   **[Explore the code](https://github.com/OWOX/owox-data-marts)** and customize it to fit your needs.
*   **Contribute to this data connectivity ecosystem**: suggest new connectors, pull new connectors, and/or provide documentation to support the wider community.
*   **Join our community** and share your feedback.

We’ve built the core, the foundation – now it’s your turn to take it further.

## Why bring Reddit Ads data into Google Sheets?

Reddit Ads Manager reports are fine for a quick look, and hard to bend once you need them next to other channels:

*   **Custom reports your way:** reshape Reddit Ads data to fit your reporting, not the platform’s.
*   **Side by side with other paid channels:** blend Reddit performance with [CRM](https://www.owox.com/blog/articles/crm-and-online-data-integration-guide), [GA4](https://www.owox.com/blog/articles/an-in-depth-look-at-google-analytics-4) or offline conversions.
*   **Automated [dashboards](https://www.owox.com/blog/articles/dashboard-dreams)** and live insights your team can share, instead of manual exports.

Sheets is where marketers want to work, and that part is right. The open question is where the data should **live** while they do.

## The Turning Point

OWOX Data Marts

See your first report built in real time. _15 minutes._

1.  Connect your data warehouse
2.  Pick your metrics
3.  Get a live Google Sheets report

In the time it takes to write a ticket. Then imagine never writing that ticket again.

[Book a Demo](https://www.owox.com/demo)

We'll use your actual use case

## Why the data goes through a data warehouse

A sheet is where people **read** data, not where it should **live**. That is why OWOX Data Marts puts a data warehouse in the middle, and why there is no direct Reddit Ads-to-sheet connector. Four things follow.

### The sheet has a ceiling

A Google Sheets file holds at most **10 million cells**. Ad data eats cells quietly: every ad, every day and every breakdown is a row, and every field you pull is a column, so a wide import burns through the limit faster than the row count suggests.

The data warehouse holds the full history, while the sheet report holds only the columns you choose. A backfill loads a custom date range once, and a trigger keeps the data fresh afterwards.

### History outlives the sheet

Data loaded into a data warehouse stays there. A tab that gets overwritten, a sheet someone re-copies or an upstream API that changes its schema does not take last year’s numbers with it. That continuity is what campaign-over-campaign and year-on-year questions depend on.

### Reddit is rarely the only paid channel

The moment the question is “is Reddit worth it next to the other channels?”, Reddit data alone is not enough, and blending tabs in a sheet means lookup formulas that break when a campaign is renamed.

OWOX’s demo e-commerce project shows the alternative. Each ad platform is collected by its own connector data mart, and Reddit Ads is one of them.

A separate data mart, **Unified Ad Spend**, brings the platforms together. The analyst who owns it wrote the SQL: one `SELECT` per platform, all `UNION ALL`ed to one daily grain with a shared source, medium and campaign naming. Here is its Reddit Ads block. It divides Reddit’s spend by 100,000 to get currency units, labels the source `reddit`, and adds click-through and view-through purchases into one conversions column, with a comment saying why:

![Data Setup of the Unified Ad Spend data mart in OWOX Data Marts, scrolled to the analyst-written SQL block for Reddit Ads that converts spend, labels the source reddit and sums click-through and view-through purchases – Reddit is one input among the platforms unified in SQL](https://cdn.owox.ai/www/content-marketing-article/free-reddit-to-google-sheets-connector/screens/1.png/public)

OWOX Data Marts does not model the data for you. It publishes and governs the query the analyst wrote, so everyone reads the same definition.

### One number, every place you read it

The same data mart can feed a Google Sheets report, a Looker Studio dashboard, a Slack channel or an email, so the number in the sheet is the number in the dashboard. Business users read it without needing data warehouse credentials.

![Destinations in OWOX Data Marts listing Google Sheets, Slack, Email and Looker Studio – one governed data mart delivered to every place the team already reads](https://cdn.owox.ai/www/content-marketing-article/free-reddit-to-google-sheets-connector/screens/2.png/public)

## How it works

1.  **A Reddit Ads [data mart](https://www.owox.com/features/data-mart-management)** of the Connector type loads your ad data into tables in your data warehouse. A manual run backfills history, and a trigger keeps it fresh.
2.  **Google Sheets is connected as a destination.** The data mart publishes its data there.
3.  **You read it in Sheets** with a report created on the data mart, or by pulling it with the OWOX Data Marts extension inside Google Sheets.
4.  **Or you just ask.** Through OWOX MCP you can blend the same data with other Reddit Ads endpoints, other ad platforms, or your CRM and GA4 data, using the data model.

OWOX Data Marts does not transform your data. It loads, publishes and governs it, and any SQL on top is written by an analyst.

## What you need

*   **A Reddit Ads account** and its **Account ID**.
*   **Reddit app credentials:** an App ID, a Secret, a Redirect URI, a Refresh Token and a User-Agent string.
*   **A data warehouse.** OWOX Data Marts supports BigQuery, Snowflake, Databricks, AWS Athena and AWS Redshift. The examples here use BigQuery.
*   **OWOX Data Marts:** OWOX Cloud for the quickest start, or self-managed with Node.js and the OWOX CLI (free and open source).
*   **A Google account** for the Google Sheets report.

## Step-by-step: send Reddit Ads data to Google Sheets

Seven steps. The first five load your Reddit Ads data into your data warehouse. The last two bring it into Google Sheets.

### Step 1: Start OWOX Data Marts ( ~2 min)

Choose how to run it:

*   **OWOX Cloud:** [sign in or sign up](https://www.owox.com/app-signup) and you are ready for step 2.

*   **Self-managed (open source):** install Node.js 22.22.0 or later, then run:

    ```
    npm install -g owox
    owox serve
    ```

    Open `http://localhost:3000` and you are in. The [OWOX docs](https://docs.owox.com) cover deployment options beyond a local machine.

### Step 2: Connect your data warehouse ( ~3 min)

Open **Storages** in the left menu and add your data warehouse, for example [BigQuery](https://www.owox.com/data-storages/google-bigquery). This is where the Reddit Ads tables will be created. The BigQuery walkthrough, including the service account, is in the [Reddit Ads → BigQuery guide](https://www.owox.com/blog/articles/free-reddit-to-bigquery-connector).

### Step 3: Create the Reddit Ads data mart ( ~5 min)

1.  Click **New Data Mart**, give it a title and select the data warehouse from step 2.
2.  Set the type to **Connector** and choose **Reddit Ads** (the [Reddit Ads data source](https://www.owox.com/data-sources/reddit)).
3.  Add your **Account ID**: in Reddit Ads Manager, open the account selector and copy the ad account ID.
4.  Add the Reddit app credentials: **App ID**, **Secret**, **Redirect URI**, **Refresh Token** and **User-Agent**. The next section shows where each one comes from.

#### Get your Reddit credentials

**1\. Create a Reddit app**

*   Open your Reddit [app preferences](https://www.reddit.com/prefs/apps) and click **are you a developer? create an app**.

![Reddit Preferences page with “create an app” button highlighted under the Apps tab.](https://cdn.owox.ai/www/webflow/686bac3a06b6bd95451209f2_AD_4nXdhf4qKyZjDjTwksOkHdiSOLzeW-FRBG6ZK1M8_xYZQ6Bxw4fTTExs1HykEhsozPLUc0bhD7fXpeqdGxf3d1IhuVaeyBvkFt4V-Vq3CAo6ZqVL1YmvzFI60qtOlIsh0Fx1u3XwwIg.png/public)

*   Give the app a name, choose the **script** type and set the **Redirect URI** to the address of the apps page, shown below on two lines (it is one address, so join them). Click **create app**.

    ```
    https://www.reddit.com
    /prefs/apps
    ```

*   On the app card, the string under the app name is the **App ID** and the **secret** field is the **Secret**. Copy both and keep them private.

**2\. Get a refresh token**

*   Authorize the app in your browser with the scope `adsread`, and ask for a permanent token. Reddit access tokens last one hour, while the refresh token does not expire, so the connector only needs the refresh token.
*   Exchange the authorization code for tokens with Reddit’s token endpoint and copy the **refresh\_token** from the response.

**3\. Set the User-Agent**

*   Reddit asks every API client to identify itself. Use a string in this shape, with your own Reddit username:

    ```
    googleapps:owox-data-marts
    .redditads:v1.0.0
    (by /u/your_reddit_username)
    ```

    It is one line: join the first two parts with no space and keep the single space before `(by`.

### Step 4: Choose what to load and backfill your history ( ~3 min)

1.  Select the **endpoint** and the **fields** you need, for example spend, clicks, impressions and conversions.
2.  Set the dataset, or keep the default.
3.  Click **Publish Data Mart**.
4.  Click **Manual Run** and choose **Backfill** for the first run. Add the start and end dates and click **Run**. This puts your historical Reddit Ads data into the data warehouse.
5.  Open **Run History** and check for **Success**.

### Step 5: Schedule the refresh ( ~1 min)

1.  Open the **Triggers** tab of the data mart and click **Add Trigger**.
2.  Choose **Connector Run** as the trigger type, then set daily, weekly, monthly or interval, plus the time, days and time zone.
3.  Click **Create Trigger**. Reddit Ads data now refreshes on its own.

### Step 6: Connect Google Sheets as a destination ( ~2 min)

Open **Destinations** in the left menu, click **New Destination** and choose **Google Sheets** (more on the [Google Sheets destination](https://www.owox.com/data-destination/google-sheets)). A destination is where a data mart can deliver its data; the same list also holds [Looker Studio](https://www.owox.com/data-destination/looker-studio), [Slack](https://www.owox.com/data-destination/slack) and email.

### Step 7: Bring the data into Google Sheets ( ~2 min)

You have two ways to read the data mart in Sheets. Both are part of [spreadsheet reporting](https://www.owox.com/features/spreadsheet-reporting) in OWOX Data Marts.

**Option A: a report on the data mart.** Reports live on the **Destinations** tab.

1.  Open the data mart, go to the **Destinations** tab and click **New Report** under your Google Sheets destination.
2.  Give the report a title and share the Google document with the address the form shows.
3.  Paste the URL of your Google Sheet, or click **New Sheet** to create one.
4.  Choose the report columns you want in the sheet.
5.  Click **Create & Run report**.

![The Create new report form in OWOX Data Marts for a Google Sheets destination, with a document link or New Sheet, selectable report columns and the Create & Run report button – how a data mart becomes a sheet](https://cdn.owox.ai/www/content-marketing-article/free-reddit-to-google-sheets-connector/screens/3.png/public)

Each report is listed on the Destinations tab with its last run and status. Run it again whenever you need fresh data, or put it on a schedule with a report trigger.

![Google Sheets reports listed on the Destinations tab of a data mart in OWOX Data Marts with last run date and a success status – every sheet is a governed report on one data mart](https://cdn.owox.ai/www/content-marketing-article/free-reddit-to-google-sheets-connector/screens/4.png/public)

**Option B: the OWOX Data Marts extension.** Install [OWOX Data Marts from the Google Workspace Marketplace](https://workspace.google.com/marketplace/app/owox_data_marts/94902851409), open it inside Google Sheets and pull the data mart from there, without leaving the sheet. If your team works in Excel, there is an [OWOX Excel add-in](https://marketplace.microsoft.com/en-us/product/WA200011946) too.

## Ask the blended question in plain language

Reddit Ads data rarely answers a question on its own. With [OWOX MCP](https://www.owox.com/features/mcp) you can blend it with other Reddit Ads endpoints, with other ad platforms, or with your [CRM data](https://www.owox.com/blog/articles/unifying-ad-spend-crm-data-cac-report) and [GA4 data](https://www.owox.com/blog/articles/blend-ga4-conversions-with-ad-spend) (GA4 through its native BigQuery export), using the data model, and ask for all of it in plain language.

Once ad spend is a governed data mart, nobody has to write the join to ask about it. Connect Claude to OWOX Data Marts with the [OWOX Claude connector](https://claude.ai/directory/owox-data-marts) and a marketer can ask:

> Compare our Reddit Ads spend and platform-claimed conversions with our other paid channels.

Claude asks OWOX which data marts are relevant, reads their fields and the joins the analyst defined, and queries the one it picks. Ask it against raw data warehouse tables instead and it has to guess the join.

|  | Ungoverned | Against the data model |
| --- | --- | --- |
| What the model sees | Raw data warehouse tables | The published data marts |
| What it does | Invents the join | Reads the analyst’s join |
| What you get | A plausible number, confidently wrong | The number, and the query behind it |

MCP is the interface here, not the guarantee. The guarantee is the governed data mart behind it, and every question is logged in **Run History**. For how that works end to end, read [governed MCP analytics](https://www.owox.com/blog/articles/governed-mcp-analytics).

## What’s next?

This connector is part of our effort to make data ownership simple, transparent and accessible for everyone.

Here are more resources to explore:

*   **The Reddit Ads connector for each data warehouse:** [BigQuery](https://www.owox.com/connectors/free-reddit-ads-connector-to-google-bigquery), [Snowflake](https://www.owox.com/connectors/free-reddit-ads-connector-to-snowflake), [Databricks](https://www.owox.com/connectors/free-reddit-ads-connector-to-databricks), [AWS Athena](https://www.owox.com/connectors/free-reddit-ads-connector-to-aws-athena) and [AWS Redshift](https://www.owox.com/connectors/free-reddit-ads-connector-to-aws-redshift).
*   **The full data warehouse setup** in the [Reddit Ads → BigQuery guide](https://www.owox.com/blog/articles/free-reddit-to-bigquery-connector).
*   **The same route for another platform:** [Facebook Ads → Google Sheets](https://www.owox.com/blog/articles/free-facebook-ads-connector-to-google-sheets), [LinkedIn Ads → Google Sheets](https://www.owox.com/blog/articles/free-linkedin-ads-to-google-sheets-connector) and [TikTok Ads → Google Sheets](https://www.owox.com/blog/articles/free-tiktok-ads-to-google-sheets-connector). More free connectors are on the [connectors page](https://www.owox.com/connectors).

Check out our [GitHub repo](https://github.com/OWOX/owox-data-marts), leave us a ⭐ **star**, and let’s build better tools together.

## Your New Normal

Turn your data into decisions.

Governed data marts give you the clean foundation ML needs to actually work.

*   No AI hallucinations
*   Analyst-governed definitions
*   Every number traces to SQL

[Get started free](https://www.owox.com/app-signup)

## FAQ

## Frequently Asked Questions

Is there a direct Reddit Ads to Google Sheets connector?

No. The route is Reddit Ads, then a data warehouse, then Google Sheets. A Reddit Ads data mart of the Connector type loads your ad data into your data warehouse, and Google Sheets reads it from there through a report on the data mart or through the OWOX Data Marts extension.

What do I need to connect Reddit Ads?

Your Reddit Ads Account ID and the credentials of a Reddit app: an App ID, a Secret, a Redirect URI, a Refresh Token and a User-Agent string. The app needs the adsread scope. Reddit access tokens last one hour, but the refresh token does not expire, so the connector only stores the refresh token.

Which Reddit Ads data can I load?

You choose the endpoint and the fields in the data mart, for example spend, clicks, impressions and conversions. Reddit reports click-through and view-through purchases separately, so decide in your own SQL how to count them together.

How often does Reddit Ads data refresh?

You set it with triggers. A Connector Run trigger loads new data into your data warehouse daily, weekly, monthly or on an interval, and a Report Run trigger pushes the result to your Google Sheets report. A manual backfill loads a custom date range once.

Can I use Reddit Ads data in Excel?

Yes. Once the data is in your data warehouse, the OWOX Excel add-in can read the same data mart, so Excel and Google Sheets show the same numbers.

Is the Reddit Ads connector free?

OWOX Data Marts is free and open source when you run it yourself, including the Reddit Ads connector. For OWOX Cloud, see the pricing page.

## Who wrote this

![Vadym Kramarenko](https://cdn.owox.ai/www/webflow/6798e703afdf787334941cde_Vadym-Kramarenko.png/public)

[Vadym Kramarenko](/team/vadym-kramarenko) · Growth Marketing Manager

Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks.

[LinkedIn](https://www.linkedin.com/in/vadim-kramarenko/) · [All articles](/team/vadym-kramarenko)

[Data Integration](/blog/topics/data-integration)

## Related articles

[Data Integration · How to connect Facebook Ads to Google Sheets with OWOX Data Marts · September 30, 2026](/blog/articles/free-facebook-ads-connector-to-google-sheets)

[Data Integration · How to connect TikTok Ads to Google Sheets with OWOX Data Marts · September 30, 2026](/blog/articles/free-tiktok-ads-to-google-sheets-connector)

[Data Integration · How to connect LinkedIn Ads to Google Sheets with OWOX Data Marts · September 30, 2026](/blog/articles/free-linkedin-ads-to-google-sheets-connector)

[See all articles →](/blog/articles)

## References

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Data Integration](https://www.owox.com/blog/topics/data-integration) — /blog/topics/data-integration.md
- [Vadym Kramarenko](https://www.owox.com/team/vadym-kramarenko) — /team/vadym-kramarenko.md
- [OWOX Data Marts](https://www.owox.com/app-signup)
- [why we built free data connectors for analysts](https://www.owox.com/blog/articles/free-open-source-connectors-for-analysts) — /blog/articles/free-open-source-connectors-for-analysts.md
- [marketing analytics](https://www.owox.com/blog/articles/what-is-marketing-analytics) — /blog/articles/what-is-marketing-analytics.md
- [CRM](https://www.owox.com/blog/articles/crm-and-online-data-integration-guide) — /blog/articles/crm-and-online-data-integration-guide.md
- [GA4](https://www.owox.com/blog/articles/an-in-depth-look-at-google-analytics-4) — /blog/articles/an-in-depth-look-at-google-analytics-4.md
- [dashboards](https://www.owox.com/blog/articles/dashboard-dreams) — /blog/articles/dashboard-dreams.md
- [Book a Demo](https://www.owox.com/demo) — /demo.md
- [data mart](https://www.owox.com/features/data-mart-management) — /features/data-mart-management.md
- [OWOX docs](https://docs.owox.com/)
- [BigQuery](https://www.owox.com/data-storages/google-bigquery) — /data-storages/google-bigquery.md
- [Reddit Ads → BigQuery guide](https://www.owox.com/blog/articles/free-reddit-to-bigquery-connector) — /blog/articles/free-reddit-to-bigquery-connector.md
- [Reddit Ads data source](https://www.owox.com/data-sources/reddit) — /data-sources/reddit.md
- [Google Sheets destination](https://www.owox.com/data-destination/google-sheets) — /data-destination/google-sheets.md
- [Looker Studio](https://www.owox.com/data-destination/looker-studio) — /data-destination/looker-studio.md
- [Slack](https://www.owox.com/data-destination/slack) — /data-destination/slack.md
- [spreadsheet reporting](https://www.owox.com/features/spreadsheet-reporting) — /features/spreadsheet-reporting.md
- [OWOX MCP](https://www.owox.com/features/mcp) — /features/mcp.md
- [CRM data](https://www.owox.com/blog/articles/unifying-ad-spend-crm-data-cac-report) — /blog/articles/unifying-ad-spend-crm-data-cac-report.md
- [GA4 data](https://www.owox.com/blog/articles/blend-ga4-conversions-with-ad-spend) — /blog/articles/blend-ga4-conversions-with-ad-spend.md
- [governed MCP analytics](https://www.owox.com/blog/articles/governed-mcp-analytics) — /blog/articles/governed-mcp-analytics.md
- [BigQuery](https://www.owox.com/connectors/free-reddit-ads-connector-to-google-bigquery) — /connectors/free-reddit-ads-connector-to-google-bigquery.md
- [Snowflake](https://www.owox.com/connectors/free-reddit-ads-connector-to-snowflake) — /connectors/free-reddit-ads-connector-to-snowflake.md
- [Databricks](https://www.owox.com/connectors/free-reddit-ads-connector-to-databricks) — /connectors/free-reddit-ads-connector-to-databricks.md
- [AWS Athena](https://www.owox.com/connectors/free-reddit-ads-connector-to-aws-athena) — /connectors/free-reddit-ads-connector-to-aws-athena.md
- [AWS Redshift](https://www.owox.com/connectors/free-reddit-ads-connector-to-aws-redshift) — /connectors/free-reddit-ads-connector-to-aws-redshift.md
- [Facebook Ads → Google Sheets](https://www.owox.com/blog/articles/free-facebook-ads-connector-to-google-sheets) — /blog/articles/free-facebook-ads-connector-to-google-sheets.md
- [LinkedIn Ads → Google Sheets](https://www.owox.com/blog/articles/free-linkedin-ads-to-google-sheets-connector) — /blog/articles/free-linkedin-ads-to-google-sheets-connector.md
- [TikTok Ads → Google Sheets](https://www.owox.com/blog/articles/free-tiktok-ads-to-google-sheets-connector) — /blog/articles/free-tiktok-ads-to-google-sheets-connector.md
- [connectors page](https://www.owox.com/connectors) — /connectors.md
- [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md