The Scenario
The design team brief goes out Monday. You're a creative director at a SaaS company 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 forty minutes and writing notes in a Notion doc. The result was nine examples, no engagement data, and three of the examples were from companies you've never heard of. The design team ignored the doc and asked for something more structured.
The bad version:
- Open the Meta Ad Library, search 'project management software', filter by country and ad type, start scrolling
- Copy ad copy for each result you think is relevant into your Excel sheet — the library doesn't export, so you're typing or pasting one at a time
- Run out of energy around result 30, decide the first page is representative enough, send the sheet, get a reply asking why you only included 30 when the brief asked for 100
A hundred examples with advertiser names. Manual. From a UI with no export. You're a creative director — this is not the work.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Adyntel to search the Meta ad library by keyword and write structured results directly into your sheet — ad text, advertiser, and any available reach or engagement data — in one prompt.
Open a blank Google Sheet 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 sheet
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 include estimated reach so the team can sort by visibility
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 results from highest to lowest reach
You want to search multiple keyword variations and combine them
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, search keyword matched to column C
You only want ads that mention '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 and list them in this Google Sheet sorted by estimated reach — include ad text in column A, advertiser in column B, and reach in column C
One prompt that searches, filters for 'free trial' mentions, classifies the value proposition, 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 foundation before the week starts.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, 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.