Automate YouTube Comment Analysis with OpenAI & n8n

Automate YouTube Comment Analysis with OpenAI & n8n

Transform the way you extract insights from your YouTube content with our automation workflow. Seamlessly monitor YouTube videos, derive sentiment analysis through OpenAI, and receive organized reports — all with just a Google Sheets entry and the power of n8n.

What this workflow does

• Real-time Monitoring: The workflow triggers every minute whenever a new row is added or updated in your designated Google Sheets, ensuring that your video IDs are checked efficiently.
• Fetch YouTube Data: Harness the YouTube Data API to retrieve detailed video metadata and top comment threads based on the video ID for stronger insights.
• Comprehensive Analysis: Extract stats such as comment count and average likes, then compile comments to send to OpenAI for a refined sentiment and theme breakdown.
• Email Reporting: Construct an HTML report from the analyzed data and automatically send it via Gmail to your configured recipient.
• Seamless Integration: Log the analyses back into your Google Sheets, marking videos as “No comments” if applicable.

Use cases

• Content Creators: Utilize this workflow to gain insights into audience feedback and adjust your content strategy based on real-time sentiment analysis.
• Marketing Teams: Leverage sentiment data to refine marketing strategies and understand the target audience’s reception of product launches or campaigns.
• Customer Support: Monitor feedback trends and identify potential issues through thematic analysis, improving customer experience and satisfaction.

Technical details

• Nodes Used: Google Sheets for triggering and updating; YouTube Data API for fetching comments; OpenAI for sentiment and theme analysis; Gmail for sending reports.
• Workflow Components: Utilizes a combination of 'if', 'set', 'code', 'gmail', 'filter', and 'sticky note' nodes within the n8n automation stack.