Whathead
  • Builder
  • MCP server
  • Transfer
  • Guardrails
  • Pricing
  • Blog
  • Docs
Log inSign up free
  1. Home
  2. Google Sheets add-on
  3. Google Sheets connector: Facebook Ads
Google Sheets connector: Facebook Ads

Facebook Ads reports in Google Sheets

Whathead for Google Sheets pulls Facebook and Instagram ad data from the Meta Marketing API straight into your spreadsheet. Pick accounts, metrics, dimensions, breakdowns and dates in a sidebar; the table lands at the cell you choose and can refresh on a schedule. It covers 286 Meta metrics and 104 dimensions, with Ads Manager-matching attribution by default. The add-on is free to install; queries need a Whathead trial or plan.

Updated 18 Nov 2026
Get the Sheets add-onSee pricing
Source
Meta Marketing API v25.0
Fields
286 metrics, 104 dimensions
Accounts per query
Up to 100
Granularity
Total, daily or hourly
Refresh
Manual or scheduled: hourly, daily, weekly, monthly
Availability
Marketplace listing pending; access via support
On this page
What you can report onBreakdowns and attribution that match Ads ManagerNumbers that add upSet up a Facebook Ads reportAvailability and permissionsFAQRelated

What you can report on

GroupExamples
Delivery and costImpressions, reach, frequency, amount spent, CPM, cost per 1,000 people reached
ClicksLink clicks, CTR, CPC, outbound clicks, unique clicks, landing page views and cost per view
Conversions (186 fields)Purchases, purchase value and ROAS split into website, app, on-Facebook and offline; adds to cart, leads, registrations
Video3-second plays, ThruPlays, 2-second continuous plays, 25% to 100% plays, average play time
Engagement and messagingPost engagements, reactions, comments, shares, saves, messaging conversations started
StructureCampaign, ad set and ad IDs, names, statuses, objective, optimization goal, bid strategy, budgets, dates
CreativeAd body, title, call to action, thumbnail and image URL, destination URL, URL tags, parsed UTM source, medium, campaign, content and term, Instagram post link, preview link
DiagnosticsQuality, engagement rate and conversion rate rankings
Dynamic creativePer-asset rows for body, title, image, video, CTA and link assets

Breakdowns and attribution that match Ads Manager

Split any query by age, gender, country, region, publisher platform, platform position, placement, impression device or action type, and by combinations Meta allows such as action type by age by gender. Whathead picks the right Meta breakdown for the fields you choose, so you do not need to know which pairs the API accepts.

The conversion window defaults to each ad set's own attribution setting, the same as Ads Manager. You can switch a query to 1-day, 7-day or 28-day click, 1-day view, 1-day engaged-view, or combinations such as 7-day click or 1-day view. Conversion time can follow Meta's default, the impression, the conversion, or the mixed mode.

Numbers that add up

Ratios such as CTR, CPC, CPM and ROAS are recalculated from their parts, so totals and subtotals stay correct instead of averaging averages. Names are attributes of IDs, so a renamed campaign does not split into two rows. Long date ranges are split into the request sizes Meta accepts and joined back.

Set up a Facebook Ads report

  1. Connect Meta in Whathead

    Connect your Meta ad accounts in your Whathead workspace. The add-on can only read accounts the workspace already has.

  2. Open the sidebar

    In Google Sheets: Extensions, Whathead for Google Sheets, Launch sidebar, then sign in.

  3. Build the query

    Select the start cell, choose Facebook Ads, accounts, metrics, dimensions and dates. Add filters or a comparison period if you need them.

  4. Schedule it

    Refresh one query, the sheet or the whole spreadsheet from the menu, or schedule up to 5 refreshes per spreadsheet. Schedules run on Whathead servers, so the file does not need to be open.

Availability and permissions

The public Google Workspace Marketplace listing for Whathead for Google Sheets is not live yet. Until it is, email [email protected] from the address on your Whathead account and the team will help you get access. The add-on asks for three Google permissions: the current spreadsheet only, its sidebar, and calls to www.whathead.com. It does not read your Drive, Gmail or other spreadsheets.

Frequently asked questions

Is the Facebook Ads connector free?

The add-on is free to install. Running queries needs a Whathead account with an active trial or any paid plan; plans start at $29 a month with a 14-day free trial.

Will the numbers match Ads Manager?

With the default conversion window, Whathead asks Meta to use each ad set's own attribution setting, which is what Ads Manager shows. Different windows will give different conversion counts.

Can I combine several ad accounts in one table?

Yes, up to 100 Meta ad accounts per query. Account ID, name, currency and timezone are available as dimensions.

Can I get hourly data?

Yes. Choose hourly granularity. The hour dimension is in the viewer's time zone, as Meta reports it.

Does it overwrite my own cells?

No. Before writing, the add-on checks the target range and asks before overwriting cells that are not part of a Whathead query.

Can I pull TikTok or Snapchat into the same spreadsheet?

Yes. Each query picks its own source, and the add-on supports 14 sources including TikTok, Snapchat, Google Ads and GA4.

Related

  • Whathead for Google Sheets
  • TikTok Ads to Google Sheets
  • Snapchat Ads to Google Sheets
  • Looker Studio connector
  • Supermetrics alternative
  • Meta Ads MCP

Run it from one workspace

Every plan starts with a 14-day free trial. Only successful live work is metered.

Get the Sheets add-onCompare plans
Whathead© 2026 Whathead. Multi-platform ad operations and an Ads MCP server.
Product
PricingMCP serverMeta Ads MCPGoogle Ads MCPCross-platform transferAd anomaly detectionServer-side trackingGoogle Sheets add-onLooker Studio connector
Compare
Supermetrics alternativePipeboard alternativeRyze AI alternativeWhathead vs Meta’s official MCP
Resources
BlogDocsAboutSupportContact
Legal
Terms of ServicePrivacy PolicyRefundsSecurity & DataLog in