YouTube Comment AI Analyzer & Reporter
detail.loadingPreview
Automatically collect, analyze, and report on YouTube video comments using AI. This n8n workflow monitors your Google Sheet for new videos, fetches comments, performs deep sentiment and thematic analysis with OpenAI, and then emails you actionable insights, streamlining your content strategy and audience engagement.
About This Workflow
Elevate your YouTube content strategy with this powerful n8n workflow. Designed for content creators, marketers, and community managers, it automates the tedious process of manual comment review. By integrating Google Sheets, YouTube API, OpenAI's advanced AI models (GPT-4o), and Gmail, this solution provides a hands-free way to understand your audience. Triggered by a simple 'Pending' status in your spreadsheet, it fetches comments, applies sophisticated AI analysis to uncover sentiment, key themes, common questions, and actionable feedback, then delivers a comprehensive report directly to your inbox. Stay informed and agile, transforming raw comments into strategic insights effortlessly.
Key Features
- Automated Monitoring: Continuously monitors a Google Sheet for new YouTube video IDs or status changes, ensuring timely analysis of your latest content.
- Intelligent Filtering: Processes only videos marked 'Pending' in your spreadsheet, preventing redundant analysis and optimizing resource usage.
- Deep AI-Powered Analysis: Leverages OpenAI's GPT-4o to provide detailed sentiment breakdowns, identify main themes, extract common viewer questions, and pinpoint key feedback for actionable insights.
- Customizable AI Prompts: Easily adjust the AI Agent's prompt to tailor the analysis to specific needs, such as competitor analysis or specific product feedback.
- Automated Email Reporting: Sends comprehensive HTML-formatted email reports containing video statistics, AI analysis summaries, and key insights directly to your inbox.
- Efficient Data Handling: Fetches up to 100 top comments per video and intelligently prepares data, limiting to 50 comments for AI processing to manage token costs effectively.
How To Use
- Google Sheet Setup:
- Create a Google Sheet with columns:
ID | Video Title | YouTube Video ID | Status. - Populate
YouTube Video IDfor videos you wish to analyze. - Set the
Statuscolumn toPendingfor any video you want to trigger the analysis for.
- Create a Google Sheet with columns:
- Credentials Configuration:
- Google Sheets: Authenticate your Google Sheet connection.
- YouTube API: Set up and authenticate your YouTube API credentials. Ensure your API key has access to YouTube Data API v3.
- OpenAI API: Provide your OpenAI API key credentials for the AI Agent and OpenAI Chat Model nodes.
- Gmail: Authenticate your Gmail account to enable sending email reports.
- Customize AI Prompt (Optional):
- Open the
AI Agentnode. - Modify the
systemMessageparameter to adjust the AI's role or the specific aspects of comment analysis you're interested in.
- Open the
- Configure Email Recipient:
- Open the
Gmailnode responsible for sending reports. - Update the recipient email address to your preferred inbox.
- Open the
- Activate Workflow: Once configured, activate the workflow. It will automatically run every minute, checking your Google Sheet for new 'Pending' videos to process.
Apps Used
Workflow JSON
{
"id": "b8f043c8-0062-4d53-8b85-8254510fbbe6",
"name": "YouTube Comment AI Analyzer & Reporter",
"nodes": 5,
"category": "Marketing",
"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: b8f043c8-0062...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Automated AI Motion Illustration Workflow with Midjourney and Kling
Unleash your creativity with this n8n workflow that automates the generation of stunning motion illustrations. It leverages the power of Midjourney for static image creation and Kling AI to transform them into dynamic videos, all managed through the PiAPI. Perfect for content creators, marketers, and social media professionals looking to produce engaging visuals at scale.
Automate LinkedIn Content Promotion for Your Ghost Blog with AI
Effortlessly promote your latest Ghost blog posts on LinkedIn. This workflow leverages AI to generate engaging, professional LinkedIn messages based on your article content and saves them, along with article metadata, directly to a Google Sheet.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.