The Scenario
You run performance marketing at a SaaS company and you've been asked to put together a competitive creative report before the quarterly review. Twenty-five direct competitors. You want to catalog their Google Display ad formats — what's the ratio of text ads to image ads, what copy angles are they using, which advertisers are running the most volume.
Your team used to do this by hand. Someone would spend a day in the Google Ad Transparency Center searching domains, downloading what they could find, and building a spreadsheet. The last time it happened, the spreadsheet arrived the morning of the quarterly review with 8 of the 25 domains missing and no consistent column structure.
The bad version:
- Open the Ad Transparency Center, search the first competitor domain, note the ad text, ad type, and advertiser info in your Google Sheet
- Move to the next domain, discover it has 40+ ads and you have to decide which ones to capture, make an arbitrary call, continue
- Finish 15 of the 25 domains before realizing you forgot to capture the advertiser name for the first 10 — go back and re-pull those rows
The quarterly review is in two days. This was supposed to be background research, not a project.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the competitor domain list in your sheet and connects to Adyntel to pull Google Display ad data — ad text, ad type, advertiser — for every row, consistently, in one pass.
With your 25 competitor domains in column A:
Pull Google ads for every domain in column A using Adyntel and write the ad text, ad type, and advertiser to columns B, C, and D
What You Get
- Column B: ad text for each domain's active Google Display ads
- Column C: ad type (text, image, responsive display, etc.)
- Column D: advertiser name as returned by Adyntel
- Domains with no active Google ads get a clear label in the row — no ambiguous blanks in the dataset
What If the Data Is Not Quite Ready
You want to count text ads vs image ads per domain rather than list individual creatives
Fetch Google ads for each competitor domain in column A using Adyntel and count how many are text ads vs image ads — write the text ad count to column B and the image ad count to column C
Some entries in your list are brand names, not domains — you need to normalize them first
For each entry in column A, convert brand names to their primary domain (e.g., 'Notion' → 'notion.so') where possible, then pull Google Display ads from Adyntel and write ad text, ad type, and advertiser to columns B, C, and D
You want to flag domains where image ads significantly outnumber text ads — potential signal of creative maturity
Pull Google ads for each domain in column A using Adyntel, write the text ad count to column B and image ad count to column C, and flag in column D any domain where image ads are more than 3x the text ad count as 'creative-heavy'
One prompt that pulls, counts, flags, and adds a one-line strategic note per domain
For each domain in column A, pull Google Display ads via Adyntel; write text ad count to column B and image ad count to column C; flag 'creative-heavy' in column D if image ads outnumber text ads 3:1 or more; and add a one-line strategic note in column E based on the ratio — e.g. 'investing in visual creative', 'relying on search copy', or 'balanced mix'
One pass. The quarterly deck has what it needs.
Try It
Get the 7-day free trial of SheetXAI and open your competitor domain list in Google Sheets, then ask it to pull Google Display ad data from Adyntel for every row. Also useful: pulling LinkedIn ad creatives and the full Adyntel integration guide.