{"product_id":"n8n-weekly-tiktok-transcription-to-google-sheets-apify","title":"n8n Weekly TikTok Transcription to Google Sheets (Apify)","description":"\u003ch3\u003eTurn new TikTok videos into ready-to-analyze transcripts in Google Sheets—every week\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks a specific TikTok account every Monday, transcribes the newest videos using \u003cstrong\u003eApify’s Video to Text Transcriber\u003c\/strong\u003e, and appends or updates one row per video in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with key metrics, a hook sentence, and the full transcript.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a weekly schedule\u003c\/strong\u003e: it’s triggered every Monday morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTargets a TikTok account\u003c\/strong\u003e by setting the account handle and a \u003cstrong\u003emaxVideos\u003c\/strong\u003e limit (how many recent videos to check).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches only new videos\u003c\/strong\u003e by calling Apify’s actor \u003ccode\u003efguiraud\/video-to-text-transcriber\u003c\/code\u003e, which returns speech-to-text transcripts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters out unusable results\u003c\/strong\u003e by excluding videos without transcript text (for example, music-only clips).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites spreadsheet-ready fields\u003c\/strong\u003e including: URL, post date, author, views, likes, comments, hook, transcript, and a transcribed date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends or updates rows\u003c\/strong\u003e by matching on the video \u003cstrong\u003eURL\u003c\/strong\u003e (so the sheet stays consistent).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eContent teams\u003c\/strong\u003e keep a searchable archive of TikTok scripts for weekly review and repurposing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e track what competitors are saying by storing transcripts alongside engagement metrics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e maintain a lightweight transcription pipeline from TikTok → Apify → Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling\u003c\/strong\u003e: n8n \u003cem\u003eSchedule Trigger\u003c\/em\u003e (every Monday).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration\u003c\/strong\u003e: HTTP Request with \u003cstrong\u003eAuthorization: Bearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/strong\u003e targeting \u003ccode\u003efguiraud\/video-to-text-transcriber\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: writes\/updates rows in your selected spreadsheet and sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExpected columns\u003c\/strong\u003e (recommended): \u003ccode\u003eurl, posted, author, views, likes, comments, hook, transcript, transcribedOn\u003c\/code\u003e with \u003cstrong\u003eurl unique\u003c\/strong\u003e for matching updates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eTo set up, create an Apify token, configure the HTTP Header Auth credential, connect Google Sheets, define the sheet columns, and test once manually (starting with \u003ccode\u003emaxVideos = 3\u003c\/code\u003e) before activating. Keep \u003ccode\u003emaxVideos\u003c\/code\u003e at \u003cstrong\u003e20 or less\u003c\/strong\u003e as you expand coverage.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146296512691,"sku":"N8N-20256","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/tedgu394g-lyKTzCR-4W_3CQFuICE.png?v=1790845809","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-tiktok-transcription-to-google-sheets-apify","provider":"N8N Commerce","version":"1.0","type":"link"}