Automate YouTube Video Summarization with AI & Google Sheets
detail.loadingPreview
Save hours weekly! Auto-summarize YouTube video transcripts using DeepSeek AI and sync key insights to Google Sheets. Perfect for researchers and content managers.
🚀Ready to Deploy This Workflow?
About This Workflow
How it works
This workflow automates the process of extracting key information from YouTube videos. It starts by fetching a pending YouTube URL from a Google Sheet. Then, it retrieves the video transcript using the Supadata.ai API. The transcript is then sent to the DeepSeek Chat Model for summarization, extracting a concise summary, key points, and relevant topics in a structured JSON format. Finally, a code node cleans and parses this JSON, and the extracted data (URL, Status, Summary, Key Points, Topics) is updated back into the Google Sheet.
Key Features
- Fetch pending YouTube URLs from Google Sheets.
- Retrieve video transcripts via Supadata.ai API.
- Utilize DeepSeek AI for intelligent summarization.
- Extract structured JSON output (summary, key points, topics).
- Update Google Sheets with summarized data.
How To Use
- Configure Google Sheets Nodes: Ensure your Google Sheet is set up with columns for 'Url', 'Status', 'Transcript', and 'Summary'. Update the
documentIdandsheetNamein the 'Get URL to Transcript', 'Adding transcript to file', and 'Adding Summary to file' nodes to match your Google Sheet. - Set up Supadata.ai API Key: In the 'Generating transcript' node, replace 'ADD HERE YOUR API KEY' with your actual Supadata.ai API key.
- Configure DeepSeek Credentials: Set up your DeepSeek API credentials in the 'DeepSeek Chat Model' node.
- Activate Workflow: Ensure the 'When clicking ‘Execute workflow’' node is connected and the workflow is active.
Apps Used
Workflow JSON
{
"id": "f9e81a21-e842-4c95-985b-6f9d9831589d",
"name": "Automate YouTube Video Summarization with AI & Google Sheets",
"nodes": 0,
"category": "AI & LLM",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: f9e81a21-e842...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Gmail + Schedule Trigger(270 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Gmail + Split Out(132 workflows)
Related Workflows
Discover more workflows you might like
Auto-Transcribe YouTube Videos to Text with AI
Instantly get YouTube video transcriptions. Input a URL, and this workflow uses Supadata and OpenAI to deliver accurate, structured text, saving you time.
Automate Blog Post Generation from Google Sheets to WordPress with AI
Effortlessly create and publish blog content by automating AI-powered content generation from your Google Sheet directly to WordPress. Save hours weekly!
Auto-Transcribe YouTube Videos to Text with Supadata & OpenAI
Instantly get transcribed text from YouTube videos using Supadata API and OpenAI for structuring. Save hours on content review.
AI Agent: Enhance Chatbots with Long-Term Memory & Tool Integration
Empower your AI chatbot with n8n! Integrate long-term memory via Google Docs and leverage OpenAI tools for advanced conversational AI. Automate memory saving, retrieval, and notifications.
Automate CV Screening: AI Analysis & Auto HR Notifications
Streamline recruitment with AI CV analysis using Google Gemini. Automatically rate candidates, notify HR, and confirm submissions via email.
DeepSeek AI Agent: Build Long-Term Memory Telegram Bots with OpenAI API
Automate Telegram bots with DeepSeek AI, OpenAI API, and long-term memory. Build intelligent agents that learn and personalize interactions.