The Scenario
Production brief is due Friday. The creative team needs 10 hook concepts for the next TikTok campaign and they've asked you for a competitive reference doc — specifically what hooks and calls to action are dominating in the skincare category right now.
You've never pulled TikTok ad data systematically before. You've watched competitors' ads manually, taken notes in a doc, tried to remember which brand was using the "dermatologist approved" hook vs. the "before/after in 7 days" angle. The doc has 11 rows. The team wants 50 examples with engagement metrics.
The bad version:
- Open TikTok's Creative Center, search 'retinol serum', browse the results, take notes on ad copy, hook style, and whatever engagement data the UI surfaces
- Copy the relevant data into your Google Sheet row by row — the UI doesn't let you export, so it's manual every time
- Run out of patience around row 20, decide 20 examples is probably enough, send the sheet to the creative team, get a reply asking if you could add the engagement metrics you left out
Fifty examples with engagement metrics means fifty manual lookups. Nobody hired you to do fifty manual lookups.
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 TikTok ad library by keyword and write results — ad text, engagement metrics, advertiser name — directly into your sheet. No manual browsing, no export workarounds.
Open a blank Google Sheet and ask:
Search the TikTok ad library for 'retinol serum' using Adyntel and fill this sheet with the ad text, engagement metrics, and advertiser name for the top 50 results
What You Get
- Column A: ad text for each TikTok creative in the search results
- Column B: engagement metrics (views, interactions, or equivalent as returned by Adyntel)
- Column C: advertiser name
- 50 rows populated in one pass — consistently structured, no manual browsing
What If the Data Is Not Quite Ready
You want to search multiple product keywords, not just one
For each product keyword in column A, search TikTok ads using Adyntel and write the top 10 results with ad text, engagement metrics, and advertiser name to new rows — include a column indicating which keyword each row came from
You want to classify hook types before sending to the creative team
Search TikTok ads for 'retinol serum' using Adyntel, pull the top 50 results, write ad text to column A, engagement metrics to column B, advertiser to column C, and classify the hook type in column D — choose from 'before/after', 'authority claim', 'question', 'problem/solution', or 'social proof'
You want to filter out low-engagement results before the creative team sees the sheet
Search TikTok ads for 'retinol serum' via Adyntel, pull the top 100 results, then include only the ads in the top 30% by engagement — write those to the sheet with ad text in column A, engagement metrics in column B, advertiser in column C
One prompt that searches two keywords, classifies hooks, and surfaces only high-engagement examples
Search TikTok ads for 'retinol serum' and 'vitamin C serum' using Adyntel; combine results; keep only the top 40 by engagement; write ad text to column A, engagement metrics to column B, advertiser to column C, keyword to column D, and hook type classification to column E
The creative brief has what it needs before end of day.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to search the TikTok ad library via Adyntel for your product category keywords. Also useful: searching the Meta ad library by keyword and the full Adyntel integration guide.