Facebook Ads connector for Google Sheets: Meta Ads on a schedule

What you can pull from Meta Ads

This Facebook Ads connector works one level at a time: ad account, campaign, ad set or ad. Each row is one of them, with the fields you choose, by day or as a total over your date range.

Names and IDs are available down to the level you choose. Money is in your ad account's currency, and days are in its time zone.

Columns Meta Ads writes to Google Sheets

Row one holds the column names. Money shows its currency symbol when a report has only one currency.

Column	Format	Available at
Day	Date	Every level
Ad account	Text	Every level
Ad account ID	Text	Every level
Campaign	Text	Campaign, Ad set, Ad
Campaign ID	Text	Campaign, Ad set, Ad
Ad set	Text	Ad set, Ad
Ad set ID	Text	Ad set, Ad
Ad	Text	Ad
Ad ID	Text	Ad
Impressions	Whole number	Every level
Reach	Whole number	Every level
Frequency	Number	Every level
Clicks (all)	Whole number	Every level
Amount spent	Money	Every level
CPC (all)	Money	Every level
CPM (cost per 1,000 impressions)	Money	Every level

Yesterday's spend, already in the tab

06:30

Meta Ads, written to Campaign spend

Prospecting £524.80

Retargeting £351.20

Lookalikes £236.45

Brand video £104.10

Each report owns a tab, and everything in it is replaced on every refresh. Nothing else in the spreadsheet is touched.

Also works with BigQuery, Excel and Claude.

Three things to choose, once

On the Sources page, choose Connect Meta and sign in with the Facebook account you use in Meta Ads Manager.
Pick Meta Ads, the ad account, a level, the fields you want and a date range.
Choose the tab, worksheet or table it writes to, and how often it refreshes.

Try it with your own Meta Ads data.

Start free trial

Or install the Google Sheets add-on

Other ways to do it

Meta Ads Manager can export your reporting table as a CSV or Excel file, and email it on a schedule to people who have access to the ad account.

Source: Meta Business Help: Export performance data in Meta Ads Manager; Meta Business Help: Export and share data

Fresh Sheets writes the figures straight into your tab instead.

What this doesn't cover

Lead form submissions and organic Facebook and Instagram posts aren't included. This reads Meta Ads reporting only.

Guides that use Meta Ads

Show all 18 Meta Ads guides

What it can see, and what it cannot

You connect Meta Ads by signing in with Facebook on Meta's own page. Fresh Sheets asks Meta for one permission, ads_read, and never for permission to manage your ads.

Our code only ever reads from Meta. Besides read requests, it sends Meta only the requests that complete your sign-in and, when you remove the connection or delete your account, the request that ends Fresh Sheets' access. It refuses anything else before the request is sent, and never creates, edits or pauses a campaign, an ad set or an ad.

The access Meta grants is stored encrypted and is never shown to anyone. It has no fixed end date: it lasts until you remove it on the Sources page, or until Meta ends it. If Meta ends it, 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. Removing it there asks Meta to end Fresh Sheets' access, stops the reports that read through it, and leaves what they already wrote in your spreadsheets.

Fresh Sheets never changes anything you did not ask it to.

Your data is never sold and never used to train anything.

How we handle your data

Start on Plus, and decide later

Then one report keeps refreshing weekly.

How often depends on your plan: every week on Free, every day on Plus, every 6 hours on Pro and every hour on Max.

See what the paid plans include

Questions

Does it change anything in my ad account?

No. Fresh Sheets only reads from Meta. It never creates, edits or pauses a campaign, an ad set or an ad.

Which ad accounts can it read?

The ad accounts the Facebook account you connect with can see in Meta Ads Manager. You choose one ad account for each report.

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

Can I send lead form submissions to Google Sheets?

Yes, with Meta's own tool rather than this one. Meta lets you connect Google Sheets directly to Meta, and new leads from your instant forms are then added to the spreadsheet automatically. Fresh Sheets reads ad performance, such as spend, reach and clicks, and never lead form submissions.

Source: Meta Business Help: Download or retrieve your leads data from Meta

What currency are the figures in?

Your ad account's own currency. Days are in your ad account's time zone.

How often can it refresh?

Daily on Plus, every 6 hours on Pro and every hour on Max. On Free, one report refreshes weekly.

How many rows can a report have?

Up to 10,000 rows a run. A report that would return more doesn't run, and tells you to choose a shorter range or a higher level.