Automated YouTube Comment Sentiment & Insights Workflow

This n8n workflow automates the process of analyzing YouTube video comments for sentiment and content insights, then compiles and sends a comprehensive report via email. Designed for content creators and marketers, it integrates Google Sheets, YouTube API, OpenAI GPT, and Gmail to streamline video feedback analysis.

The workflow begins with a Google Sheets trigger that monitors a spreadsheet for new or updated video IDs marked as ‘Pending’. Upon detection, it fetches the video details and the top 100 comments using the YouTube API. Comments are then processed to extract text, calculate statistics like total comments, likes, and replies, and perform basic sentiment analysis based on keyword presence.

Processed comment data, along with video metadata, is analyzed by GPT-4o to generate structured insights into viewer sentiment, main discussion themes, common questions, key feedback points, and actionable suggestions. These insights are formatted into a professional HTML email report, including statistics and detailed analysis.

The email is sent through Gmail, and the spreadsheet is updated to mark the video as “Mail Sent” to prevent reprocessing. This workflow supports continuous, automated feedback collection and analysis for YouTube content strategies, making it a valuable tool for content creators looking to enhance engagement and optimize video content based on viewer feedback.