YouTube and Notion integration

📊 Description Automate your YouTube research workflow by extracting audio from any video, transcribing it with Whisper AI, and generating structured GEO (Goal–Execution–Outcome) summaries using GPT-4o-mini. 🎥🤖 This template transforms unstructured video content into actionable, searchable insights that are automatically stored in Notion with rich metadata. It’s ideal for creators, educators, analysts, and knowledge workers who want to convert long videos into concise, high-quality summaries without manual effort. Perfect for content indexing, research automation, and knowledge-base enrichment. 📚✨ 🔁 What This Template Does • Triggers on a schedule to continuously process new YouTube videos. ⏰ • Fetches video metadata (title, description, thumbnails, published date) via the YouTube API. 🎥 • Downloads audio using RapidAPI and prepares it for transcription. 🎧 • Transcribes audio into text using OpenAI Whisper. 📝 • Skips invalid entries when no transcript is generated. 🚫 • Merges the transcript with metadata for richer AI context. 🔗 • Uses GPT-4o-mini to generate Goal, Execution, Outcome, and Keywords via structured JSON. 🤖📊 • Parses the AI-generated JSON into Notion-friendly formats. 🔍 • Creates a Notion page with GEO sections, keywords, and video metadata. 📄🏷️ • Produces a fully searchable knowledge record for every processed video. 📚✨ ⭐ Key Benefits ✅ Converts long YouTube videos into concise, structured knowledge ✅ AI-powered GEO summaries improve comprehension and recall ✅ Zero manual transcription or note-taking — 100% automated ✅ Seamless Notion integration creates a powerful video knowledge base ✅ Works on autopilot with scheduled triggers ✅ Saves hours for educators, researchers, analysts, and content teams 🧩 Features YouTube API integration for metadata retrieval RapidAPI audio downloader OpenAI Whisper transcription GPT-4o-mini structured analysis through LangChain Memory buffer + structured JSON parser for consistent results Automatic Notion page creation Fail-safe transcript validation (IF node) Metadata + transcript merging for richer AI context GEO (Goal–Execution–Outcome) summarization workflow 🔐 Requirements YouTube OAuth2 credentials OpenAI API key (Whisper + GPT-4o-mini) Notion API integration token + database ID RapidAPI key for YouTube audio downloading n8n with LangChain nodes enabled 🎯 Target Audience YouTubers and content creators archiving their content Researchers and educators summarizing long videos Knowledge managers building searchable Notion databases Automation teams creating video intelligence workflows 🛠️ Step-by-Step Setup Instructions Add YouTube OAuth2, OpenAI, Notion, and RapidAPI credentials. 🔑 Replace the placeholder RapidAPI key in the “Get YouTube Audio” node. ⚙️ Update the Notion database ID where summaries should be stored. 📄 Configure the Schedule Trigger interval based on your needs. ⏰ Replace the hardcoded video ID (if present) with dynamic input or playlist logic. 🔗 Test with a sample video to verify transcription + AI + Notion output. ▶️ Enable the workflow to run automatically. 🚀

Description: Turn your n8n workflow into an automated competitive intelligence unit. This template monitors competitor activities across blog feeds and YouTube channels to detect strategic shifts. Instead of simply aggregating links, it uses Apify to fetch full video transcripts and Google Gemini to analyze the content's underlying message, tone, and positioning. The final output is a structured strategic briefing sent to Telegram and archived in Notion for long-term research. Who is this for This workflow is designed for market researchers, founders, and content strategists who need deep insights into competitor activities without manually scrubbing video timelines or reading daily blog posts. How it works Ingest: The workflow pulls the latest articles from configured RSS feeds and searches for new videos on specific YouTube channels. Deep Dive: It automatically triggers an Apify actor to scrape the full transcript of any new video, ensuring the AI analyzes the spoken content rather than just metadata. Analyze: Google Gemini processes the consolidated text to identify core messages, hidden strategies, and suggests potential counter-tactics. Report: Telegram:** Delivers a concise HTML executive summary with direct source links. Notion:** Appends a comprehensive report to a database using formatted Notion Blocks (Headings, Toggles, and Bullet points). Requirements Apify Account:** A free account is sufficient to run the youtube-transcript-scraper. Services:** Google Gemini (PaLM), YouTube Data API, Telegram, Notion. How to set up Credentials: Configure your API keys for YouTube, Apify, Google Gemini, Telegram, and Notion. Notion Setup: Create a new Database with two properties: Name (Title) and date (Date). Copy the Database ID from the URL into the Notion node. Data Sources: Update the Channel ID in the YouTube nodes to track your target competitors. Update the Feed URL in the RSS nodes. How to customize the workflow Scale Up:** To monitor more competitors, duplicate the YouTube or RSS nodes in the "Data Sources" section and connect them to the Merge node. Adjust Analysis:* Modify the system prompt in the Google Gemini* node to focus on specific intelligence needs (e.g., "Focus on pricing changes" or "Identify new feature releases"). Token Optimization:** Use the configuration in the Code - Data Prep node to limit the number of items processed daily if you are using free-tier API limits. Need Help or Want to Customize This? Contact me for consulting and support: Email: [email protected]

Who it's for YouTube creators, content marketers, and anyone who wants to automatically enrich YouTube links added to a Notion database. What it does Automatically extracts important video and channel data — including title, views, likes, comments, thumbnail, channel name, subscribers, and a custom viral score — whenever a new YouTube URL is added to Notion. How it works A Notion Trigger fires when a new page is added to your database. The workflow extracts the YouTube video ID from the provided URL. A YouTube API request retrieves video details (title, views, likes, comments, thumbnail). A second YouTube API request retrieves channel information (name and subscriber count). Both sets of data are cleaned and formatted. The enriched data is written back to the same Notion page. Requirements YouTube Data API (OAuth2 recommended) Notion integration connected to your workspace This Notion template (includes all required fields): https://lunar-curler-d17.notion.site/2a71d9a77486807a9006d048aa512d16?v=2a71d9a7748680eda620000ca9c112a4 Setup steps Duplicate the Notion template linked above. Connect your Notion credentials in n8n. Create and connect a YouTube OAuth2 credential. Assign your credential to the YouTube API nodes. Test once with a manual execution.