Transcribe TikTok Creative Center top ads with Apify and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Config (Edit Fields (Set)): sets 4 fields: countryCode, period, industry…
- Scrape Creative Center Top Ads (HTTP Request): calls an HTTP API (POST)
- Scrape finished? (If): checks a condition and branches into true / false
- Transcribe Top Ads by dataset ID: hooks & transcripts (HTTP Request): calls an HTTP API (POST)
- Wait for scrape (poll run) (HTTP Request): calls an HTTP API
- Teardown rows: one per ad (Code): runs custom JavaScript code
- Top Ads table (one row per item) (Edit Fields (Set)): sets 12 fields: brand, ad_title, material_id…
- Append rows to Google Sheets (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
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.…