✨ $500 AI Visibility Audit — live at Spurlock Studios. Book the audit

Marketing

Youtube Transcript --> Content Creation

This n8n workflow monitors specified YouTube channels via RSS, filtering for recently published videos. It then enriches video details using the YouTube API, stores them in Airtable, generates an HTML email summary of new videos via OpenAI, and sends individual Telegram…

Built · ~5.5 hours saved per week

YouTube Content Monitoring & Repurposing Engine This workflow automates the process of monitoring multiple YouTube channels for new video content. When new videos are detected, it fetches detailed information, archives it in a structured database, and uses AI to generate and distribute polished content summaries and notifications across different platforms. Technologies Used - n8n: The core automation platform coordinating the entire process. - YouTube: The source of the video content, accessed via RSS feeds and the official YouTube Data API. - Airtable: Used as a structured database to archive and manage the collected video information. - OpenAI: The AI provider used to transform raw video data into a formatted HTML email newsletter. - Gmail: Used to send the AI-generated email digest. - Telegram: Used for sending real-time notifications for individual new videos. What It Automates This workflow provides a powerful, automated content curation and distribution system. It eliminates the manual effort of: 1. Constantly checking multiple YouTube channels for new uploads. 2. Manually gathering video details like titles, descriptions, thumbnails, and tags. 3. Organizing and storing this information in a database for future reference or analysis. 4. Crafting and formatting email newsletters or summaries to share the new content. 5. Sending timely notifications to a community or team channel. By automating these tasks, it creates a continuously updated content repository in Airtable and ensures stakeholders are promptly informed through polished, AI-generated emails and instant Telegram messages. AI Integration Analysis The AI, specifically an OpenAI Chat Model (o4-mini), is a critical component for content transformation. It integrates into the flow via the LangChain LLM Chain node. - How it works: The workflow first aggregates all new video data (titles, links, authors, descriptions, thumbnails) into a single JSON object. This structured data is then passed to the AI model. - The AI's Task: The AI is given a detailed prompt to act as an expert HTML email developer.

Tags: Web Scraping, Reports & Analytics, Content Management, Data Transformation, Content Creation, OpenAI

Integrations: Code, HTTP, OpenAI, RSS, Email, Telegram, Airtable

Related automations

Back to the Automation Library