YouTube Comment Sentiment Analysis Automation

This workflow automates the collection and analysis of YouTube comments from a video and sends a summary report via email, using Google Sheets, the YouTube API, OpenAI (GPT-4o), and Gmail.

Whether you're a content creator, brand manager, or social media analyst, this workflow helps you automate sentiment analysis and receive insights directly in your inbox — all triggered from a simple spreadsheet.

Ideal for:

YouTubers monitoring audience sentiment

Marketing teams analyzing campaign feedback

Community managers summarizing engagement

File name: Youtube_Video

Sheet structure: | ID | Video Title | YouTube Video ID | Status |

Add video IDs and set their Status as Pending

Connect your Google account to:

YouTube API Key → for comment + video scraping nodes

OpenAI API Key → for analyzing comments

Gmail Account → for sending the summary email

Once live, the workflow will:

Watch for new or updated rows in the spreadsheet

Scrape comments using the YouTube API

Analyze sentiment and key themes via GPT-4o

Send a formatted HTML email with the summary

Update the spreadsheet status to Mail sent

Trigger: New/updated row in Google Sheet

Retrieve: YouTube video metadata + comments

Analyze: Comments using GPT-4o

Email: Summary report via Gmail

Update: Spreadsheet status to Mail sent

Node Name Description Pick Video IDs from Google Sheet Watches the spreadsheet and retrieves pending video IDs If Checks whether status is 'Pending' Limit Restricts the number of processed rows Set Video Details Prepares video info (e.g., title, channel) Get YouTube Video Details Fetches metadata (title, channel, etc.) Get YouTube Video Comments Pulls top-level comments using YouTube API Prepare Comments Data Formats comment text for OpenAI AI Agent Summarizes comments using OpenAI's GPT-4o Prepare HTML for Email Converts summary into HTML for email body Gmail Account Configuration Sends the email report via Gmail Update Status on Google Sheet Marks the row as 'Mail sent'

Change the AI prompt for tone, length, or custom metrics

Send results to Slack or Telegram instead of Gmail

Export summaries to Notion, Airtable, or PDF

Schedule it daily/weekly for recurring analysis

Node/Section Sticky Note Content Pick Video IDs from Google Sheet "Triggers on new YouTube videos in your spreadsheet" AI Agent "Uses OpenAI to generate an analysis summary – customize prompt as needed" Gmail "Sends summary report – you can update subject, recipients, or style" Update Status "Marks video as processed to avoid duplicate runs"

File Name Purpose Youtube_Video Google Sheet to hold YouTube video IDs and status Youtube_Comment_Scraper.json Main n8n workflow export for this automation

Add one test video with a valid YouTube video ID and status = Pending

Monitor the workflow logs to confirm API responses

Confirm summary delivery in your inbox

Verify that status updates in the sheet

#YouTube

#OpenAI

#Automation

#Marketing

#Email

#Analytics