Back to Templates
This automated workflow extracts transcripts from TikTok videos by reading video URLs from a Google Sheet, calling the API via TikTok Transcript Generator, cleaning the subtitle data, and updating the sheet with transcripts. It efficiently handles batches, errors, and rate limits to provide a seamless transcription process.
Column Name | Description |
---|---|
Video Url | URL of the TikTok video to transcribe |
Transcript | Generated transcript text (updated by workflow) |
Generated Date | Date when the transcript was generated (YYYY-MM-DD) |
Node Name | Type | Purpose |
---|---|---|
When clicking ‘Execute workflow’ | Manual Trigger | Manually starts the entire transcription workflow. |
Google Sheets2 | Google Sheets (Read) | Reads TikTok video URLs and transcript data from Google Sheets. |
Loop Over Items | Split In Batches | Processes rows in smaller batches to control execution speed. |
If | Conditional Check | Filters videos needing transcription (URL present, transcript empty). |
HTTP Request | HTTP Request | Calls the TikTok Transcript Generator API on RapidAPI to fetch transcripts. |
If1 | Conditional Check | Checks for valid API responses (handles 404 errors). |
Code | Code (JavaScript) | Cleans and formats raw subtitle text by removing timestamps. |
Google Sheets | Google Sheets (Update) | Updates the sheet with cleaned transcripts and generation dates. |
Google Sheets1 | Google Sheets (Update) | Updates sheet with “No transcription available” message on error. |
Wait | Wait | Adds delay between batches to avoid API rate limits on RapidAPI. |
Try this workflow to automate your TikTok video transcriptions efficiently!
Create your free n8n account and set up the workflow in just a few minutes using the link below:
Save time, stay consistent, and grow your LinkedIn presence effortlessly!