Auto-transcribe TikTok videos to Google Sheets

# Extract and clean TikTok video transcripts by URL to Google Sheets

This automation extracts text from TikTok videos using URLs stored in Google Sheets, streamlining content analysis, SEO processing, and repurposing. Ideal for teams managing content workflows via spreadsheets.

## Who it´s for
- Marketers collecting TikTok content for analysis and reposting
- Content managers automating subtitle creation
- SMM specialists tracking video transcripts in Google Sheets
- Teams working with user-generated content requiring bulk video processing

## What the automation does
- Reads TikTok video URLs from a designated Google Sheet
- Fetches transcript via RapidAPI (TikTok Transcript Generator API)
- Cleans raw text by removing timestamps, headers, and metadata
- Saves clean transcript back into the same sheet with timestamp
- Logs "transcript unavailable" on errors (e.g. 404)
- Adds delays between requests to respect API rate limits
- Triggered manually as needed

## What´s included
- Ready-to-use n8n workflow
- Trigger and error handling logic
- Integrations with Google Sheets, RapidAPI, and TikTok Transcript Generator API
- Basic textual guide for setup and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- Access to a Google Sheet with a column of TikTok video URLs
- RapidAPI key for TikTok Transcript Generator API
- Basic understanding of HTTP nodes and credential setup in n8n

## Benefits and outcomes
- Centralized transcript storage in Google Sheets
- Time savings during bulk video processing
- Elimination of manual copying and cleaning
- Enables keyword, mention, and trend analysis
- Works around missing subtitles in app interface
- Reduces manual labor and human error

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat