Automated TikTok Transcript Extraction and Sheet Logging - n8n Workflow

Content Creators and Social Media Managers needing quick transcripts for SEO or repurposing.
Data Analysts looking to gather large datasets of social media video content.
Users seeking robust, error-handling n8n templates for external API integration.
Anyone familiar with n8n aiming to build complex, conditional flows around Google Sheets data.

Manually transcribing video content is time-consuming and prone to errors. This specialized n8n workflow solves this by providing a hands-off automation solution. It operates by reading a list of TikTok video URLs from a Google Sheet, intelligently filtering out videos that already have a transcript, fetching the raw subtitles via a powerful RapidAPI endpoint, and then using a custom Code n8n node to clean the raw data. This robust approach ensures that only necessary API calls are made and that the stored data is clean and actionable. The final step of this n8n workflow logs the cleaned transcript back into the Google Sheet, including handling API failures gracefully. This entire solution is delivered as an easy-to-use n8n template, providing immense value to content teams.

This highly efficient n8n workflow follows a strict conditional path to ensure reliability and rate-limit compliance:

1. Start: The process is initiated by the Manual Trigger n8n node (When clicking ‘Execute workflow’).


2. Read Data: The workflow reads all rows from a designated Google Sheets document using the Google Sheets n8n node.


3. Batch Processing: The Loop Over Items n8n node splits the retrieved rows into manageable batches (e.g., 10 items) to prevent overloading the external API and ensure stability across the n8n execution.


4. Initial Filter: An If n8n node checks two conditions: A) The 'Video Url' field is present, and B) The 'Transcript' field is empty. Only rows meeting both criteria proceed to transcription.


5. API Call: For valid items, an HTTP Request n8n node calls the RapidAPI TikTok Transcript Generator, passing the video URL as a parameter.


6. Error Handling Filter: A second If n8n node (If1) verifies that the API call did not result in a 404 error (no transcription available).


7. Data Cleaning (Success): The Code n8n node executes custom JavaScript to clean the raw VTT subtitle text, removing headers like 'WEBVTT' and unnecessary timestamp lines, resulting in a perfectly clean transcript.


8. Update Sheet (Success): A Google Sheets n8n node (Google Sheets) updates the original row with the cleaned transcript and the generation date.


9. Update Sheet (Failure): If the API returned an error (or 404), a parallel Google Sheets n8n node (Google Sheets1) updates the row with "No transcription available."


10. Rate Limiting: Finally, a Wait n8n node pauses the flow for a set duration (10 seconds) before the Loop Over Items repeats the process for the next batch, ensuring API compliance for this powerful n8n template.

To deploy this comprehensive n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON data and import it directly into your n8n instance via the 'Workflows' > 'New' > 'Import from JSON' option.


2. Google Sheets Credentials: Configure the two Google Sheets n8n nodes (Google Sheets2, Google Sheets, and Google Sheets1) using Service Account authentication. Ensure these credentials have read/write access to your target spreadsheet.


3. Spreadsheet Setup: Create a Google Sheet with at least two columns: 'Video Url' and 'Transcript'. The workflow expects to read from and write to this sheet.


4. RapidAPI Configuration: Set up credentials for the HTTP Request n8n node. You must provide a valid x-rapidapi-key and ensure the x-rapidapi-host is correctly set to tiktok-transcript-generator.p.rapidapi.com.


5. Activation: Once credentials are set, activate the n8n workflow and execute it using the Manual Trigger n8n trigger.

This n8n workflow relies on several core n8n node types for its functionality:

When clicking ‘Execute workflow’ (Manual Trigger n8n trigger): Initiates the execution on demand. Essential for batch processing.
Google Sheets2 (Google Sheets n8n node): Reads data from the spreadsheet. Configured to read all rows from the specified Sheet1 to identify pending transcripts.
Loop Over Items (Split In Batches n8n node): Splits the incoming data into batches to maintain performance and respect API limits.
If (Conditional Check n8n node): Filters items where the Video Url is present and the Transcript is empty, ensuring the n8n workflow only processes new videos.
HTTP Request (HTTP Request n8n node): Executes the API call to https://tiktok-transcript-generator.p.rapidapi.com/tiktok/index.php. It uses a POST method and dynamically inputs the Video Url from the Google Sheet data.
Code (Code n8n node): Critical for post-processing. Contains JavaScript logic to strip "WEBVTT" headers, timestamps (like 00:00:00 --> 00:00:00), and empty lines from the raw API response, yielding a clean, readable cleanedSubtitles output.
Google Sheets (Google Sheets n8n node): Updates the sheet on success. Uses the 'Append or Update' operation, matching on 'Video Url' and inserting the cleaned transcript and date.
Wait (Wait n8n node): Implements a 10-second pause to manage API request rates before looping to the next batch of the n8n workflow.