The Scenario
You're a growth marketer at a SaaS company. The Q2 campaign brief is due Thursday, and before you write a single word of copy you want to know what your twenty closest competitors are actively saying on LinkedIn — not their positioning pages, but what's live in the ad library right now.
You've got the domain list in an Excel workbook. Your last attempt at this audit was done by hand: LinkedIn ad library, one domain at a time, copy the headline, paste it into column B, body copy into column C, note the format in column D. By company nine, you were making errors. By company fourteen, you were only capturing the headline and skipping body copy because it was taking too long.
The bad version:
- Open the LinkedIn ad library, search the first domain, copy the headline into row 2 column B, paste body copy into column C, note the format in column D
- Continue for all twenty domains, highlighting the last completed row to keep your place
- Go back and re-pull three domains where the format field was left blank, discover two have updated their ads since you started, redo those rows
Three hours in. The sheet has gaps. The brief still isn't written.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data in your worksheets, understands the structure, and connects directly to Adyntel to pull LinkedIn ad creative data for every domain in your list — without you touching the LinkedIn ad library at all.
With your competitor domains in column A of your workbook:
Pull LinkedIn ads for every domain in column A and write the ad headline, body copy, and format into columns B, C, and D
What You Get
- Column B: ad headline text for each domain's most recent active LinkedIn ad
- Column C: full body copy, untruncated
- Column D: ad format (single image, carousel, video, text, etc.)
- Domains with no active LinkedIn ads get a clear note in their row — no blanks that look like they were missed
What If the Data Is Not Quite Ready
The domains are listed inconsistently — some with "www.", some without, some with trailing slashes
Normalize every entry in column A so they're all bare domains without protocol or trailing slashes, then pull LinkedIn ads from Adyntel for each and write results to columns B through D
You want the top three ads per domain, not just the most recent
For each domain in column A, fetch the top 3 active LinkedIn ads using Adyntel and write each ad to its own row — include the domain repeated in column A, headline in column B, body copy in column C, and format in column D
Your list spans two worksheets — primary competitors in Sheet1 and secondary in Sheet2
Pull the domains from both the 'Primary Competitors' and 'Secondary Competitors' worksheets, combine them without duplicates, fetch LinkedIn ad data from Adyntel for each, and write all results to a new worksheet called 'Ad Audit'
You want a single pass that normalizes, pulls, and scores the copy angle in one shot
For each domain in column A, normalize the URL, pull their active LinkedIn ads from Adyntel, write the headline and body copy to columns B and C, and add a one-word copy angle label in column D — choose from 'pain point', 'social proof', 'feature', 'urgency', or 'question'
One prompt, structured results, no re-pulls.
Try It
Get the 7-day free trial of SheetXAI and open your competitor domain list in Excel, then ask it to pull LinkedIn ad creatives from Adyntel for every row. See also pulling Meta ad creatives for competitor benchmarking and the full Adyntel integration guide.