YouTube Comment Scraper & Analyzer with GPT-4 + 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-4)**, 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-4 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-4 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-4 | | 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

Platform

n8n

Category

Data & Analytics

Price

$14.99

Creator

Amit Mehta

• YouTube
• OpenAI
• Automation
• Marketing
• Email
• Analytics
• if
• set
• code
• gmail