YouTube Comment Scraper & Analyzer with GPT-4o + Email Summary Report

How it Works

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.

🎯 Use Case

Ideal for:

• YouTubers monitoring audience sentiment
• Marketing teams analyzing campaign feedback
• Community managers summarizing engagement

Setup Instructions

1. Upload the Spreadsheet

• File name: Youtube_Video
• Sheet structure: | ID | Video Title | YouTube Video ID | Status |
• Add video IDs and set their Status as Pending

2. Configure Google Sheets Nodes

Connect your Google account to:

• Pick Video IDs from Google Sheet
• Update Status on Google Sheet

3. Add API Credentials

• YouTube API Key → for comment + video scraping nodes
• OpenAI API Key → for analyzing comments
• Gmail Account → for sending the summary email

4. Activate the Workflow

Once live, the workflow will:

1. Watch for new or updated rows in the spreadsheet
2. Scrape comments using the YouTube API
3. Analyze sentiment and key themes via GPT-4o
4. Send a formatted HTML email with the summary
5. Update the spreadsheet status to Mail sent

🔁 Workflow Logic

1. Trigger: New/updated row in Google Sheet
2. Retrieve: YouTube video metadata + comments
3. Analyze: Comments using GPT-4o
4. Email: Summary report via Gmail
5. Update: Spreadsheet status to Mail sent

🧩 Node Descriptions

| 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' |

🛠️ Customization Tips

• 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

📒 Suggested Sticky Notes for Workflow

| 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" |

📎 Required Files

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

🧪 Testing Tips

• 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

🏷 Suggested Tags & Categories

• #YouTube
• #OpenAI
• #Automation
• #Marketing
• #Email
• #Analytics