TikTok Creative Center Top Ads to Google Sheets via n8n

Turn TikTok top ads into a Google Sheets performance library—automatically

This n8n workflow pulls top-performing ads from TikTok Creative Center, extracts a first-3-seconds hook and key performance metrics, then appends one clean row per ad to Google Sheets—so you can analyze winning creatives faster.

What this workflow does

• Manual run: Start it by executing the workflow in n8n.
• Scrape TikTok Creative Center Top Ads: Send your selected country, period, industry, and max ad count to Apify to begin the scraper run.
• Poll for completion: Wait until Apify finishes, then retrieve the run’s dataset ID.
• Generate transcripts + hooks: Pass the dataset ID to a second Apify actor to produce:
  • Ad transcripts
  • The first-3-seconds hook
  • Performance metadata (e.g., CTR, likes, duration, language)
• Clean table formatting: Sort/reshape results into one row per ad, including transcript word count and whether the item was charged.
• Append to Google Sheets: Add the prepared rows to your chosen worksheet.

Use cases

• Build a creative intelligence sheet by industry and time period, using TikTok Creative Center top ads.
• Compare CTR, likes, duration, and language alongside the opening hook to identify patterns.
• Track ad hook quality for your team by capturing the first 3 seconds and transcript context in one place.

Technical details

• Apify integrations via HTTP Request with Bearer token auth (Authorization: Bearer YOUR_APIFY_TOKEN)
• Google Sheets output via OAuth, appending rows to a specified spreadsheet/sheet
• Uses n8n nodes/logic including if, set, code, and http request
• Includes sorting by CTR in a Code node
• Config step lets you update country, period, industry, and maxAds