Export Facebook Ads to Google Sheets
Your Facebook and Instagram ad results in a Google Sheet that refreshes itself.
- Refreshed on your schedule.
- Spend, clicks, reach and every action type, ad by ad and day by day.
- Ready-made reports, or your own fields.
Start your free 30-day trial No credit card required
New pipeline
Export data from
- Facebook Ads

- Facebook Lead Ads

- Google Ads

- Google Analytics 4

- Google BigQuery

- Google Sheets

- RTB House

- TikTok Ads

To
- Google BigQuery

- Google Sheets

Set it up once
- Connect Facebook. Pipelinica asks to read your ads and your e-mail address.
- Pick the ad account and a ready-made report, or tick your own fields.
- Pick the spreadsheet and the schedule. The first refresh is queued when you save.
What you get in Google Sheets
- A sheet of its own in the spreadsheet you pick, the newest day on top.
- Columns keep their order, so your charts and pivot tables keep working.
- A failed refresh leaves the sheet as it was, and Pipeline alerts e-mail you.
- Every run reloads at least the last 30 days, so results that arrive late still count.
What you can export from Facebook Ads
Report types: Ads, Ad sets, Campaigns, Account.
Ready-made reports
- Basic Metrics + All actions
- Basic Metrics + All actions (+IDs)
- Basic Metrics + All actions divided by Gender and Age
- Basic Metrics + All actions divided by Country
- Basic Metrics + All actions divided by Platform and Placement
- Video
See all 37 Facebook Ads fields
Dimensions
- Date
- Account ID
- Account name
- Account currency
- Objective
- Campaign ID
- Campaign name
- Ad set ID
- Ad set name
- Ad ID
- Ad name
- Age
- Gender
- Country
- Region
- Device platform
- Platform
- Placement
- Impression device
Metrics
- Impressions
- Clicks (all)
- Link clicks
- Amount spent
- Reach
- Frequency
- Outbound clicks
- Video plays
- Video plays at 25%
- Video plays at 50%
- Video plays at 75%
- Video plays at 95%
- Video plays at 100%
- ThruPlays
- 30-second video plays
- Video average play time
- Actions (a column per action type)
- Action values (a column per action type)
Ratios
Not exported, as rows can't add them up: the setup shows the formula for each.
- CTR (all), %
- CPC (all)
- CPM (cost per 1,000 impressions)
- CTR (link click-through rate), %
- CPC (cost per link click)
- Outbound CTR (click-through rate), %
- Cost per outbound click
- Cost per ThruPlay
- Cost per lead
- Cost per purchase
- Purchase ROAS (return on ad spend)
Questions
Does it include Instagram ads?
Yes. Facebook Ads covers every ad you run in Meta Ads Manager. Add the Platform breakdown to split the results into Facebook, Instagram, Messenger, Audience Network and Threads.
Do I need my own Facebook app or access token?
No. You sign in with Facebook during the setup, and Pipelinica keeps the connection.
Can I export several accounts?
Each pipeline exports one Facebook Ads account to its own sheet. Your plan sets how many pipelines you can run.
Can I add my own formulas to the sheet?
Put them on another sheet that refers to Pipelinica's, since each refresh rewrites its values. Numbers arrive as numbers; dates as YYYY-MM-DD text, which DATEVALUE reads.
Do I need a credit card for the trial?
No. You choose a plan when the trial ends.
More exports: Export Facebook Ads to BigQuery · All connectors
What is the difference between different plans?
Our plans best suit businesses and agencies that want to improve their reporting automation.
-
Starter
$2 / month
- Up to 1 active pipeline
- Up to 7 days of backfill
- Refresh data once a day
- Refresh data every 6 hours
- Manual data refresh
-
Basic
$9 / month
- Up to 5 active pipelines
- Up to 31 days of backfill
- Refresh data once a day
- Refresh data every 6 hours
- Manual data refresh
-
Pro
$49 / month
- Up to 30 active pipelines
- Up to 365 days of backfill
- Refresh data once a day
- Refresh data every 6 hours
- Manual data refresh
-
Premium
$99 / month
- Up to 90 active pipelines
- Up to 3 years of backfill
- Refresh data once a day
- Refresh data every 6 hours
- Manual data refresh