Home > Destinations > Google Sheets > Facebook Ads

Connect Facebook Ads to Google Sheets

Import Facebook Ads data into Google Sheets and keep it there: campaigns, ad sets, ads, placements, and creative performance, refreshed on the schedule you choose.

The Catchr add-on writes into the spreadsheet you already use, next to your other ad platforms, so your formulas, pivot tables, and client tabs keep working.

Looker Studio
Power BI
Google Sheets
BigQuery
Snowflake

Trusted by teams that would rather improve campaigns than copy cells.

What a Facebook Ads export cannot do, and a connected sheet can

Advertising Manager exports one account, one date range, one set of columns. Catchr keeps the same query running, so the sheet you built last month still fills itself this month.

The Monday-morning scramble, deleted

No more opening every Advertising account, changing every date range, downloading every CSV, and rebuilding the same report before the weekly meeting.

One campaign. One shared language.

Organize each source in its own clean tab, then bring spend, traffic, leads, and revenue together in the views your team actually uses.

A file your team can actually work in

Add forecasts, targets, comments, formulas, client notes, and custom calculations around your campaign data.

Do not start your next Facebook Ads report from cell A1

Start from a Facebook Ads dashboard that is already built, then change what you need.

How to connect Facebook Ads to Google Sheets

No scripts to maintain. No API documentation to study. No recurring CSV ritual.

Step one

Install the Google Sheets add-on

Add Catchr to Google Sheets from the Google Workspace Marketplace, then open it from the spreadsheet where you want to work.

Step Two

Launch the Catchr add-on

Open Google Sheets and start the Catchr add-on. Sign in with your Catchr account.

Step Three

Configure your import

Choose Facebook Ads, the Advertising accounts, the metrics and dimensions, the date range, and the cell where the data should land.

Step Four

Refresh automatically

Run your first import, then schedule automatic refreshes to keep your spreadsheet up to date while your formulas, charts, and pivot tables continue working.

Facebook Ads metrics and dimensions available in Google Sheets

Access 440 metrics and 233 dimensions from Facebook Ads connectors including Campaign, Ad set, Ad, Date, Placement, Country, Device, Objective, Spend, Impressions, Clicks, CTR, CPC, CPM, CPA, ROAS, Conversions, Purchase value.

440

Available metrics

233

Available dimensions

Five tabs that replace five recurring Facebook Ads headaches

Use Catchr to create dashboards that show what is working, what is wasting budget, and where performance is changing.

What changed since yesterday?

Track Spend, Impressions, Clicks, CTR, CPC, CPM, CPA, ROAS, Conversions, Purchase value.

Use conditional formatting to flag a campaign whose cost per purchase moved outside your range overnight, or whose frequency climbed while CTR fell.

The media buyer opens one tab and knows where to look.

Will we hit the plan?

Compare planned budget with actual spend by client, ad account, campaign, or market.

Calculate how much of the month has passed, how much of the budget has been consumed, and where the campaign lands at its current pace.

Catch overdelivery on a campaign budget optimization campaign before the end-of-month explanation.

Where should the next budget move go?

Place Facebook Ads beside other channel.

Compare the KPIs that can genuinely be shared, and keep the Meta-specific ones, such as frequency, reach, and results by objective, in their own source tab. The result is not a forced attribution model.

It is a clearer view of how each channel contributes.

What can we explain in five minutes?

Create a client-facing tab with performance, budget status, key changes, comments, and next actions.

The raw source tabs stay available for deeper investigation, while the client gets the view that answers the questions they actually ask, without a live tour through Ads Manager.

What should we repeat next time?

Keep a structured history of campaign performance, targets, observations, and decisions.

Compare launches, promotions, seasons, creative concepts, or audiences, on a reporting structure that stays under your control.

This matters more on Meta than elsewhere: the API only returns 37 months of totals, and a sheet that keeps its own history outlives that window.

Facebook Ads to Google Sheets pricing

Choose your plan by the number of platforms and accounts you report on.

Starter

For freelancers and small teams.

$ 24 /mo

Billed monthly · cancel anytime

Platforms3
Accounts10
Start free trial

Growth

For agencies managing more clients.

$ 239 /mo

Billed monthly · cancel anytime

Platforms10
Accounts100
Start free trial

Scale

For teams reporting at scale.

$ 599 /mo

Billed monthly · cancel anytime

Platforms25
Accounts500
Start free trial

Customer testimonials

What our customers say about us.

85 %
Faster
Reporting time

After three years of use, Catchr has become essential for both our teams and our clients. So far, it has been our best solution for compiling and analyzing data from different advertising platforms. It’s easy to set up, and the customer service is responsive and excellent.

Valentin Keravel
CEO, Laio – Agency

With Catchr’s automated API, we can finally collect and centralize all advertising data, connect it with booking information, and calculate the real ROAS for our restaurant clients. It gives them full visibility, more autonomy, and the ability to optimize campaigns to maximize ROI.

Corentin Largeron
Freelance
30
hours saved

The solution is a real game changer, providing optimal time savings for our data reporting. The major strength of the solution is their highly responsive and professional support.

