Analyze YouTube comment sentiment and save to Google Sh

This automation template helps content creators and marketers systematize audience feedback by analyzing the sentiment of comments under YouTube videos and saving structured data to Google Sheets. The process is manually triggered and ideal for regular monitoring of video content perception.

## Who it´s for
- YouTube channel owners who want to analyze audience reactions
- Marketers assessing video content effectiveness
- Brands monitoring feedback in comments on promotional videos
- Agencies conducting social engagement audits

## What the automation does
- Starts manually and checks Google Sheets for videos marked as ´Ready´
- Retrieves all comments via YouTube API for each listed video
- Uses Google Gemini (via LangChain) to analyze sentiment of each comment — positive, neutral, or negative
- Stores labeled comments in a dedicated ´Results´ sheet
- Updates video status to ´Processed´ to prevent reprocessing

## What´s included
- Ready-to-use n8n workflow
- Logic for manual trigger and status-based filtering
- Integrations with YouTube, Google Sheets, and Google Gemini via API
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- Access to Google Sheets with edit permissions
- Enabled YouTube Data API and access key
- Google Gemini API access
- Credentials for all services configured in environment variables or n8n credentials

## Benefits and outcomes
- Saves time on manual comment collection and analysis
- Provides structured data for reporting and decision-making
- Enables identification of content perception trends
- Supports quick response to negative feedback
- Prevents duplicate processing with automatic status updates

## 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.