{"product_id":"tiktok-creative-center-top-ads-to-google-sheets-via-n8n","title":"TikTok Creative Center Top Ads to Google Sheets via n8n","description":"\u003ch3\u003eTurn TikTok top ads into a Google Sheets performance library—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls top-performing ads from \u003cstrong\u003eTikTok Creative Center\u003c\/strong\u003e, extracts a \u003cstrong\u003efirst-3-seconds hook\u003c\/strong\u003e and key performance metrics, then appends one clean row per ad to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—so you can analyze winning creatives faster.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual run\u003c\/strong\u003e: Start it by executing the workflow in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrape TikTok Creative Center Top Ads\u003c\/strong\u003e: Send your selected \u003cem\u003ecountry\u003c\/em\u003e, \u003cem\u003eperiod\u003c\/em\u003e, \u003cem\u003eindustry\u003c\/em\u003e, and \u003cem\u003emax ad count\u003c\/em\u003e to Apify to begin the scraper run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePoll for completion\u003c\/strong\u003e: Wait until Apify finishes, then retrieve the run’s \u003cstrong\u003edataset ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate transcripts + hooks\u003c\/strong\u003e: Pass the dataset ID to a second Apify actor to produce:\n    \u003cul\u003e\n      \u003cli\u003eAd \u003cstrong\u003etranscripts\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eThe \u003cstrong\u003efirst-3-seconds hook\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ePerformance metadata (e.g., \u003cstrong\u003eCTR\u003c\/strong\u003e, \u003cstrong\u003elikes\u003c\/strong\u003e, \u003cstrong\u003eduration\u003c\/strong\u003e, \u003cstrong\u003elanguage\u003c\/strong\u003e)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClean table formatting\u003c\/strong\u003e: Sort\/reshape results into \u003cstrong\u003eone row per ad\u003c\/strong\u003e, including transcript word count and whether the item was \u003cstrong\u003echarged\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppend to Google Sheets\u003c\/strong\u003e: Add the prepared rows to your chosen worksheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuild a \u003cstrong\u003ecreative intelligence\u003c\/strong\u003e sheet by industry and time period, using TikTok Creative Center top ads.\u003c\/li\u003e\n  \u003cli\u003eCompare \u003cstrong\u003eCTR\u003c\/strong\u003e, \u003cstrong\u003elikes\u003c\/strong\u003e, duration, and language alongside the opening hook to identify patterns.\u003c\/li\u003e\n  \u003cli\u003eTrack ad hook quality for your team by capturing the first 3 seconds and transcript context in one place.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify\u003c\/strong\u003e integrations via \u003cstrong\u003eHTTP Request\u003c\/strong\u003e with Bearer token auth (\u003ccode\u003eAuthorization: Bearer YOUR_APIFY_TOKEN\u003c\/code\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e output via OAuth, appending rows to a specified spreadsheet\/sheet\u003c\/li\u003e\n  \u003cli\u003eUses n8n nodes\/logic including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, and \u003cstrong\u003ehttp request\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIncludes sorting by \u003cstrong\u003eCTR\u003c\/strong\u003e in a \u003cstrong\u003eCode\u003c\/strong\u003e node\u003c\/li\u003e\n  \u003cli\u003eConfig step lets you update \u003cstrong\u003ecountry\u003c\/strong\u003e, \u003cstrong\u003eperiod\u003c\/strong\u003e, \u003cstrong\u003eindustry\u003c\/strong\u003e, and \u003cstrong\u003emaxAds\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950120493235,"sku":"N8N-19153","price":18.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/6aYrqHom1_l0hNlwi3uQi_DQ6OmDZL.png?v=1788513467","url":"https:\/\/buyflowscripts.com\/products\/tiktok-creative-center-top-ads-to-google-sheets-via-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}