Is this Google Ads Transparency Center scraper free?

Yes. Running it on this page is free and shows up to 5 ads per advertiser link. To get more ads in Google Sheets, install SheetMagic free. The free plan includes 100 one-time scraping credits, and each ad costs 5 credits.

Is it allowed to scrape the Google Ads Transparency Center?

Google publishes these ads publicly so anyone can see who is advertising and what they show. The scraper reads the public pages signed out. How you use the data is your responsibility, so check Google's terms and your local rules for your use case.

What link do I need, and why does a company name not work?

You need an advertiser link that contains /advertiser/AR followed by digits. Search the company on adstransparency.google.com, pick the right advertiser (big brands often have several) and copy the address bar. A company name, domain or website returns no ads.

How many ads can I get?

This page shows up to 5 ads per run. In Google Sheets you set the most ads to return in the GOOGLEADS formula, and one run takes up to 20 advertiser links. A large advertiser can have thousands of ads, so set a limit that fits your credits.

What data fields do I get for each ad?

Each row has the advertiser, ad copy, format, first shown and last shown dates, countries, a creative preview link, the ad URL, the creative ID, the advertiser ID and the advertiser page link.

How do I get Google Ads Transparency data into Google Sheets?

Install SheetMagic from the Google Workspace Marketplace, put the advertiser link in a cell and type =GOOGLEADS(A2, 50) next to it. The ads fill the sheet from that cell, one ad per row.

Scrape the Google Ads Transparency Center into Google Sheets

Paste an advertiser link from the Google Ads Transparency Center and see up to 5 of their ads here, with ad copy, format, first and last shown dates and countries. Install SheetMagic free to get every ad in Google Sheets.

Your results

Run a search above. The rows land in this sheet.

Row	Advertiser	Ad Copy	Format	First Shown	Last Shown	Countries	Creative Preview	Ad URL	Creative ID	Advertiser ID	Advertiser Page
1
2
3
4
5
6
7
8

Install SheetMagic to get every result in Google Sheets

The same scraper runs from a formula in your sheet and writes every row there. The free plan includes 100 one-time scraping credits.

Install free for Google Sheets

Free Google Ads Transparency Center scraper for Google Sheets, in short

Open adstransparency.google.com, search the company, pick the advertiser and copy the link (it contains /advertiser/AR followed by digits). Paste it here to see up to 5 ads with copy, format, dates and countries. To get every ad into Google Sheets, install SheetMagic free and use the GOOGLEADS formula with that link.

11 columns for every result

Each result is one row, with these columns in this order. Fields the source does not show stay blank.

Advertiser
Ad Copy
Format
First Shown
Last Shown
Countries
Creative Preview
Ad URL
Creative ID
Advertiser ID
Advertiser Page

From this page to your sheet

1. Paste an advertiser link and run it here
Find the advertiser on adstransparency.google.com, copy the link from the address bar and paste it above. You see up to 5 ads with their copy, format, dates and countries.
2. Install SheetMagic for Google Sheets
Add SheetMagic from the Google Workspace Marketplace. The free plan includes 100 one-time scraping credits, no card needed.
3. Get every ad in your sheet
Type =GOOGLEADS with the advertiser link in a cell. The ads fill the sheet from that cell, one ad per row.

Who uses it, and for what

Competitor ad research for agencies

Put each competitor's advertiser link in a column and pull their ads into one sheet. Compare ad copy, formats and the countries they target before a client pitch.

Tracking how long ads run

First Shown and Last Shown tell you which ads a competitor has kept running. An ad that stays live for months is usually one worth studying.

Building a swipe file

Collect ad copy and creative preview links from the brands you admire in one sheet, then filter by format or country when you write your own ads.

The same thing, inside Google Sheets

A2 holds an Ads Transparency Center advertiser link and 50 is the most ads to return. Results fill the sheet from the formula's cell, one ad per row. Each ad costs 5 scraping credits, so the free plan's 100 one-time credits cover about 20 ads.

=GOOGLEADS(A2, 50)

Type it in any cell once SheetMagic is installed.

Other ways to do it

Copy and paste from the Transparency Center: Free, but you open ads one at a time and retype the copy, dates and countries. Fine for a handful of ads, slow for a competitor set.
IMPORTXML in Google Sheets: Free, but the Transparency Center builds its pages with JavaScript, so IMPORTXML gets little or nothing back.
A standalone scraper tool: Can pull the ads, but you run it in another app and export a file back into your sheet each time.
SheetMagic GOOGLEADS formula: One formula in a cell, the ads land in your sheet, and you never leave it. Uses scraping credits per ad.

Questions

Is this Google Ads Transparency Center scraper free?: Yes. Running it on this page is free and shows up to 5 ads per advertiser link. To get more ads in Google Sheets, install SheetMagic free. The free plan includes 100 one-time scraping credits, and each ad costs 5 credits.
Is it allowed to scrape the Google Ads Transparency Center?: Google publishes these ads publicly so anyone can see who is advertising and what they show. The scraper reads the public pages signed out. How you use the data is your responsibility, so check Google's terms and your local rules for your use case.
What link do I need, and why does a company name not work?: You need an advertiser link that contains /advertiser/AR followed by digits. Search the company on adstransparency.google.com, pick the right advertiser (big brands often have several) and copy the address bar. A company name, domain or website returns no ads.
How many ads can I get?: This page shows up to 5 ads per run. In Google Sheets you set the most ads to return in the GOOGLEADS formula, and one run takes up to 20 advertiser links. A large advertiser can have thousands of ads, so set a limit that fits your credits.
What data fields do I get for each ad?: Each row has the advertiser, ad copy, format, first shown and last shown dates, countries, a creative preview link, the ad URL, the creative ID, the advertiser ID and the advertiser page link.
How do I get Google Ads Transparency data into Google Sheets?: Install SheetMagic from the Google Workspace Marketplace, put the advertiser link in a cell and type =GOOGLEADS(A2, 50) next to it. The ads fill the sheet from that cell, one ad per row.

All free tools

Free website traffic checkerEnter a website and see its estimated monthly visits, global rank, engagement and where its traffic comes from. Install SheetMagic to get every result as rows in Google Sheets.

Free plan

100scraping credits, one time

Run the full Google Ads Transparency Center scraper in Google Sheets.

Install SheetMagic from the Google Workspace Marketplace. No card, no separate account, and no deadline on the free allowance.