Corentin Largeron
CEO at The Browz – Agency

Facebook Ads to Google Sheets: FAQs

Answers to common questions about connecting Facebook Ads data to Google Sheets.

Can I send my Facebook lead form submissions to Google Sheets with Catchr?

No. Catchr imports Facebook Ads performance data, including lead counts, cost per lead, and on-Facebook leads from Messenger and Instant Forms. It does not export the contact details people typed into your lead forms. For the submissions themselves, use a lead retrieval integration, such as Meta's native Google Sheets integration where available. You can use both: collect lead records in one tab and report on the cost of acquiring them in another.

What is the difference between Meta's native Google Sheets integration and Catchr?

They serve different reporting needs. Meta's native integration connects Instant Form lead records with Google Sheets for lead follow-up. Catchr imports advertising performance, such as spend, impressions, clicks, and conversions, into your spreadsheet. You can select the ad accounts you have access to, schedule refreshes, and report alongside your other platforms. Use a lead integration to manage individual submissions and Catchr to measure campaign performance.

Can Facebook Ads data refresh automatically in Google Sheets?

Yes. Catchr lets you schedule each Google Sheets query to refresh hourly, daily, weekly, or monthly. By default, a refresh replaces the query's imported data; append mode is also available. Keep query output in a dedicated raw-data tab with room to grow, and put formulas, charts, and pivot tables in separate reporting tabs. Use ranges that can accommodate new rows and check chart and pivot ranges as your dataset grows.

Will the numbers in my sheet match what I see in Ads Manager?

They should align when the reporting settings match. Check the date range, account timezone, attribution window, and reporting level, and compare the same metrics and filters. Allow for reporting delays and later conversion updates. Meta stopped returning 7-day view and 28-day view attribution windows through the Ads Insights API on January 12, 2026, including for historical queries. Also avoid adding campaign totals to ad set or ad totals: those levels can describe the same conversions and would double count them.

How much Facebook Ads history can I import?

As far back as Meta makes it available for the fields and breakdowns you select. Aggregate totals are available for up to 37 months. Breakdowns of unique-count fields and hourly breakdowns are limited to 13 months, while frequency breakdowns are limited to 6 months. Requests outside the applicable window may fail or return no data. Preserve older results in an archive tab or a separate file: refreshing a rolling date range does not automatically keep a permanent history.

How much Facebook Ads data can one Google Sheet hold?

Google Sheets supports up to 20 million cells per spreadsheet, with the increase still rolling out to some accounts in September 2026. The limit covers all tabs combined. Ad-level data split by day, placement, and country can grow quickly, and performance may slow before you reach the ceiling. Import at the level you actually report on, select only the fields you need, and keep one workbook per client. For longer histories or very large datasets, consider a warehouse such as BigQuery.

Can I report on creatives, placements, and audiences, not just campaigns?

Yes. Catchr exposes creative fields alongside dimensions such as placement, publisher platform, age, gender, country, and device. Creative fields include IDs and names, ad body text, image URLs, and thumbnail URLs when Meta makes them available for the ad format. Availability varies: for example, the standard creative body field is not supported for video post creatives. Meta also restricts which breakdowns can be combined, so you may need separate queries for different creative, audience, and placement views.

Can I combine Facebook Ads with other marketing sources in the same Google Sheet?

Yes. You can create a separate data request for each source in the same spreadsheet, including Facebook Ads, Google Ads, GA4, TikTok Ads, Shopify, and HubSpot. Give each request its own output range, preferably in a dedicated source tab, and set its refresh schedule. Use reporting tabs to bring the results together. Scheduled queries run in sequence, so a slow request can delay later refreshes.

Do all my platforms need to use the same metrics?

No. Keep platform-specific fields inside their own source tabs. In your shared reporting tabs, map only KPIs with comparable definitions, such as spend, impressions, clicks, CTR, CPC, and conversions. Check currency, click definitions, and conversion attribution before combining sources. Recalculate ratios such as CTR and CPC from the combined totals. Keep source-specific measures, such as Meta results by objective, in the Facebook Ads tab; campaign, ad set, date, and placement are dimensions, not KPIs.

How should an agency organize several clients?

A practical structure is to create one workbook per client. Inside each workbook, use one raw tab per source and separate working tabs for daily monitoring, budget pacing, cross-channel performance, and the client summary. For larger accounts, separate tabs can also be created by country, brand, business unit, or campaign objective.

Can several people work from the same report?

Yes. The imported data behaves like other spreadsheet data, so Google Sheets sharing, permissions, and version history apply. Give your team edit access and your client view-only access to the workbook. Protected sheets and ranges can restrict editing, but they do not create private tabs or separate viewing permissions. If a client should only see a summary, share a separate reporting file.

Do I need to write code?

No. The Catchr add-on lets you choose a data source, select metrics and dimensions, and import the result from inside Google Sheets. There is no Apps Script to write and no Marketing API call to build.

Still have a question?

Our team is always here to answer any questions you may have about our data connector.

Your next report should not start with five exports

Connect your marketing platforms and build a data workflow your entire agency can use.

14 days free-trial
No credit-card required
100+ sources