Connector

Connect Facebook Ads Data to Google Sheets

Use Google Sheets as a reporting destination for Facebook Ads data collected with OWOX Data Marts. Collect Facebook Ads Data into any data warehouse, then reuse it in Sheets (or Looker Studio) for reporting. Or enable AI Insights and deliver ads performance & alerts into chat tools or by email.

Get Started Free

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: Create a Facebook Ads Data Mart

Start by creating a new Facebook Ads Data Mart and choose Connector as the definition type.

Select Facebook Ads as the data source
Specify the ad account that you want to collect data from
Authorize access to your Facebook Ads account

Create Data Mart

S02 · Step 2

Step 2: Select a Data Storage

All data should have it’s home. You need to connect a data storage where your Facebook Ads data will be stored & processed.

Choose a supported data warehouse such as BigQuery, Snowflake or Redshift.
Store raw Facebook Ads data in one central place so you can blend them later on
Keep full ownership and control over your data

Connect Data Warehouse

S03 · Step 3

Step 3: Select API Endpoint & Fields

Choose exactly which Facebook Ads data should be collected.

Select the appropriate API endpoint (for example, ad_account_insights)
Choose metrics such as spend, impressions, clicks, and conversions
Define the dataset and table where data will be stored

Collect Facebook Ads Data

S04 · Step 4

Step 4: Create Facebook Ads Report in Google Sheets

Now it’s time to enable your Facebook Ads data in Google Sheets

Add Google Sheets as a Destination
Create a new Google Sheets Document, share it, then Create & Run your report
Check the box for regular updates to keep data fresh

Enable Facebook Ads Data

S05 · Step 5

Step 5: Get more from your Facebook Ads Data

Your Facebook Ads data is now available for analysis in Google Sheets. But why stop at just this? You can reuse the same Facebook Ads Data Mart to:

Enable Facebook Ads AI Insights delivered on a schedule to Slack, MS Teams or by Email
Visualize Facebook Ads Data in Looker Studio. Just tik the box on the destinations tab
Blend Facebook Ads data with GA4, CRM, or other ad platforms

Schedule Facebook Ads Insights

Related connectors

Athena Connector to Google Sheets Reporting System BigQuery to Google Sheets Reporting System Databricks Connector to Google Sheets Reporting

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.

A3re: trusting AI

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.”

C9re: one source of truth

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.”

E7re: getting time back