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

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

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

[Data Integration](/blog/topics/data-integration) · Updated September 30, 2026 · [Ievgen Krasovytskyi](/team/ievgen-krasovytskyi) · 13 min read

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

Running ads on Facebook is easy. Getting **clear, usable reports** from it? Not so much.

If you’ve ever tried to pull performance data into Google Sheets, you know the pain: **manual CSV exports, expensive tools, and limited access** to your own ad results.

The route that holds up is not a direct pipe from Facebook into a sheet. It is Facebook Ads, then a **data warehouse**, then Google Sheets. [OWOX Data Marts](https://www.owox.com/app-signup) runs that whole path: a Facebook 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. You can run OWOX Data Marts yourself as free open source, or on OWOX Cloud.

## Why we made this free connector

At OWOX, we’ve always believed that businesses shouldn’t have to rent their own data. So the Facebook Ads connector is **free and open source**: run OWOX Data Marts yourself and there is no paid tier and no hidden features.

It is for performance marketers, founders and analysts who want to see, and control, how Facebook Ads data reaches their reports. 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 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** and customize it to fit your needs.
*   **Contribute to this data connectivity ecosystem**: suggest new connectors, pull new connectors and / or documentation to support the wider community.
*   **Join our community** & share your feedback.

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

## Why bring Facebook Ads data into Google Sheets?

If you’ve ever tried analyzing Facebook Ads performance beyond what Ads Manager offers, you already know the headaches:

❌ **Rigid reports** with limited customization
❌ **No easy way to blend Facebook data** with other sources
❌ **Connectors that charge you more** as your data grows

That’s where Google Sheets comes in – and why this connector changes the game.

✅ With Google Sheets, you can **structure your ad data** however you need.
✅ You can **combine it with data** from [Google Analytics](https://www.owox.com/blog/articles/an-in-depth-look-at-google-analytics-4), [CRM tools](https://www.owox.com/blog/articles/crm-and-online-data-integration-guide), and other platforms.
✅ You can build **automated reports,** [**dashboards**](https://www.owox.com/blog/articles/dashboard-dreams)**, and share insights** across your team – no waiting, no copy-pasting.

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 Facebook-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. The sheet report holds only the columns you choose.

### 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 year-on-year and campaign-history questions depend on.

### Facebook is rarely the only channel

The moment the question is “which platform is actually paying back?”, Facebook 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 Facebook Ads is one of them – the same connector can land in BigQuery, Snowflake, Athena or Redshift:

![OWOX Data Marts list filtered to Facebook Ads, showing connector data marts for the same source on BigQuery, Snowflake, AWS Athena and AWS Redshift – the ad data lives in the data warehouse you choose, not in one sheet](https://cdn.owox.ai/www/content-marketing-article/free-facebook-ads-connector-to-google-sheets/screens/2.png/public)

A separate data mart, **Unified Ad Spend**, then brings the platforms together. The analyst who owns it wrote the SQL: one `SELECT` per platform, each commented with the connector data mart it reads, all `UNION ALL`ed to one daily grain with a shared source, medium and campaign naming.

![Data Setup of the Unified Ad Spend data mart in OWOX Data Marts, with the analyst-written SQL opening with a commented Facebook Ads Insights block – Facebook is one input among the platforms unified in SQL](https://cdn.owox.ai/www/content-marketing-article/free-facebook-ads-connector-to-google-sheets/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. And because the naming matches the store’s traffic sources, spend can be set against the sessions and revenue it produced instead of being read on its own:

![Description of the Unified Ad Spend data mart listing the platforms it unifies – Google, Facebook, TikTok, LinkedIn, Microsoft, Reddit and X – and the questions it can answer](https://cdn.owox.ai/www/content-marketing-article/free-facebook-ads-connector-to-google-sheets/screens/3.png/public)

### 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-facebook-ads-connector-to-google-sheets/screens/4.png/public)

## How it works

1.  **A Facebook 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 Facebook 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 data warehouse.** OWOX Data Marts supports BigQuery, Snowflake, Databricks, AWS Athena and AWS Redshift. The examples here use BigQuery.
*   **A Facebook Ads account** you can read insights from.
*   **OWOX Data Marts,** either self-managed with Node.js and the OWOX CLI (free and open source) or OWOX Cloud.
*   **A Google account** for the Google Sheets report.

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

Seven steps. The first five load your Facebook 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 Facebook Ads tables will be created. The BigQuery walkthrough, including the service account, is in the [BigQuery guide](https://www.owox.com/blog/articles/free-facebook-ads-to-bigquery-connector).

### Step 3: Create the Facebook Ads data mart ( ~2 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 **Facebook Ads** (the [Facebook Ads data source](https://www.owox.com/data-sources/facebook-ads)).
3.  Authorize the connection:
    *   **OWOX Cloud:** authorize Facebook Ads with your login through OAuth. There is no token to copy.
    *   **Open-source version:** it has no OAuth, so you connect with an **access token** from Meta. Get one below, then paste it into the connector.
4.  Add the **Account ID**. It is in your Meta Ads account overview and in the Ads Manager URL.

#### Open-source version: get an access token

You’ll need an **access token** to authorize the connector and pull data from Facebook Ads.

1.  **Log In to Meta for Developers**
    *   Visit the [Meta for Developers site](https://developers.facebook.com/)

![Meta Ads homepage with login button highlighted for accessing Meta for Developers.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e52f8_AD_4nXerGEDFhzrjOo8tbV8RVRnClswWLT1m9-enzEm9JePrjMGitD662xAs79voIIXHvvY81Gr0gTNq7agVbOLR3K9ieKQibCEFcRwBhz05zQYVLLL1SW93hvyijJT5-bTkuOTHx4LfBQ.png/public)

*   Sign in using your Facebook account.
    _(Use the account that has access to your Meta Ads Business Manager.)_

![Meta for Developers login screen showing login options with Facebook or account creation.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e52e2_AD_4nXdTzpsnRAJ5-STE3xRuGHLB1LOgN_bj4suaXZYFNaP2rwLQXafi9LfrhcTFJLmBPuSN_SsLex6meXWJUINwSpyqMyw0JJTVppZd14K4Pwi_0HM1iwU-UsWgw3I-HHJDGizPmCpaSA.png/public)

2.  **Create a New App**
    *   Click **My Apps** in the top-right menu, then **Create App**

![Meta dashboard with “My Apps” button highlighted to manage or create Facebook Apps.](https://cdn.owox.ai/www/webflow/684bb602ea6775fe316e530b_AD_4nXejDG3bL9iPNE5B0KcldjKXxRptfxfbFMT69AxiERL6XXg1DBLb12vc0oHELiE3YcneLOyJXl56yCwi56TBpvsfdoET7X5QWEbTh1FtpK27tlKuUtohvHHVYJYsVQ_D6jhO_MaFJA.png/public)

![Meta Developer console showing the option to create a new app in the Apps section.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e52f5_AD_4nXdRW-UXMWSYQC9VG9LFOt7GzvxJOiXAxLj6_HrGEFxUWxRflfVOn8C0_scs_so2i4BAqxZrpuZsvRq92yKXD-wBeXDeSsd9Tf6K0y5g6-I3kET97IGCrAET-6-AVwKoDTZLZPqJFA.png/public)

*   In the **App Name** field, enter a name of your choice.

![App creation screen with OWOX App name entered and contact email field shown.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e52fb_AD_4nXcK0Fgfm_BXrzwC2xnFqfJkrJwCmMP-s0tWWi-fgi52OKqBIxYG--viBBG-YiRlGWzkD9wjNjCyK0sKPNyq_G8_sTssaTy8jukhG-_y84qVbkdCjtxjjL6NoeC0QgURs6CCm9OeYQ.png/public)

*   For the use case, select **Other**

![Option selected to create an app without a use case under the “Other” category.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e52d6_AD_4nXdNu4cGAqOUw-vfluWmgiYBK83yHuWwfVQ4HAKDLgMJSf_GE4hR0Yw_246Pxfe9idxlD4U3tqvEshsw70u45nx-mlA4ESywsgSY6FdZypzivv8loE3buVRdYXn-0H-2Op4JPY-anA.png/public)

*   Choose **Business** as the app type → click **Next**

![Selection of “Business” as the app type for managing Meta business assets.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e52c8_AD_4nXdVNzXhGmsRaicX24MtWpL9J3GAXI6guGP0TK3KOara5IIFza4OWkZ5vL2qk5HBthQfT2j6JhQgu1XWvtnaXIqaZTxpwjVvM7aq7gA5T329D1RTfTJ3flrgThbDNauCRWnB1EGdhg.png/public)

3.  **Connect to a Business Portfolio**
    *   Select the appropriate **Business Portfolio**
    *   Click **Create App**

![Business portfolio dropdown displayed while filling app creation details.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e52df_AD_4nXdFWCMBKrPtFpbSTSsvAGU95W6uGlM5wmMXQeAkVB6YK497qLr0eCuuKzh9kURiIa_tR4eHWe4uyqgEKMpDNfVHA7EZLfe7NcgEnARBvhO0jitsdqQSbcG89JgCPqZYduK-W3aJ.png/public)

4.  **Start Business Verification**
    *   Go to **App Settings → Basic**

![Business verification section under App Settings showing the “Start Verification” button.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e52f1_AD_4nXf8xnNzhEauebQip9wsUX6nlAVm1lmaJ2egyYqC7B6e07QNYIKUEvlEi2wVOIYJAYsdv_h8XvMdrfMbf0lP-zbQFxd2l6s0cbsX_5HW6S6eJhEc_JgJpxtdz9IpOXRX6VXE20mK.png/public)

*   If prompted, connect your app to your business portfolio.

![Popup for selecting a business portfolio to begin business verification.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e5305_AD_4nXfyvwsiSlvKEaKxbZjVx-5KB71hpXZkHeH7bOZwrqPXVJpw6O1V2UkX__E6JpA7ZFb9WrVKioamga3mgYUQONQlbz0fiIO63jtnFFeH1HN6oVl_Qt9lnuYTapa0ufcpBfJAhFZY0w.png/public)

*   Click **Start Business Verification**

![Dialog box with selected portfolio and “Start business verification” button highlighted.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e5302_AD_4nXcKvFDw5qz7qkDnNl9WAar7v5Vf--6y-AylNQADFePR9Y91u5jUO2fJUUDjAil-tyYJP3GpxpH4cZW6BBIVizNIkS_6yHYqpQ0vzrYtFApAM1axkv2RQuFhffG05z_jn6tVMIRHWQ.png/public)

5.  **Submit Verification Info**
    *   Fill in the required fields with **accurate contact and organizational information**.
    *    _Ensure your submission meets_ [_Meta’s requirements_](https://business.facebook.com/business/help/159334372093366)_._

![Security Centre in Meta Business Manager showing pending business verification.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e5308_AD_4nXfPTrvKlCkKOcbjpMDXCh7NMSsEfD4GC_4IZ6iJrOx52jpAIWrKRttjWonFe9fyn9VftK8sQqpQ1PZn1JFoPSm9D07oPPyxNyEMAC3Wl0vaXO4lnrJROr-9mm1GnF1mcnEkxKUMYg.png/public)

*   Meta will review your submission within **2 business days**.

![Confirmation message stating business verification info was submitted.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e52cb_AD_4nXfi0004dxvEl6zg9-ZYLH-z3FTLCj1Dnnqtg5-A2yg6xCxKvlrEmdVJQ9YVAz-JsU3iFXbyMDSboi42dvaPi5g8ehd86I-bcVUXO-AYeMEJYButJ9B1iNJ8O-JqLjBgPnAaTNb8XA.png/public)

6.  **Set Up Marketing API**
    *   After successful verification, return to your [app dashboard](https://developers.facebook.com/).
    *   Locate the **Marketing API** card and click **Set Up**

![Meta App Dashboard with Marketing API selected to set up for app integration.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e52e5_AD_4nXdkTs72fJJrxMm6aMsSjpZFsWP62NCLtXbp7mJEYYpV8RHzC0pqgWcJY6ArXfSVfow3nl_4R33e-9SqtRcoqe6YqU7VGf1urFOSE5HFxG_lOnLFjPRnj2BxvvVtPGN43TSlzIYnCg.png/public)

7.  **Grant Required Permissions**
    *   In the **Tools section**, enable the following scopes:
        *   **ads\_read**
        *   **Read\_insights**

![Meta dashboard showing token permissions selection with checkboxes for ads\_management, ads\_read, and read\_insights.](https://cdn.owox.ai/www/webflow/684bb601ea6775fe316e52d3_AD_4nXcrEomHQDSrppB6gblpVN0wiC2N8l-zPcyUivh3IzOSeWtDbjn_GpNF2tfAy-AmoNGXu0Ik51O3TK8nEuVCymojgb19QsBCsACESmMorwddg0ecQIumBpOexW66N2W0i7CBjqAV.png/public)

8.  **Generate and Save Token**
    *   Click **Get Token**

![Token generation screen with selected permissions and highlighted “Get Token” button in Meta developer portal.](https://cdn.owox.ai/www/webflow/684bb603ea6775fe316e535e_AD_4nXelJjP8GxAH3TOEwVNn14nwjD0BPg0eLKi7ykKrmOUg-6iRd8XFVlT12Fp7IqmVB678a-0n8gc3cFqvnDc1sbrQFP6GcPm7CvcOwga8XstsIGd3ZWkSw07QZMyMOy-2zUyeuxXd.png/public)

*   Copy the generated access token and store it securely.
    _To regenerate, go to Marketing API → Tools → User Token section._

![Access token displayed in the Meta developer UI after permissions are selected and the token is generated.](https://cdn.owox.ai/www/webflow/684bb603ea6775fe316e5352_AD_4nXdMBCVb7NeWV-kEND8hdhVnQD7F2rdje3NKwiNxWjs722fDw7UWZCegAV3y8eqQE9Ar-DiKr7wmujgzjTG3jTrSQw2_yEp3aCamuQq_AB2gxLr8I16xogrMuc9MZ1Bi82xkxMOXcg.png/public)

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

1.  Select the **endpoint**. If you are starting out, begin with **ad-account/ads**: it carries each ad’s details, which most teams use for their first reports.
2.  Select the **fields** you need, such as clicks, spend and impressions, and set the start date.
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 Facebook 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**. Facebook 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-facebook-ads-connector-to-google-sheets/screens/5.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-facebook-ads-connector-to-google-sheets/screens/6.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

Facebook Ads data rarely answers a question on its own. With [OWOX MCP](https://www.owox.com/features/mcp) you can blend it with other Facebook 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 the mart’s own example question:

> Which campaigns are scaling spend without a matching lift in orders?

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.

Here is the answer Claude gave against OWOX’s demo e-commerce project:

![Claude answering the prompt through OWOX MCP with a chart of spend growth against conversion growth by campaign and a verdict that names the campaigns where spend outpaces orders – an answer read from governed data marts, not guessed from raw tables](https://cdn.owox.ai/www/content-marketing-article/free-facebook-ads-connector-to-google-sheets/screens/7.png/public)

|  | 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:

*   **More free connectors** on the [connectors page](https://www.owox.com/connectors), including [Google Ads](https://www.owox.com/blog/articles/free-google-ads-to-bigquery-connector), [TikTok Ads](https://www.owox.com/blog/articles/free-tiktok-ads-to-bigquery-connector), [LinkedIn Ads](https://www.owox.com/blog/articles/free-linkedin-ads-to-bigquery-connector) and [Microsoft Ads](https://www.owox.com/blog/articles/free-microsoft-ads-to-bigquery-connector).
*   **The full data warehouse setup** in the [Facebook Ads → BigQuery guide](https://www.owox.com/blog/articles/free-facebook-ads-to-bigquery-connector).

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

Can I export Facebook Ads data to Excel instead of Google Sheets?

Yes. OWOX has an Excel add-in, so you can work with your Facebook Ads data in Excel as well as in Google Sheets. Because the data lives in your data warehouse, you can also query it from any tool that connects to it, such as Looker Studio, Power BI or Tableau. You can also download any Google Sheets report as an .xlsx file.

What data warehouse do I need to connect Facebook Ads to Google Sheets?

OWOX Data Marts supports BigQuery, Snowflake, Databricks, AWS Athena and AWS Redshift. Facebook Ads data is loaded into your data warehouse first, and Google Sheets reads it from there. If you do not have a data warehouse yet, a Google BigQuery project on its free tier is an easy way to start: Google includes 10 GB of storage and 1 TB of queries per month at no charge.

Will my formulas and charts break when the data refreshes?

No. Refreshing an OWOX Google Sheets report only touches the cells the report owns, so extra columns, formulas, pivot tables, charts and named ranges in the same sheet stay intact. Your column order is kept too.

Is there a direct Facebook Ads to Google Sheets connector?

No. The route is Facebook Ads, then a data warehouse, then Google Sheets: a Facebook Ads data mart loads your data into the data warehouse, and Google Sheets reads it through a report or the OWOX Data Marts extension. Setup is point-and-click and needs no SQL, and the self-managed install is two terminal commands.

Can I combine Facebook Ads data with Google Ads or other platforms in one spreadsheet?

Yes. Each ad platform is loaded into its own connector data mart. An analyst then blends them in your data warehouse, either with SQL that unions the platforms or with joinable data marts, and delivers the result to one Google Sheets report. OWOX's demo e-commerce project does this in its Unified Ad Spend data mart for Google, Facebook, TikTok, LinkedIn, Microsoft, Reddit and X. No CSV stitching or VLOOKUP chains are needed.

How often can I refresh Facebook Ads data in Google Sheets?

You set the schedule with triggers. A Connector Run trigger loads new Facebook Ads data into your data warehouse daily, weekly, monthly or on an interval, at the time and time zone you choose. A Report Run trigger then pushes the data mart to your Google Sheets report on its own schedule, so nobody has to re-run anything by hand.

Is it free to send Facebook Ads data to Google Sheets with OWOX Data Marts?

Yes. OWOX Data Marts is open source, and the Facebook Ads connector is included at no extra cost when you run it yourself: no per-connector fees and no trial that expires. You pay only for your own data warehouse compute and storage. OWOX Cloud is the hosted option; see the pricing page for its plans.

## Who wrote this

![Ievgen Krasovytskyi](https://cdn.owox.ai/www/webflow/68404586b341508a789a4aa5_.png/public)

[Ievgen Krasovytskyi](/team/ievgen-krasovytskyi) · Head of Marketing

Ievgen Krasovytskyi is the Head of Marketing at OWOX, leading strategy across content, SEO, product marketing, and AI-powered automation. With deep expertise in analytics infrastructure, data warehouses, and marketing technology, he builds systems that connect marketing performance to business outcomes. Ievgen writes about SaaS growth, analytics workflows, and the future of AI in marketing operations.

[LinkedIn](https://www.linkedin.com/in/ievgen-krasovytskyi-a38a1253/) · [All articles](/team/ievgen-krasovytskyi)

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

## Related articles

[Snowflake · Collect Facebook Ads Data into Snowflake with OWOX Data Mart · February 4, 2026](/blog/articles/facebook-ads-to-snowflake-data-marts)

[Databricks · How to Connect Facebook Ads to Databricks (Step-by-Step) · May 26, 2026](/blog/articles/connect-facebook-ads-to-databricks)

[Google BigQuery · Connect BigQuery To Google Sheets: All Methods · April 23, 2025](/blog/articles/bigquery-reports-in-google-sheets)

[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
- [Ievgen Krasovytskyi](https://www.owox.com/team/ievgen-krasovytskyi) — /team/ievgen-krasovytskyi.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
- [Google Analytics](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
- [CRM tools](https://www.owox.com/blog/articles/crm-and-online-data-integration-guide) — /blog/articles/crm-and-online-data-integration-guide.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
- [BigQuery guide](https://www.owox.com/blog/articles/free-facebook-ads-to-bigquery-connector) — /blog/articles/free-facebook-ads-to-bigquery-connector.md
- [Facebook Ads data source](https://www.owox.com/data-sources/facebook-ads) — /data-sources/facebook-ads.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
- [connectors page](https://www.owox.com/connectors) — /connectors.md
- [Google Ads](https://www.owox.com/blog/articles/free-google-ads-to-bigquery-connector) — /blog/articles/free-google-ads-to-bigquery-connector.md
- [TikTok Ads](https://www.owox.com/blog/articles/free-tiktok-ads-to-bigquery-connector) — /blog/articles/free-tiktok-ads-to-bigquery-connector.md
- [LinkedIn Ads](https://www.owox.com/blog/articles/free-linkedin-ads-to-bigquery-connector) — /blog/articles/free-linkedin-ads-to-bigquery-connector.md
- [Microsoft Ads](https://www.owox.com/blog/articles/free-microsoft-ads-to-bigquery-connector) — /blog/articles/free-microsoft-ads-to-bigquery-connector.md
- [Snowflake · Collect Facebook Ads Data into Snowflake with OWOX Data Mart · February 4, 2026](https://www.owox.com/blog/articles/facebook-ads-to-snowflake-data-marts) — /blog/articles/facebook-ads-to-snowflake-data-marts.md
- [Databricks · How to Connect Facebook Ads to Databricks (Step-by-Step) · May 26, 2026](https://www.owox.com/blog/articles/connect-facebook-ads-to-databricks) — /blog/articles/connect-facebook-ads-to-databricks.md
- [Google BigQuery · Connect BigQuery To Google Sheets: All Methods · April 23, 2025](https://www.owox.com/blog/articles/bigquery-reports-in-google-sheets) — /blog/articles/bigquery-reports-in-google-sheets.md
- [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md