๐ YouTube comment analysis with GPT-4o & automated email reports via Gmail
โก 209 views ยท ๐ Market Research & Insights
๐ก Pro Tip โ YouTubeโs API quotas can be a bottleneck when youโre pulling data at scale. ScraperNode is a community node with dedicated scrapers for channels, videos, and comments โ no quota limits, just structured data.
Description
Description:
Leverage the power of ChatGPT and YouTube API to monitor, analyze, and report on video feedback automatically. This n8n automation template fetches comments from a YouTube video, performs advanced AI sentiment analysis, identifies key themes, and emails a professional reportโall triggered from a Google Sheet.
What This Template Does:
- ๐ Auto-Triggers from Google Sheets every minute
- ๐ฅ Fetches YouTube video details and top comments
- ๐ง Uses GPT-4o for comment sentiment analysis, theme detection, viewer questions & improvement insights
- ๐ง Generates and sends an HTML email report with all key insights
- ๐ Marks videos as โMail Sentโ in the sheet to prevent duplicate reports
Setup Requirements:
- YouTube API Credentials
- OpenAI API Credentials
- Gmail credentials for email delivery
- Google Sheet with video tracking
Ideal for:
YouTube creators, marketers, social media analysts, or agencies seeking automated YouTube comment sentiment analysis and actionable content insightsโwithout writing a line of code.
๐ Nodes Used
Google Sheets, HTTP Request, Gmail, YouTube, Google Sheets Trigger, AI Agent
๐ฅ Import
Download workflow.json and import into n8n:
Workflow menu โ Import from File