YouTube comment scraper & analyzer with GPT-4o + email summary report
n8n12 modulesv1.0How 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
At a glance
YouTube comment scraper & analyzer with GPT-4o + email summary report is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Slack, Notion, Airtable. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Slack, Notion, Airtable, Google Sheets, OpenAI
- Modules
- 12
- Price
- Free
- Version
- v1.0
About this workflow
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: YoutubeVideo - 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 | |-----------|---------| | YoutubeVideo | Google Sheet to hold YouTube video IDs and status | | YoutubeCommentScraper.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
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create a new Google Task for every new item in Notion database
Create E-goi contact from new Google Sheets rows
Send a message to Slack when a new record in Attio is created
Run Apify tasks and add results to Google Sheets
Build a document QA system with RAG using Milvus, Cohere, and OpenAI for Google Drive
Generate AI short-form health videos with Gemini, Veo 3 and Google Sheets
Score and route inbound web leads with OpenAI, Gmail and Google Sheets
Manage Odoo CRM with natural language using OpenAI and MCP Server
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you