This n8n workflow automates the process of fetching, cleaning, and logging TikTok video transcripts into Google Sheets. It begins with a manual trigger, allowing users to initiate the process on demand. The workflow reads TikTok video URLs from a Google Sheet, then processes each URL in batches to avoid API rate limits. For each URL that lacks a transcript, it makes an HTTP request to a TikTok transcript API via RapidAPI, retrieving subtitles if available. The raw subtitles are cleaned to remove timestamps and headers before being stored back into the Google Sheet alongside the video URL and date. If no transcript is available (e.g., a 404 error), the workflow updates the sheet with a ‘No transcription available’ message. Throughout, strategic delays are implemented to manage API limits, making this workflow ideal for content creators, social media managers, and SEO teams who want to automate TikTok transcript collection and management.