AI analysis of YouTube comments with email reports trig

This automation template helps YouTubers and SMM teams quickly gain structured audience feedback without manual comment processing. When a new video ID is added to Google Sheets, the system collects comments, runs AI-powered sentiment analysis, and delivers a clean HTML report via email.

## Who it´s for
- YouTube channel owners looking to automatically analyze audience reactions
- Marketers tracking viewer feedback in video comments
- SMM specialists needing regular engagement analytics
- Agencies managing multiple channels requiring scalable monitoring

## What the automation does
- Triggers when a new row with a video ID is added to Google Sheets
- Retrieves up to 100 top comments via YouTube API
- Sends text data to an AI agent powered by LangChain and Azure OpenAI
- Generates a structured HTML report with sentiment, key themes, and insights
- Emails the report using Gmail integration
- Updates the video status in Sheets to ´Mail Sent´ to prevent reprocessing

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on new Google Sheets rows
- Integrations with YouTube, Google Sheets, Gmail, and Azure OpenAI
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n instance with access to HTTP, Google, and LangChain nodes
- Google Workspace account (Sheets, Gmail)
- YouTube Data API key or OAuth credentials
- Azure OpenAI access with a deployed model compatible with LangChain

## Benefits and outcomes
- Saves time on manual comment analysis
- Provides consistent, standardized insights per video
- Detects negative sentiment, common questions, and viewer suggestions
- Streamlines team workflows with automated reporting
- Enables scalable monitoring across multiple videos or channels
- Supports content decisions with real audience data

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.