Marketing Data Extractor Icon

Pull Meta Ads Library Data Into Google Sheets - No Code, No API Keys

Paste brand names or Facebook page URLs. Click extract. Get structured ad copy, creative formats, CTA text, and engagement data in your spreadsheet in seconds.

Install Free - 30 Credits every month, No Credit Card Works with any Google account. Free forever tier.
No developer needed
Works in Google Sheets
Free to start
Built on Google Workspace Marketplace
26+ Ad Data Fields Extracted
Free to install, no credit card

The Old Way

  • Open Meta Ads Library in browser, search each competitor brand manually
  • Screenshot ad copy, paste. Copy CTA text, paste. Note formats, paste. Repeat for every ad.
  • Do this for 10 brands. Lose 4 hours. Miss half the ads because pagination is painful.
  • Client asks for a competitor ad audit. Start from scratch again.
  • Try the Meta Ads Library API. Realize you need a verified Meta Business account and developer setup.

~4 hours per week

With Marketing Data Extractor

  1. Paste brand names or Facebook page URLs into a column in Google Sheets
  2. Open the add-on from Extensions, select your data fields and filters
  3. Click "Extract". Ad data populates across all rows instantly.

~60 seconds

(Yes, really.)

Everything You Can Extract from Meta Ads Library

26+ ad data fields. Pull exactly what you need for competitor research, creative intelligence, and ad audits.

Brand Name Lookup

Just type a brand name - the add-on finds their Facebook page automatically, then extracts their active and historical ads. No Facebook page URL hunting required.

Direct Facebook Page URL Mode

Already have the Facebook page URL? Paste it directly and skip the lookup step. Supports facebook.com page URLs. Extracts up to 100 ads per page in a single run.

Bulk Competitor Extraction

Paste a full column of brand names or Facebook page URLs. Extract ad data for all of them in one click. Analyze 10 competitors in the time it used to take to manually browse one.

26+ Customizable Ad Data Fields

Choose exactly what you need: ad copy, CTA text, ad format, active status, start and end dates, platforms, video URLs, image URLs, page likes, IG username, and more. No clutter, no noise.

Active Status, Date & Sort Filters

Filter by active or inactive ads. Set date range - last 7, 14, or 30 days. Sort by impressions (highest first) or most recent. Target exactly the ads that matter for your research.

Image, Video & Carousel Ad Support

Extracts all ad formats - single image, video, and carousel. Carousel ads populate one row per card with individual media URLs, copy, and CTA. Every creative element lands in clean, sortable columns.

3 Meta Ads Workflows Marketers Run Every Week

FOR SOCIAL MEDIA MANAGERS

Competitor Ad Creative Intelligence

You need to know what creatives your top 5 competitors are running right now. Paste their brand names → extract active ads with copy, format, and CTA → spot patterns in what's working → brief your creative team in 20 minutes.

What used to take a full day of manual browsing takes one coffee break.

Saves ~6 hours per campaign brief

FOR MARKETING OPS

Weekly Competitor Ad Tracking System

Monitor 10 competitor Facebook ad accounts weekly. Paste their page URLs → extract new active ads from the last 7 days → drop into your tracking template → see who's scaling spend and what messaging they're testing.

Automated-feeling intelligence. No automation required.

Saves ~3 hours per week

FOR MARKETING AGENCIES

Client Ad Audits & Pitch Research in Minutes

Client needs a competitive paid media audit by Friday. Paste their brand + 5 competitors → extract all active ads with copy and creative data → populate your audit template → present the same day. No developer. No waiting.

Bill the hours. Keep the margin.

Saves ~8 hours per client audit

Pay Only for What You Extract

No monthly subscription. No seat fees. Credits never expire. 1 credit per 10 ads extracted.

Free

$0

30 credits (every month)

  • Works with any Google account
  • Brand name lookup mode
  • Page URL direct mode
  • 26+ ad data fields
  • No credit card required
Install Free
Best Entry Point

Starter

$9 one-time

600 credits

  • Everything in Free
  • Bulk brand/URL processing
  • Active + inactive ad filters
  • Credits never expire
Get Started
Most Popular

Professional

$19 one-time

1,500 credits

  • Everything in Starter
  • Best value per credit
  • One purchase, use for months
  • 1,500 extractions
Get Professional

Need more? Business ($29 / 2,500 credits) and Enterprise ($49 / 4,500 credits) available. See all pricing tiers →

Common Questions

Not at all. If you know how to use Google Sheets, you can use Marketing Data Extractor. There's no terminal, no API keys, no JSON configuration. You paste brand names or page URLs, select your fields, and click extract.

No. The add-on handles all of that behind the scenes. You don't need a Meta developer account, Facebook Business Manager access, or any technical setup. Just your Google account.

Brand Mode lets you type a brand name (e.g. "Nike") and the add-on automatically finds their Facebook page, then extracts their ads. It costs 1 credit per brand for the lookup, then credits based on ads extracted. Page URL Mode is for when you already have the Facebook page URL - it skips the lookup step and goes straight to extraction. Use Brand Mode for discovery, Page URL Mode for speed.

Up to 100 ads per brand or Facebook page per extraction. You can filter by active or inactive ads, set the date range (last 7, 14, or 30 days), and sort by most impressions or most recent. Carousel ads produce one row per card, so a single carousel ad may generate multiple rows.

Credits are charged based on the actual number of ads returned. The rate is 1 credit per 10 ads extracted, rounded up. If a brand returns 0 ads, you are not charged for that page. Brand name lookups cost 1 additional credit per brand regardless of result.

No. Credits are permanent. Buy once, use whenever. There's no subscription and no monthly lock-in. Your $9 starter credits will still be there 6 months from now if you haven't used them.

Yes. The Meta Ads Library is a publicly accessible transparency tool created by Meta. It shows all active and inactive ads running across Facebook, Instagram, and Audience Network. The data extracted is the same data visible to anyone at facebook.com/ads/library without logging in. No private or personal data is accessed.

Start Extracting Meta Ads Data in 60 Seconds

30 free credits. No credit card. Install directly from Google Workspace Marketplace.

Install Free - No Credit Card

Built by Smacient. Made for marketers.

Contact Us