Analyze YouTube Comments Sentiment with Gemini AI & Google Sheets

This n8n workflow automates the extraction and sentiment analysis of YouTube video comments, helping users gain deep insights into audience feedback. It reads video URLs marked 'Ready' from a Google Sheets 'Video URLs' tab, fetches comments using the YouTube API, and employs a Gemini AI Agent to classify each comment as Positive, Neutral, or Negative. Results are stored in a dedicated 'Results' tab, and processed URLs are updated to 'Finished' status to prevent reprocessing.

The workflow handles edge cases efficiently: it skips empty URLs, verifies API responses, and bypasses videos without comments. This ensures reliable operation even for large batches. By leveraging Gemini's advanced NLP capabilities, it provides structured, actionable data beyond raw comment counts, saving hours of manual review.

Ideal for YouTube creators monitoring feedback, social media managers optimizing engagement, brand teams tracking campaigns, or marketing agencies auditing performance. Benefits include scalable analysis, real-time insights, and seamless Google Sheets integration for reporting and visualization. Setup is straightforward: import the workflow, connect your Google Sheets and YouTube API credentials, and add Gemini API key.