How to connect Facebook Ads to Google Sheets
Export your reporting table from Meta Ads Manager and import the file, or connect Facebook Ads to Google Sheets with Fresh Sheets so your Meta Ads spend, reach and clicks refresh in a tab on a schedule.
Last checked 25 Oct 2026
About the Meta Ads connectorWays to get Meta Ads data into Google Sheets
| Method | Refreshes | Cost | Limit |
|---|---|---|---|
| Export from Ads Manager | No | Free | A file to import each time |
| Scheduled export by email | Yes, by email | Free | A file, by email |
| Fresh Sheets | On your schedule | Free for 30 days, then one weekly report free. Paid plans from £12 a month, billed annually. | Up to 10,000 rows a run |
Export from Ads Manager
To export Facebook Ads data once, download it from Ads Manager's reporting table.
- In Meta Ads Manager, open your campaigns, ad sets or ads.
- Click the arrow next to the download button, then choose Export as .csv or Export as .xlsx.
- In Google Sheets, choose File, then Import, and upload the file.
The quick Export button leaves out deleted campaigns, and Meta's reporting window reaches back 37 months from the day you ask.
Source: Meta Business Help: Export performance data in Meta Ads Manager; Meta Business Help: Export and share data; Import data sets and spreadsheets, Google Docs Editors Help
Schedule an export by email
Choose Schedule export from the same menu, and Meta emails the data on a schedule to people who have access to the ad account. It's still a file someone has to bring into the spreadsheet.
Source: Meta Business Help: Export performance data in Meta Ads Manager; Meta Business Help: Run a recurring report and send it to different email addresses
How to connect Facebook Ads to Google Sheets with Fresh Sheets
Facebook Ads is called Meta Ads in Meta's own tools, so getting Meta Ads to Google Sheets works exactly the same way.
- Click Start free and sign in with Google.
- In your Fresh Sheets account, on the Sources page, choose Connect Meta and sign in with the Facebook account you use in Meta Ads Manager.
- Under Source, pick Meta Ads and the ad account.
- Under Data, pick the level, fields and dates.
- Under Destination, choose Connect Google if it asks, then pick a spreadsheet from your Google Drive or create a new one, and name the tab.
- Under Schedule, pick how often, then Save and run.
Prefer to work inside Google Sheets? Install the add-on from the Google Workspace Marketplace and build the same report from Extensions, then Fresh Sheets, then Open sidebar.
Fresh Sheets writes a Meta Ads report into a tab of its own and refreshes it on the schedule you choose. Fresh Sheets replaces that tab's contents on every refresh, so keep your own formulas on another tab.
Every column it can write is listed on the Meta Ads connector page.
Want it in Excel instead? See Facebook Ads to Excel.
Worked example: CPC by campaign
A campaign report with Amount spent and Clicks (all) writes these columns, in this order, into a tab called CPC by campaign:
| A | B | C |
|---|---|---|
| Campaign | Clicks (all) | Amount spent |
On another tab, each row's CPC is:
='CPC by campaign'!C2/'CPC by campaign'!B2
And the CPC across every row:
=SUM('CPC by campaign'!C2:C)/SUM('CPC by campaign'!B2:B)Use the totals, not the average of the row figures.
Questions
Can I send lead form submissions to Google Sheets?
Yes, with Meta's own tool rather than Fresh Sheets. Meta lets you connect Google Sheets directly to Meta, and new leads from your instant forms are then added to the spreadsheet automatically. That sync carries leads, not ad performance.
Source: Meta Business Help: Download or retrieve your leads data from Meta
Does it refresh automatically?
With Fresh Sheets, yes. Choose how often when you build the report, and it runs on our servers from then on. How often depends on your plan: every week on Free, every day on Plus, every 6 hours on Pro and every hour on Max.
Does the connection expire?
Meta's access has no fixed end date. It lasts until you remove it on the Sources page, or until Meta ends it, for example if you change your Facebook password or for security reasons. If that happens, your Meta reports stop at their next run and, if any are scheduled, we email you. Choose Reconnect Meta on the Sources page with the same Facebook account and they start again.
Source: Meta for Developers: Access tokens, debugging and error handling
What access do I need to the ad account?
The Facebook account you connect with needs access to the ad account in Meta Ads Manager.
How far back can I get Facebook Ads data?
Ads Manager exports reach back 37 months from the day you ask. A Fresh Sheets report covers the date range you choose, within the history Meta keeps.
Source: Meta Business Help: Export and share data; Meta for Developers: Ads Insights API metric availability updates
Is there a Facebook Ads Google Sheets add-on?
Yes: Fresh Sheets. Install it from the Google Workspace Marketplace, then build the report from Extensions, then Fresh Sheets, then Open sidebar. Or build it on the website and pick the spreadsheet there.
Related guides
How to connect TikTok Ads to Google Sheets
Run a custom report in TikTok Ads Manager, or have spend and conversions land in a spreadsheet on a schedule.
How to connect Google Ads to Google Sheets
Downloads, emailed reports, scripts, and a report that updates itself.
How to connect GA4 to Google Sheets
Every way, from a one-off export to a report that keeps itself current.