The Scenario
The design team brief goes out Monday. You're a creative director and you've been asked to come in with a competitive landscape doc — specifically what value propositions, visual formats, and messaging angles are showing up in Meta ads for 'project management software' before the team starts concepting.
Someone on your team did this last quarter by scrolling the Meta Ad Library for 45 minutes and writing notes. The doc had nine examples, no engagement data, and three of them were from companies nobody on the team recognized. The design team asked for something more structured this time. A hundred examples in Excel, with advertiser names and reach estimates.
The bad version:
- Open the Meta Ad Library, search 'project management software', filter by country and ad type, start scrolling
- Paste ad copy for each result you think is relevant into your Excel workbook — the library doesn't export, so you're typing or pasting one at a time
- Hit result 35 and decide the first page is representative enough, close the tab, send what you have, get a reply asking why there are only 35 rows
A hundred examples, manually, from a UI with no export. You're a creative director. This is not the brief prep work you're paid to do.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Adyntel to search the Meta ad library by keyword and write structured results directly into your workbook — ad text, advertiser, and available reach data — in one prompt.
Open a blank Excel workbook and ask:
Search the Meta ad library for 'project management software' using Adyntel and write the top 100 results with ad text and advertiser to this workbook
What You Get
- Column A: ad text for each Meta creative in the search results
- Column B: advertiser name
- 100 rows populated in one pass, consistent structure throughout
What If the Data Is Not Quite Ready
You want to sort by estimated reach so the team focuses on the highest-visibility ads first
Search the Meta ad library for 'project management software' using Adyntel, pull the top 100 results, write ad text to column A, advertiser to column B, and estimated reach to column C — sort from highest to lowest reach
You want to search multiple keyword variations and combine results
Search the Meta ad library for 'project management software', 'task management tool', and 'team collaboration app' using Adyntel; combine results; remove duplicates; write ad text to column A, advertiser to column B, keyword matched to column C
You only want ads mentioning 'free trial' — a specific angle your team is researching
Use Adyntel's Meta ad search to find all ads mentioning 'free trial' in the project management category, list them in this Excel workbook sorted by estimated reach, with ad text in column A, advertiser in column B, and reach in column C
One prompt that searches, filters for 'free trial', classifies value propositions, and sorts by reach
Search the Meta ad library for 'project management software' using Adyntel, pull 200 results, keep only ads mentioning 'free trial', write ad text to column A, advertiser to column B, reach to column C, and classify the primary value proposition in column D — choose from 'productivity', 'collaboration', 'simplicity', 'integration', or 'price'
The design brief has a real reference point before the week starts.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to search the Meta ad library via Adyntel for your product category keyword. Also useful: pulling Meta ad creatives for a competitor list and the full Adyntel integration guide.