YouTube Transcript Automation

Automate the process of fetching, cleaning, and storing YouTube video transcripts into Google Sheets using n8n + LLMs.

📌 Features

• 🔄 Automatically triggers on schedule.
• 📥 Fetches video links from Google Sheets.
• 📝 Extracts & cleans YouTube video transcripts.
• 🤖 Uses AI (Google Gemini / LLM) to summarize or optimize transcripts.
• ✨ Cleans and reformats AI outputs (removes \n, **, etc.).
• 📊 Updates processed titles and transcripts back into Google Sheets.

⚙️ Workflow Overview

1. Schedule Trigger – starts the automation.
2. Get Rows (Google Sheets) – fetches video links.
3. Loop Over Items – processes each link.
4. Extract Link – parse and clean YouTube video ID.
5. Get Transcripts – fetch raw transcripts from YouTube.
6. Extract & Combine Transcripts – merge into full text.
7. Basic LLM Chain (Gemini / OpenAI) – process transcripts (summarization, title generation, etc.).
8. Code Node – clean and format AI-generated text.
9. Manage Output – structure results.
10. Update Row in Sheet – write back clean titles & transcripts.

🛠️ Tech Stack

• n8n – Workflow automation.
• Google Sheets API – Store input links & outputs.
• YouTube Transcript API – Extract raw captions.
• Google Gemini (or OpenAI) – AI processing & summarization.
• JavaScript (Code Nodes) – cleaning & formatting.

📸 Screenshots

📌 Example Output

Video Link	Transcript (Summary)	AI Titles
https://youtu.be/xxxx	Short clean transcript here	1. Title idea … 2. Title idea …

🤝 Contributing

Pull requests are welcome! For major changes, please open an issue first to discuss what you’d like to change.

Would you like me to also export your workflow JSON into a workflows/ folder template (so people can import it directly into n8n)?