YouTube Transcripts to AI Summaries in Google Sheets

# YouTube transcript extraction and AI summary to Google Sheets

This workflow automates video content processing: retrieves YouTube video transcripts, generates structured AI-powered summaries with key points and topics using DeepSeek, and stores all data in Google Sheets. Enables fast analysis of lectures, interviews, and presentations without watching full videos.

## Who it´s for
- Analysts extracting insights from video content
- Researchers working with large volumes of lectures and interviews
- Marketers systematically analyzing competitor YouTube content
- Educators preparing lecture summaries from educational videos

## What the automation does
- Reads a YouTube video URL from a Google Sheet row with status ´Pending´
- Fetches the video transcript via Supadata API
- Sends the transcript to DeepSeek AI model through LangChain
- Structures the output into clean JSON with key theses and topics
- Removes formatting artifacts and special characters from the result
- Writes back the transcript, summary, and updated status (´Processed´) to the same row

## What´s included
- Ready-to-use n8n workflow
- Trigger and status handling logic
- Integrations with YouTube, Supadata.ai, Google Sheets, and DeepSeek API
- Basic text guide for setup and adaptation

## Requirements for setup
- n8n instance (self-hosted or cloud)
- Google Sheet with columns: URL, Transcript, Summary, Status
- Supadata.ai API key for transcript retrieval
- DeepSeek API key for AI summarization

## Benefits and outcomes
- Saves time on manual transcription and video analysis
- Centralized storage for transcripts and AI summaries
- Supports batch processing of multiple videos
- Structured JSON output enables easy integration with other tools
- Accelerates report generation, note-taking, and competitive intelligence

## 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