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: YoutubeVideo - Sheet structure: | ID | Video Title | YouTube Video ID | Status | - Add video IDs and set their Status as Pending