The Scenario
It's mid-July and Q3 creative production starts in two weeks. You've been asked to benchmark 30 competitor Meta ad creatives before the design team gets briefed — which formats are they running, what copy angles are they using, how long do the longer-running ads seem to have been live?
The last time you did this, someone else on the team did it by hand and the sheet came back with 11 domains missing, three where only the image ads were captured and the video ads were skipped, and one domain that was entered twice. You inherited that sheet. You are not doing it that way again.
The bad version:
- Go to the Meta Ad Library, filter by country, search the first domain, scroll through all active ads, copy ad copy and engagement notes into your Google Sheet
- Repeat for the remaining 29 domains, losing your place twice when the Meta library reloads and resets your filters
- Discover that three domains have hundreds of active ads and you've only captured the first page for each — now you have to decide whether to re-pull them or just note the gap
You're a paid social strategist. Your job is to read the data and build a brief from it, not to spend a full day inside Meta's UI copying things by hand.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your domain list and connects to Adyntel to pull active Meta ad data for every row — ad copy, creative type, and engagement metrics — without you touching the Meta Ad Library at all.
With your 30 competitor domains in column A:
For each domain in column A, fetch their Meta ads using Adyntel and write the ad copy, creative type, and engagement metrics to columns B, C, and D
What You Get
- Column B: ad copy text for each domain's active Meta ads
- Column C: creative type (image, video, carousel, story, etc.)
- Column D: engagement metrics as returned by Adyntel
- Rows where a domain has no active Meta ads get a clear label — you're not left guessing whether the blank means "no ads" or "failed to pull"
What If the Data Is Not Quite Ready
Some domains in your list are parent companies — you want ads for specific product brands, not the whole company
For each domain in column A, pull Meta ads using Adyntel; if a domain returns more than 50 active ads, flag it in column E as 'brand umbrella — review manually'; otherwise write ad copy and creative type to columns B and C
You want to flag ads that appear to have been running for more than 30 days as 'evergreen'
For each domain in column A, fetch their Meta ads using Adyntel, write ad copy and creative type to columns B and C, and add a column D label — 'evergreen' if the ad appears to have run longer than 30 days, 'recent' otherwise
Your sheet has two tabs — one for direct competitors and one for adjacent brands — and you want results merged
Pull Meta ads from Adyntel for every domain in both the 'Direct' and 'Adjacent' tabs, combine all results in a new tab called 'Meta Creative Audit', and include a column indicating which tab each domain came from
You want a single prompt that pulls, flags evergreens, and adds a copy angle classification
For each domain in column A, pull Meta ads using Adyntel, write ad copy to column B and creative type to column C, label evergreen ads (30+ days) in column D, and classify the primary copy angle in column E — pick from 'transformation', 'feature', 'social proof', 'price', or 'urgency'
One prompt, one pass, everything you need for the brief.
Try It
Get the 7-day free trial of SheetXAI and open your competitor domain list in Google Sheets, then ask it to pull Meta ad creatives via Adyntel for every row. See also bulk-pulling LinkedIn ad creatives or the full Adyntel integration guide.