📊 Transcribe TikTok Creative Center top ads with Apify and Google Sheets
⚡ 11 views · 📊 Market Research & Insights
💡 Pro Tip — Since TikTok doesn’t have a public API, getting data usually means fragile HTTP scraping. ScraperNode is a community node that gives you clean JSON for TikTok profiles, videos, and comments — drop it into your workflow and skip the parsing.
Description
Quick overview
This workflow pulls top-performing TikTok ads from the TikTok Creative Center via Apify, transcribes each ad and extracts the first-3-seconds hook, then appends one row per ad (CTR, likes, duration, language, and transcript) to Google Sheets.
How it works
- Runs when you manually execute the workflow.
- Sends your selected country, period, industry, and max ad count to Apify to start the TikTok Creative Center Top Ads scraper.
- Polls the Apify run status until the scrape finishes and retrieves the run’s dataset ID.
- Passes the dataset ID to a second Apify actor that generates transcripts, 3-second hooks, and ad performance metadata.
- Sorts and reshapes the results into one clean table row per ad, including transcript word count and whether the item was charged.
- Appends the prepared rows to a Google Sheets worksheet.
Setup
- Create an Apify token and add an HTTP Header Auth credential using
Authorization: Bearer YOUR_APIFY_TOKEN, then select it on all Apify HTTP Request steps. - Add a Google Sheets OAuth credential and select the target spreadsheet and sheet for appending rows.
- Update the configuration values (country code, period, industry, and maxAds) in the Config step to match what you want to pull from TikTok Creative Center.
Requirements
- An Apify account and a Google account.
Customization
- Change the industry or period to build a library per vertical.
- Sort by CTR in the Code node.
- Add a Schedule Trigger to refresh the top ads every week.
Additional info
Who it’s for: TikTok media buyers, UGC creators and creative strategists who want the scripts behind the ads that are already winning.
🔗 Nodes Used
Google Sheets, HTTP Request
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File