Export Facebook Ads Data to Google Sheets: 3 Methods

How do you export Facebook Ads data to Google Sheets?

Three ways exist to get Facebook Ads data into Google Sheets: download a report from Ads Manager and import the file manually, connect a paid add-on such as Supermetrics or Windsor.ai that lists Facebook Ads as a source and Google Sheets as a destination, or write a script against Meta's Insights API for full programmatic control.

• Manual export. Download the report table from Ads Manager as a file, then import it into Google Sheets. Free, but you repeat the task each time you need fresh numbers.
• Connector add-on. Supermetrics and Windsor.ai both list Facebook Ads as a source and Google Sheets as a destination, as of September 6, 2026, with a scheduled refresh.
• Insights API script. Meta's Insights API "allows developers to programmatically access and analyze data related to ads running on Meta's family of apps," providing metrics for impressions, clicks, spend, and conversions, per documentation checked August 12, 2026.

Which route fits depends on how often the sheet needs to update and whether anyone can script against an API. The same tradeoff shows up across most of marketing analytics, including connecting Google Ads to Looker Studio.

What do you need before you start?

Before exporting, you need access to the Facebook Ads account in Ads Manager, a Google account for Sheets, a decision on which metrics and date range to pull, and — for the connector or API route — either a paid subscription or a registered developer app with the right access tier. Settling these first avoids rebuilding the export later.

• Access to the Facebook Ads account in Ads Manager
• A Google account to use Google Sheets
• A decision on which metrics, dimensions, and date range you want before you build anything
• For the connector route: a payment method, since Supermetrics and Windsor.ai run on paid plans above their limited free or trial tiers
• For the API route: a registered Meta developer app and an access tier. Development Access is the default with strict limits, and Standard Access sits above it; higher limits require Advanced Access to the Ads Management feature, per Meta's documentation checked August 12, 2026.
• Consistent campaign naming and UTM tagging up front make it far easier to join Sheets data with other channels later

Method 1: how do you export Facebook Ads data manually?

The manual route costs nothing: download the report table from Ads Manager as a file, then import that file into a new or existing Google Sheet. It works for a one-off pull or an occasional report, but every refresh means repeating the same download-and-import steps by hand.

1. Set the metrics, dimensions, and date range you need inside Ads Manager's reporting view.
2. Download the report table from Ads Manager as a file.
3. Open Google Sheets and import that file into a new or existing sheet.
4. Re-map column headers if needed so downstream formulas and charts keep working.
5. Repeat the same steps by hand whenever the numbers need updating.

This route fits a single report, a one-time audit, or a dashboard updated monthly. Re-downloading the same file every week is the signal to move to Method 2.

Method 2: how do you use a connector add-on like Supermetrics or Windsor.ai?

A connector add-on such as Supermetrics or Windsor.ai connects to your Facebook Ads account and writes the data straight into Google Sheets on a schedule. Both list Facebook Ads as a source and Google Sheets as a destination, so setup is picking the vendor, authorizing the ad account, and choosing a refresh frequency.

Both are third-party add-ons, not a Google-built feature. Pricing and refresh frequency separate entry plans from higher ones, all as of September 6, 2026:

• Supermetrics Starter: $55/month ($44/month billed yearly), weekly data refreshes (Google Sheets only)
• Supermetrics Growth: $222/month ($177/month billed yearly), daily data refreshes (Google Sheets only)
• Windsor.ai Free: $0/month, daily sync
• Windsor.ai Basic: $23/month ($19/month billed annually), daily scheduled sync
• Windsor.ai Standard: $118/month ($99/month billed annually), daily or hourly scheduled sync

1. 1

   Sign up for a plan

   Choose Supermetrics or Windsor.ai. Supermetrics offers a 14-day free trial with no credit card needed; Windsor.ai offers a 30-day trial that converts to a Forever Free plan, also with no credit card needed, both as of September 6, 2026.

2. 2

   Connect Facebook Ads as the data source

   Both tools list Facebook Ads as a data source. Authorize the connector against your ad account so it can read campaign data.

3. 3

   Choose Google Sheets as the destination

   Point the connector at a new or existing Google Sheet — Google Sheets is a supported destination on both platforms.

4. 4

   Pick fields, accounts, and date range

   Select the metrics, ad accounts, and time range to pull, within the data-source and account limits of your plan tier.

5. 5

   Set the refresh schedule

   Supermetrics Starter refreshes Google Sheets weekly and Growth refreshes daily; Windsor.ai syncs daily on Free and Basic and daily or hourly from Standard, all as of September 6, 2026.

6. 6

   Review the sheet

   Confirm the pulled rows and headers match what your charts or formulas expect before relying on the automatic refresh.

The pattern is the same one used for connecting TikTok Ads to Looker Studio: pick a vendor, authorize the account, choose a destination, set a schedule.

Method 3: how do you pull Facebook Ads data with the Insights API?

The Insights API gives programmatic access to Facebook Ads metrics — impressions, clicks, spend, and conversions — so a script can pull data on any schedule and write it into Google Sheets via the Sheets API. It fits teams with developer resources who want full control over fields, cadence, and history.

1. Register a developer app and confirm which access tier it has: Development Access (default, strict limits) or Standard Access.
2. For higher volume, apply for Advanced Access to the Ads Management feature.
3. Call the Insights API for impressions, clicks, spend, and conversions on the ad account.
4. Watch the rate limits, which scale with access tier and active ad count.
5. Write the returned rows into Google Sheets via the Sheets API, or through an intermediate script, on whatever cadence you set.

Why don't my Google Sheets numbers match Ads Manager?

Mismatches almost always come from one of five generic causes: a different date range between the sheet and Ads Manager, a different time zone set on the ad account, an attribution setting that differs between what you pulled and what Ads Manager shows, a stale sheet that hasn't refreshed, or a filter or currency difference between the two views.

• Date range. Confirm both screens are looking at the same window before anything else.
• Time zone. The ad account's time zone shapes which day a given row is counted under.
• Attribution setting. A different attribution setting between your pull and what Ads Manager displays produces different totals from the same underlying activity.
• Stale refresh. A manual sheet that hasn't been re-imported, or a connector pull that hasn't run yet, shows old numbers next to a live Ads Manager screen.
• Filters and segments. Check that campaign, ad set, or placement filters match on both sides.
• Currency. Confirm both views are reading the same account currency before comparing totals.

When does a paid connector pay for itself?

A paid connector earns its cost once Facebook Ads has to sit next to other channels in one report, several ad accounts need blending into a single sheet, or someone repeats the manual download-and-import routine every week. Below that point, the manual export is free and good enough.

• Compare the hours spent on manual exports each month against the entry price of a connector plan.
• Supermetrics Enterprise and Windsor.ai Enterprise carry pricing on request, as of September 6, 2026.
• Refresh frequency is the clearest differentiator between tiers on both platforms.
• If the sheet is meant to answer marketing ROI questions across channels, the manual route stops scaling first.

Every figure above comes from each vendor's own pricing page on the date shown. For a wider shortlist before committing, see Supermetrics alternatives and Windsor.ai alternatives.

Frequently asked questions about exporting Facebook Ads data to Google Sheets

Here are the questions that come up most when teams move Facebook Ads numbers into Google Sheets: cost, automation, native connectors, mismatched totals, and API access tiers. Each answer below stands on its own and sticks to sourced facts, with AdMetric's pricing as a reference point for teams weighing a full platform against a single connector.