YouTube Comment Sentiment Analyzer with Sheets & OpenAI

This workflow streamlines YouTube comment analysis by reading video URLs from a Google Sheet, fetching all top-level comments (handling pagination at 100/page via YouTube Data API v3), and using OpenAI to classify each as Positive, Neutral, or Negative. It captures key metadata like author, likes, and timestamp, then appends or updates formatted results back to your Google Sheet, ready for charts, reports, or further automation.

Benefits include eliminating manual exports and tagging, saving hours per video. Gain real-time audience sentiment trends to refine content, spot issues early, and boost engagement—perfect for influencers, marketers, and teams without dedicated analysts. Scalable for multiple videos in one run.

Ideal use cases: Monitor campaign feedback, track brand perception post-launch, A/B test video styles by sentiment scores, or integrate with dashboards for live metrics. Customize with filters for high-like comments or specific keywords.

Setup is straightforward: Prepare a Sheet with 'video_urls' column, add credentials for Sheets, YouTube API key, and OpenAI, import the JSON, and trigger manually. Handles everything end-to-end for actionable insights.