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 have a short keyword list in an Excel workbook: 'retinol serum', 'vitamin C serum', 'niacinamide moisturizer'. The ask is 50 examples per keyword with engagement metrics. You've watched competitor TikTok ads by hand before and written notes. Fifty structured rows with metrics is a different kind of task.
The bad version:
- Open TikTok's Creative Center, search 'retinol serum', browse results, take notes on ad copy and hook style in your Excel workbook
- The Creative Center doesn't export, so you're typing or pasting every row manually
- Run out of patience around row 22, decide that's representative enough, send the workbook to the creative team, get a reply asking why the engagement metrics are missing for half the rows
Fifty examples across three keywords with engagement metrics means 150 manual lookups. The brief is Friday.
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 TikTok ad library by keyword and write results — ad text, engagement metrics, advertiser name — directly into your workbook. No manual browsing, no export workarounds.
With your product keywords in column A:
For each product keyword in column A, search TikTok ads using Adyntel and write the top 10 results with their engagement metrics to new rows — include the keyword in column A, ad text in column B, engagement metrics in column C, and advertiser in column D
What You Get
- Column A: keyword each result came from
- Column B: ad text for each TikTok creative in the search results
- Column C: engagement metrics as returned by Adyntel
- Column D: advertiser name
- Results across all keywords populated in one pass, consistently structured
What If the Data Is Not Quite Ready
You want 50 results per keyword, not 10
For each product keyword in column A, search TikTok ads using Adyntel and write the top 50 results to new rows — include keyword in column A, ad text in column B, engagement metrics in column C, advertiser in column D
You want to classify hook types for the creative team
For each keyword in column A, search TikTok ads via Adyntel, pull the top 20 results, write ad text to column B, engagement metrics to column C, advertiser to column D, and classify the hook type in column E — choose from 'before/after', 'authority claim', 'question', 'problem/solution', or 'social proof'
You want to filter results to only high-engagement examples
Search TikTok ads for each keyword in column A using Adyntel, pull the top 100 results per keyword, then keep only the top 30% by engagement — write the filtered results to the workbook with ad text in column B, engagement metrics in column C, advertiser in column D
One prompt that searches, classifies hooks, filters for high engagement, and surfaces only the strongest examples
For each keyword in column A, search TikTok ads via Adyntel, pull 100 results, keep the top 30% by engagement, write ad text to column B, engagement metrics to column C, advertiser to column D, and classify the hook type in column E — sort each keyword's results from highest to lowest engagement
The creative brief goes out with a real competitive foundation.
Try It
Get the 7-day free trial of SheetXAI and open your product keyword list in Excel, then ask it to search the TikTok ad library via Adyntel for every row. Also useful: searching the Meta ad library by keyword and the full Adyntel integration guide.