Connect Meta Ad Library (Facebook Ad Library) to Google Sheets

Claude.ai & MCP supported — another step towards a more powerful AdzviserRead Me

Why this connection

Why Export the Meta Ad Library to Google Sheets?

Export the Meta Ad Library, also known as the Facebook Ad Library, to Google Sheets through Adzviser to work with any advertiser's public ad data in a familiar spreadsheet. Pull creative bodies, link titles, captions, and descriptions by country, then sort, filter, and analyze how competitors evolve their messaging over time.

What you can do

Competitor Ad Monitoring

Export a brand's active ads across Facebook and Instagram to a sheet and track what they're running right now

Creative & Copy Analysis

Break down ad creative bodies, link titles, captions, and descriptions cell by cell to understand what's working

Messaging Angles

Sort and filter recurring hooks, offers, and value props to sharpen your own positioning

Country Coverage

Pivot on the countries a brand runs ads in to map their market focus and expansion

AFTER SETUP

Keep your Meta Ad Library reporting current in Google Sheets

Once the connection is active, define the table once, schedule its refresh, and keep your formulas, pivot tables, and charts in the same spreadsheet.

REPORT DESIGN

Choose the report structure

Select the connected account, reporting period, metrics, and breakdowns the sheet needs. Save the query so the same table can be refreshed again.

AUTOMATION

Set the refresh schedule

Choose when Adzviser should update the query so the report follows your regular reporting cadence.

IN-SHEET ANALYSIS

Build on the returned table

Add formulas, pivot tables, charts, targets, or notes without repeating the original data export.

GOOGLE SHEETS TEMPLATES

Use a ready-made Google Sheets reporting template

Browse Adzviser’s free spreadsheet templates for reporting layouts you can adapt to Meta Ad Library. The catalog grows as new source-specific templates are released.

Free template libraryBrowse Google Sheets templates

Reporting coverage

Meta Ad Library reporting coverage for Google Sheets

244selectable countries/regions

7available breakdowns

Complete coverageBrowse all regions & breakdowns

Setup guide

How to Connect Meta Ad Library to Google Sheets

Set up your Meta Ad Library to Google Sheets integration in minutes with Adzviser's no-code connector.

Sign Up for Adzviser

Create an Adzviser account or log in if you already have one. The Meta Ad Library is free for every subscriber.

Pick a Competitor & Country

Choose the advertiser or Facebook Page you want to research and the country to search. There's no account to connect and no workspace to set up.

Choose Google Sheets as Your Destination

Select Google Sheets as your destination and start exporting public ad data.

Export Competitor Ads to Your Spreadsheet

Send a competitor's live ads and creatives straight to Google Sheets. Sort, filter, and analyze their hooks, offers, and messaging angles with formulas and pivot tables.

Trusted by Agencies, Freelancers, and Founders

See how marketers are using Adzviser to automate their Meta Ad Library reporting in Google Sheets.

Ryan Whiteside

Adzviser is the Supermetrics replacement we've been looking for. Adzviser delivers the same essential functionality at a much better price point, with far superior customer support. The added bonus of a ChatGPT connector allows for seamless data analysis in a way that enhances workflow efficiency.

Digital Marketing DirectorTwo Wheels Marketing

Jared Laidlaw

I appreciate Adzviser's per-client workspace setup, which simplifies organizing data sources compared to setting them up via channels. The customer support is excellent and responsive, addressing my issues swiftly. The pricing is competitive and scales nicely with business growth, which is crucial for me.

Managing DirectorOrchard Financial Marketing

Adam Orris

It is so simple to create your integration with all the supplied connectors. I also love the ability to send data to Gsheets and Looker for automation. The best part is being able to chat with your data inside of ChatGPT's. Adzviser really helps you along the way as well. The customer support is superb.

Director of Data and AnalyticsDisruptive Advertising

Saar Bell

Adzviser completely transformed the way I handle marketing data! Connecting all my sources to Google Sheets, Looker, and ChatGPT was unbelievably simple — no endless setup or technical headaches. Everything runs fast, accurate, and at a fraction of the cost compared to other tools I’ve tried. The customer support is extremely personal and responsive.

Company OwnerBellaPOINT

Powering data-driven decisions for 15K+ companies across 100 countries

Meta Ad Library to Google Sheets Integration FAQs

Connecting Meta Ad Library to Google Sheets is simple with Adzviser. Sign up, start your $0.99 trial to create a workspace, select Meta Ad Library as your data source, choose Google Sheets as your destination, and your data will sync automatically. No coding required. View Google Sheets Setup Guide →

With Adzviser, you can export all standard Meta Ad Library metrics including impressions, clicks, conversions, and other key performance metrics. Choose any combination of metrics and breakdowns to export. View all Meta Ad Library metrics and breakdowns →

Yes! Adzviser supports scheduled data refreshes to keep your Google Sheets reports up-to-date with the latest Meta Ad Library data automatically. View all Google Sheets integrations →

With Adzviser's no-code connector, you can set up your Meta Ad Library to Google Sheets integration in just a few minutes. Most users complete the setup in under 5 minutes.

Adzviser offers a $0.99 14-day trial to get started. All plans include unlimited account connections, unlimited data exports, and access to all destinations. After the trial, pricing is based on the number of data sources you use. View pricing details →

Yes! Adzviser supports Microsoft Excel as a destination. You can export your Meta Ad Library data directly to Excel using our Excel add-in. Perfect for offline analysis and sharing with stakeholders who prefer Excel workbooks. Connect Meta Ad Library to Excel →

Yes! Adzviser offers a library of ready-to-use AI prompts specifically designed for Meta Ad Library. These prompts cover reporting, optimization, analysis, and auditing — customize them with your account name and date range, then paste into Google Sheets. Browse Meta Ad Library AI prompts →

Yes. The Meta Ad Library is also known as the Facebook Ad Library. It's Meta's public, free tool for researching ads running across Facebook and Instagram.

Yes—the Meta Ad Library is free for all Adzviser subscribers. There's no account to connect and no workspace to create, just fair per-user rate limits.

You can export public ad data: ad creative bodies, link titles, captions, and descriptions, the Facebook Page name, the ad creation time, and the country an ad runs in. Private spend and performance metrics are not available.

Export Meta Ad Library Data to Google Sheets