Library / Reports, Analytics & Dashboards
Reports, Analytics & Dashboards
Analyze YouTube Comments with OpenAI and Report by Gmail
When triggered, this fetches a video's details and comments from YouTube, has OpenAI analyze them, saves results to Google Sheets and emails a report by Gmail.
What it does
# 📊 YouTube Comment Analyzer Workflow Purpose: Automate YouTube comment collection, sentiment analysis, and email reporting Schedule: Triggers every minute for new/updated rows Required Setup: 1. Google Sheet with video IDs 2. YouTube API credentials 3. OpenAI API key 4. Gmail account ## Workflow Steps: 1. Trigger - Monitor Google Sheet 2. Filter - Process only 'Pending' videos 3. Fetch - Get video details & comments 4. Analyze - AI sentiment analysis 5. Report - Send email summary 6. Update - Mark as processed
The steps
- Limit
- AI Agent
- OpenAI Chat Model
- If
- Set Video Details
- Get Youtube Video Details
- Get Youtube Video Comments
- Prepare Comments Data
- Prepare HTML for Email
- Gmail Account Configuration
- Update Status on Google Sheet
- Pick Video Ids from Google sheet
Similar automations
Content Writing & GenerationAnalyze YouTube Comments with OpenAI and Email a Report17 stepsReports, Analytics & DashboardsAnalyze YouTube Comments with Azure OpenAI and Email Results12 stepsAI Agents & AssistantsChat with YouTube Comments and Channels Using OpenAI22 stepsWeb Scraping & ResearchExtract YouTube Video Comments into Google Sheets11 steps