Facebook Ads to Google Sheets

Five steps, and you only do them once.

1. Install SyncWith for Google Sheets.
2. Choose Facebook Ads as the source and sign in with Facebook. One report can take every ad account that login can see, so all your clients fit in one sheet.
3. Pick your columns: Account name, Campaign name and Day, then metrics such as Amount spent, Link clicks, Results and Cost per result.
4. Pick a date range, such as Last 30 days, and how new data lands: replace the sheet, add rows below, or update the rows already there.
5. Set it to refresh hourly, daily, weekly or monthly.

Not directly. Meta does have a Google Sheets connection, but it's for lead forms: it adds leads from your Instant forms to a sheet, and you update a lead_status column so Meta learns which leads became customers. Spend, clicks and results don't go through it.

For ad results, Meta's own route is a file. In Ads Reporting you export a report as XLSX or CSV and import it into Sheets yourself, every time you want new numbers. You can also schedule a report by email, but only for one ad account at a time, and only people with access to that ad account can open it.

That's fine for one account and a monthly check-in. With five clients on weekly reports, it's five separate emails or a fresh export every week, pasted in by hand. In SyncWith, it's one report that fills itself in. Want the leads in a sheet too? The add-on has a separate Facebook Leads source.

Keep Account name as a column, so every row says which client it's from. Set the report to refresh weekly and choose add rows, so last week's numbers stay in the sheet when this week's arrive. Then build each client's summary tab on top of that data.

Many people refresh far more often than weekly. In Q3 2026, 15,251 active Facebook Ads reports in SyncWith's Google Sheets add-on and Looker Studio connectors refreshed 1,560,323 times, a little more than once a day each on average.

Yes. The free Hobby plan gives you 35 refreshes a month with no credit card, and a weekly report uses 4 or 5 of them. The Business plan is $24.99 a month for 100 refreshes. See all plans.