Latenode

Automate YouTube comment analysis & email summary reports

This workflow automates the collection and analysis of YouTube comments from a video, using the YouTube API, OpenAI (GPT-4o), and Gmail to send a summary report via email. It provides insights on sentiment, common topics, viewer questions, and feedback for content creators and social media analysts.

The workflow fetches the comments, analyzes them using GPT-4o, and sends a structured email report with actionable insights. Whether you're a YouTuber, 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.

Updated Apr 6, 2026Est. run: 26sEst. cost: $0.0703
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Scraping & data collection

Workflow preview

What this template does

  • Extracts YouTube comments from a video using the YouTube API
  • Analyzes the comments for sentiment, common topics, and viewer questions using GPT-4
  • Generates a summary report with actionable insights and sends it via email using Gmail
  • Enables content creators and social media analysts to understand audience feedback
  • Triggers the entire workflow from a simple spreadsheet

How it works

1
Trigger

Get YouTube video details

The workflow is triggered to fetch and analyze comments for a specific YouTube video. This initial step configures the video ID and the maximum number of comments to retrieve.

2
Action

Fetch YouTube comments

Using a headless browser, the workflow scrapes the comments from the specified YouTube video, gathering the full text of each comment.

3
Action

Prepare comments for analysis

The fetched comments are extracted and formatted in a structured format, ready for analysis by the AI model.

4
AI

Analyze comments with GPT-4o

The formatted comments are processed by the GPT-4o language model, which generates insights on sentiment, common topics, viewer questions, and overall feedback.

5
Action

Send email summary report

The analysis results are compiled into a structured email report and sent to the user's inbox, providing actionable insights on the YouTube video's comments.

6
Action

Update status in Google Sheet

The workflow marks its completion by updating a tracking spreadsheet, allowing the user to monitor the status of the comment analysis process.

Setup guide

1

Add YouTube API Credential

1. Go to the Latenode Credentials panel. 2. Click 'Add New Credential'. 3. Select the 'YouTube' integration. 4. Follow the steps to authenticate your YouTube account and obtain the necessary API credentials.

2

Configure OpenAI Credential

1. Go to the Latenode Credentials panel. 2. Click 'Add New Credential'. 3. Select the 'OpenAI' integration. 4. Enter your OpenAI API key in the credential settings.

3

Set up Gmail Credential

1. Go to the Latenode Credentials panel. 2. Click 'Add New Credential'. 3. Select the 'Gmail' integration. 4. Follow the steps to authenticate your Gmail account and grant the necessary permissions.

4

Configure YouTube Comment Fetcher Node

1. In the Latenode visual builder, add a 'YouTube' node. 2. In the node settings, select the 'Get Video Comments' operation. 3. Choose the YouTube credential you added earlier. 4. Enter the YouTube video ID you want to fetch comments for. 5. Adjust the 'Max Comments' setting to control the number of comments to process.

5

Set up OpenAI Analysis Node

1. In the Latenode visual builder, add an 'OpenAI LLM Chat' node. 2. In the node settings, select the OpenAI credential you added earlier. 3. Configure the node to use the GPT-4o model for the analysis. 4. Provide the necessary prompts and settings to analyze the YouTube comments and generate the summary report.

Requirements

YouTube Data API key to fetch video comments
OpenAI API key to analyze the sentiment and topics of the comments using GPT-4o
Gmail account or API key to send the summary report via email
Latenode workspace with access to the 'headless-browser', 'openai-gpt-assistants', and 'gmail' nodes

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.

More templates

You might also like

Browse all templates →
Scraping & data collection

Automatically Sync Google Maps Business Data to a Spreadsheet

This automation workflow allows users to efficiently scrape business data from Google Maps, including names, contact details, and reviews, and export the structured information into a spreadsheet or database. The workflow uses the SerpAPI service to retrieve Google Maps search results, which are then transformed and appended to a Google Sheet. This enables users to generate leads, conduct market analysis, and gain valuable insights from the collected data in a cost-effective and scalable manner.

26s$0.0703
Scraping & data collection

Scrape Zillow property data and sync to Google Sheets automatically

This Latenode automation extracts real estate listing details from Zillow and automatically populates a Google Sheets spreadsheet with the property data. It leverages the Scrape.do web scraping API to bypass anti-bot protections and fetch the full HTML of Zillow listings, then parses key information like price, address, days on Zillow, and Zestimate, and saves the structured results into a Google Sheet. This solution is designed for real estate professionals, investors, and market analysts who need to collect property data at scale without manual effort, enabling better market research, portfolio tracking, and lead generation.

9s$0.0006
Scraping & data collection

Automatically scrape and store Booking.com hotel data

This workflow automates the search and extraction of hotel data from Booking.com, triggered by a chat message. It uses a combination of web scraping with Bright Data's Web Scraper and AI-powered data processing with OpenRouter to deliver a concise, human-friendly list of hotels, including the title, address, original price, and final price. The final output is a clean and formatted report, making it a valuable tool for travelers, event planners, and business professionals who need to quickly find accommodation.

26s$0.0703