This n8n workflow automates the analysis of YouTube video details and viewer comments to generate a comprehensive, data-driven report for content creators. By collecting video metadata and audience feedback, the workflow provides actionable insights that help creators understand what works, what doesn’t, and how to optimize future content. The final report can be delivered via Gmail or stored in Google Drive in Markdown/HTML format.
Key Features
- Automated Data Retrieval:
- Fetches video details (title, description, stats) from YouTube Data API
- Collects video comments with pagination (supports large datasets)
- AI-Powered Analysis:
- Uses OpenAI’s GPT model to analyze comments, detect sentiment, and extract trends
- Generates detailed audience insights and content opportunities
- Customizable Reporting:
- Produces a structured Markdown report with recommendations, keywords, and audience profiling
- Converts Markdown to HTML for better formatting in emails or storage
- Flexible Output Options:
- Sends the generated report via Gmail
- Saves the report to Google Drive for archival and sharing
- Scalable & Modular Design:
- Easily adaptable for multiple video IDs or batch analysis
- Supports external trigger execution or manual testing
