Facebook Ads to Google Sheets and Looker Studio: reports

Which route fits your reporting job?

Decide whether you need a one-off file, recurring email or automatically updated table. Each requires a different workflow.

Define a useful row before choosing a tool. For a campaign report, consider a daily row with account ID, campaign ID, campaign name, currency, spend, the named result metric and its count; this is a suggested reporting design, not a required Meta schema.

If you want people’s contact information rather than performance metrics, use Facebook lead ads to Google Sheets. This guide concerns spend and outcomes at reporting level.

How do you build the manual baseline?

Keep a manual export as your baseline. Compare it with the sheet before debugging the loader and dashboard.

As of November 2026, Meta documents the following export procedure for saved reports. [1]

1. Open Ads Reporting.
2. Open the saved report by clicking its name.
3. Check the report’s date range and selected metrics.
4. Click Export.
5. Select CSV or XLSX as the required format.

For a new report, Meta documents Ads Manager > Reports > Create report, followed by selecting the ad accounts, Create, a layout and Continue. Configure the report for your question before saving and exporting it. [13]

Google’s current import labels are File > Import, Upload, Select a file from your device, Import location, Separator type and Import data. These labels were read November 4, 2026. [14]

Choose deliberately whether an import replaces a previous snapshot or adds a new period. Keep overlapping exports out of a summed reporting table unless your process updates the existing rows; otherwise the same period can be counted twice.

Assign an import owner and display the last successful update. This route avoids a separate connector subscription.

What does Meta’s scheduled reporting automate?

Meta Ads Reporting supports recurring reports emailed to you and colleagues. Its overview describes customizing the report’s metrics and breakdowns, then scheduling the recurring email. [4]

An emailed report is not a live sheet connection. Verify how the data reaches its actual destination after each scheduled run.

Meta’s public pages read for this article did not establish a universal direct-to-Google-Sheets performance-report schedule or a consistent current scheduling-button sequence. We therefore do not supply invented buttons for such a setup.

Keep recurring email if it meets your need. For an interactive report, choose a loading workflow and use the client reporting guide to define its contents.

Can an automatic workflow stay free?

Make documents a Facebook Insights app that retrieves insights and reporting job results. Its connection setup uses a Facebook Insights module, Create a connection and Save, followed by account authentication when prompted; these labels were checked November 4, 2026. [7]

Request your chosen metrics and update sheet rows by account, campaign and date. A rerun should update the matching row, not add a copy.

Make Free includes 1,000 credits per month and a 15-minute minimum scheduling interval. The live pricing page displayed Core at US$9 per month for 10,000 monthly credits with Annual billing selected, read November 4, 2026; this is a paid annual-billing price, not a month-to-month quote. [6]

Measure actual credit use: Make says module actions consume credits and workflows stop when credits run out. No fixed campaign or refresh count is guaranteed. [6]

For an already configured workflow, Make’s documented scheduling controls are Scenario Builder > Every 15 minutes, then a schedule such as Daily. Its tutorial uses Save and Activate scenario to finish activation; choose your actual reporting time and verify the next run. [8] [15]

Zapier documents Create Ad Statistics Report in Facebook Lead Ads (for Business Admins), which is a premium app. Its Professional starting price displayed US$19.99 per month with yearly billing on November 4, 2026; the ordinary Free plan does not make that app free. [9] [10]

Verify the action’s metrics and reporting level. Its name does not guarantee every field.

n8n offers a free self-hosted Community edition and a Graph API node. You maintain credentials, requests, hosting and failure handling. [11] [12]

How does the sheet become a Looker Studio report?

Google’s current name is Data Studio, formerly Looker Studio, and its standard visualization product is available at no cost. Its first-party connector catalog includes Google Sheets, Google Ads and Analytics, but does not list Meta Ads; community connectors are a separate category. [3] [5]

Use the following documented English labels, read November 4, 2026, once your sheet contains the required table. [2]

1. Sign in to Data Studio.
2. Click Create.
3. Select Data Source.
4. Select Google Sheets.
5. Select the Spreadsheet.
6. Select the Worksheet.
7. Click CONNECT.
8. Click CREATE REPORT.
9. Click ADD TO REPORT.

Google says a Sheets data source connects to one worksheet. Use one header row and keep each column’s data type consistent; check that dates and spend were recognized correctly before designing charts. [2]

Google Cloud’s separate MetaAds Integration Connector requires cloud-project and service-account configuration. It is not a first-party Data Studio connector. [16]

Why can the finished numbers disagree?

Compare the same account, dates, currency, reporting level and result definition at each stage. Preserve the result’s name alongside its count, so a report never adds unlike outcomes under an unexplained Results heading.

For an aggregated cost per result, divide total spend by the total count of the same result. Do not average campaign-level cost-per-result values: that gives each campaign equal weight regardless of how many outcomes it produced.

Keep different currencies separate unless your report has an explicit conversion policy. Also record when each source was retrieved, so readers can distinguish a frozen export from a refreshed dataset.

Compare the Meta export, loading run, saved sheet row and chart filters in that order. Record where the first difference appears.

For interpreting the underlying metrics, see how to read a Facebook Ads report. For business results beyond the selected ad-platform outcome, use matching CRM sales to Facebook ads.

What to do next

Export one report and use it to establish a reconciled sheet. If recurring updates justify the setup, test one automatic reporting workflow and inspect its actual usage, saved rows and update time.

Connect the verified worksheet to Data Studio and check the displayed totals against the baseline. Assign someone to monitor failed loads so a working chart does not hide stale data.

Where Variafy fits

For a scheduled Sheet or dashboard, complete the loading route above. If you want to read ad data in ChatGPT or Claude, Variafy connects your ad accounts to the assistant, with data reading free. It is in a free beta by invitation; sign-up is closed. Join the waitlist.

How we checked

Questions

Related guides

• Facebook lead ads to Google Sheets: free ways that work in 2026
• Facebook ads report for clients: what to send every week
• How to read a Facebook ads report: what each column means and what to check first
• Which Facebook ads bring paying customers: matching CRM sales to ads