TikTok Transcript

# 📝 TikTok Transcript Extraction & Logging Workflow

This n8n workflow automatically fetches TikTok video transcripts via the RapidAPI TikTok Transcript Generator and updates a Google Sheet with cleaned transcriptions. It processes only rows missing transcripts, handles errors, and adds timestamps.

---

## 🧩 Node-by-Node Explanation
1. **Manual Trigger** – Starts the workflow manually on demand.  
2. **Google Sheets2** – Reads TikTok video URLs and existing transcripts from the sheet.  
3. **Loop Over Items** – Processes rows in batches of 10 for rate limiting.  
4. **If** – Checks if a video URL exists and transcript is missing.  
5. **HTTP Request** – Calls TikTok transcript API to fetch subtitles.  
6. **If1** – Verifies the API response is successful (no 404 error).  
7. **Code** – Cleans raw subtitles by removing timestamps and headers.  
8. **Google Sheets** – Updates the sheet with cleaned transcript and date.  
9. **Google Sheets1** – Marks videos with no transcript available in the sheet.  
10. **Wait** – Pauses workflow to manage API rate limits before next batch.  

---

## 🔑 Summary Use Cases  
- Automate generation of TikTok video transcripts for content teams.  
- Maintain a centralized Google Sheet of transcripts for SEO, captions, or repurposing content.  
- Reduce manual effort and errors in transcribing TikTok videos.  
- Handle API errors and missing data gracefully.

---

**This workflow enables seamless, automated transcription fetching and management for TikTok videos via Google Sheets integration, ideal for marketing, social media managers, and content creators.**