Quick overview
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. An n8n automation workflow template by Steadyfetch.
Steadyfetch
web
free
Others in the same category, ranked by how often they are opened.
