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 actually saying on LinkedIn — not what their websites claim, but what's actively running in the ad library right now.
You've done this before. Last time, you searched each company name in the LinkedIn ad library one by one, screenshotted what looked relevant, and pasted headline and body copy into a Google Sheet by hand. By company eight you were copying things wrong. By company fifteen you'd stopped capturing body copy entirely because it was taking too long.
The bad version:
- Open LinkedIn ad library, search the first domain, copy the headline into row 2 column B, copy the body copy into column C, note the format in column D
- Repeat for all twenty domains, keeping your place in the list by highlighting the last row you completed
- Go back to re-pull three domains where you missed the format field, discover two of them have updated their ads since you started, redo those rows
It takes three hours and the sheet still has gaps. The campaign brief won't write itself, and this was supposed to be research, not data entry.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data in your tabs, understands the structure, and connects directly to Adyntel to pull LinkedIn ad creative data for every domain you have — without you touching the LinkedIn ad library at all.
Open the sheet with your competitor domains in column A, then ask:
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, not truncated
- Column D: ad format (single image, carousel, video, text, etc.)
- Domains with no active LinkedIn ads get a clear note in their row — no ambiguous blanks
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 one and write the results to columns B through D
You want the top three ads per domain, not just the most recent one
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 name repeated in column A, the headline in column B, body copy in column C, and format in column D
Your list spans two tabs — primary competitors in Sheet1 and secondary competitors in Sheet2
Pull the domains from both the 'Primary Competitors' and 'Secondary Competitors' tabs, combine them without duplicates, and fetch LinkedIn ad data from Adyntel for each — write all results to a new tab 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'
The pattern: when the data needs cleanup before the pull, and the pull needs scoring on the way out, put it all in one prompt. One round trip.
Try It
Get the 7-day free trial of SheetXAI and open your competitor domain list in Google Sheets, then ask it to pull LinkedIn ad creatives from Adyntel for every row. Check out pulling Meta ad creatives for creative benchmarking or the Adyntel overview to see what else the integration handles.