AI YouTube Content Insights Agent

Unlock YouTube Content Goldmines with this AI Agent

This AI-driven n8n workflow acts as your personal YouTube assistant, allowing you to conversationally extract deep insights from YouTube channels, videos, and comments. It leverages OpenAI's powerful language models to understand your requests and orchestrate calls to the YouTube Data API, Apify for transcriptions, and OpenAI Vision for thumbnail analysis. Stop guessing and start creating data-backed content that resonates with your audience.

Key Features & Benefits

• Conversational YouTube Interaction: Chat with your YouTube data. Ask for channel details, video lists, specific video descriptions, comments, or perform broad searches.
• AI-Powered Comment Analysis: Understand audience sentiment, identify recurring questions, and discover content ideas directly from user comments.
• Automated Video Transcription: Get full text transcriptions of YouTube videos via Apify, perfect for content repurposing, SEO, or detailed analysis.
• AI Thumbnail Analysis: Submit thumbnail URLs to OpenAI (GPT-4 Vision or similar) for an AI critique on design, clarity, and potential engagement.
• Comprehensive Data Retrieval: Fetches channel IDs, titles, descriptions, video view counts, likes, publish dates, and more using the YouTube Data API.
• Intelligent Tool Orchestration: Uses an OpenAI Functions Agent to interpret your needs and intelligently call the right tools (YouTube API, Apify, OpenAI Vision) in sequence.
• Persistent Chat Memory: Remembers past interactions within a session using PostgreSQL for a more contextual conversation.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key (access to models like GPT-4 for the agent and a vision-capable model for thumbnail analysis is recommended).
• Google Cloud Project with YouTube Data API v3 enabled and an API Key.
• Apify API Key.
• PostgreSQL database accessible by n8n, with connection details (host, port, user, password, database name).

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Create n8n Credentials:
   • OpenAI: Create an 'OpenAI API' credential using your API key.
   • Google Cloud (YouTube API): Create a generic 'Query Auth' credential. Name it (e.g., 'YouTube API Key'). For the 'Parameter Name', use key. For 'Value', enter your YouTube Data API v3 Key.
   • Apify: Create a generic 'Query Auth' credential. Name it (e.g., 'Apify Token'). For the 'Parameter Name', use token. For 'Value', enter your Apify API Key.
   • PostgreSQL: Create a 'Postgres' credential with your database connection details.
4. Configure Workflow Nodes:
   • AI Agent Core (Scenario 1):
     • Locate the 'OpenAI Chat Model' node. In its properties, select your configured OpenAI credential.
     • Locate the 'Postgres Chat Memory' node. In its properties, select your configured PostgreSQL credential.
   • API Call Nodes (Agent Tools Backend - Scenario 2): These nodes are found after the 'Switch' node in the 'Scenario 2: Agent tools' section.
     • YouTube Data API Nodes: For each of the following nodes, select your 'YouTube API Key' (Query Auth) credential created in step 3:
       • 'Get Channel Details'
       • 'Get Video Description'
       • 'Get Comments'
       • 'Run Query' (for search functionality)
       • 'Get Videos by Channel'
     • Apify Node:
       • 'Get Video Transcription': Select your 'Apify Token' (Query Auth) credential.
     • OpenAI Vision Node:
       • 'OpenAI' node (for thumbnail analysis, distinct from the chat model): Select your OpenAI credential.
5. Review the system prompt in the 'AI Agent' node (Scenario 1) for any desired customizations to the agent's behavior or instructions.
6. Activate the workflow. You can start interacting with the agent via the 'When chat message received' trigger (e.g., through n8n's chat UI if enabled, or by calling its webhook). Test by sending a message like "What are the latest 3 videos from the n8n channel?" or "Analyze this thumbnail: [image_url]".