Latenode
Google sheets
YouTube
OpenAI GPT Assistants
Gmail

Streamline YouTube comment analysis and reporting with GPT-4

This automation workflow helps content creators, brand managers, and community managers monitor and analyze YouTube comments. It scrapes comments from a specified video, uses OpenAI's GPT-4o model to generate insights on sentiment, themes, and feedback, and then sends a comprehensive email summary report.

The workflow is triggered by new or updated rows in a Google Sheet, which tracks the video IDs and processing status. It fetches video details, collects the top comments, processes the data, and sends the analysis through Gmail. This streamlined solution enables users to quickly gather and understand their audience's engagement, sentiment, and suggestions, helping them make informed decisions about their content and community strategy.

Updated Apr 2, 2026Est. run: 25sEst. cost: $0.0016
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

  • Fetches top comments from a specified YouTube video
  • Analyzes comments using OpenAI's GPT-4 to generate insights on sentiment, themes, and feedback
  • Sends a comprehensive email summary report with the analysis results
  • Tracks video IDs and processing status in a Google Sheet
  • Enables users to understand their audience's engagement and make informed content decisions

How it works

1
Trigger

Monitor Google Sheet for new/updated rows

The workflow starts by monitoring a Google Sheet for new or updated rows. Each row represents a YouTube video to be processed, tracking its details and processing status.

2
Action

Fetch video metadata

When a new or updated row is detected, the workflow fetches the video's metadata, including the title, description, and other details, from the YouTube API.

3
Action

Retrieve top 100 comments

The workflow then collects the top 100 comments for the specified video from the YouTube API.

4
AI

Analyze comments using GPT-4

The collected comments are then processed using OpenAI's GPT-4 model to generate insights on sentiment, themes, and audience feedback.

5
Action

Send email report

A comprehensive email report summarizing the analysis is then sent to the specified recipients through the Gmail integration.

6
Action

Update video status

Finally, the workflow updates the corresponding row in the Google Sheet to mark the video as having been processed and the report sent.

Setup guide

1

Add Google Sheets Credential

1. In the Latenode Credentials panel, add a new credential for Google Sheets. Select the 'Google Sheets' integration and complete the OAuth flow to grant Latenode access to your Google Sheets account.

2

Configure Google Sheets Trigger

2. Add the 'Google Sheets' trigger node to the workflow. In the node settings, select the Google Sheets credential you added, choose the spreadsheet and worksheet that contain the video IDs and processing status, and map the columns for ID, Video Title, YouTube Video ID, and Status.

3

Add OpenAI Credential

3. In the Latenode Credentials panel, add a new credential for OpenAI. Enter your OpenAI API key to enable the AI Agent node to access the GPT-4o model for comment analysis.

4

Configure Gmail Account

4. In the Latenode Credentials panel, add a new credential for Gmail. Select the 'Gmail' integration and complete the OAuth flow to grant Latenode access to your Gmail account, which will be used to send the email summary report.

5

Map YouTube API Credentials

5. In the 'Get YouTube Video Details' and 'Get YouTube Video Comments' nodes, map the YouTube API credentials you have added to the Latenode Credentials panel. This will allow the workflow to fetch video metadata and comments from YouTube.

Requirements

A Google Sheets account with access to the spreadsheet that tracks the video IDs and processing status
A Gmail account with the ability to send emails
An OpenAI API key to access the GPT-4o model for sentiment and theme analysis
A YouTube Data API key to fetch video details and comments

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.
Contact support →

More templates

You might also like

Browse all templates →
Scraping & data collection

Scrape and export Google Maps business data to Google Sheets

This automation 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 for lead generation and market analysis. The workflow triggers manually or on a scheduled basis, fetching search results from Google Maps using the SerpAPI service, deduplicating the data, and writing it to a Google Sheet. This streamlines the process of gathering valuable business intelligence from Google Maps, empowering users to leverage this data for strategic decision-making and sales prospecting.

11s$0.0007
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

Automate Instagram profile data export to Google Sheets

This automation template allows users to scrape comprehensive Instagram profile data using the Apify platform, and automatically export the results into a Google Sheets spreadsheet for analysis. It is designed to run on a schedule, processing a list of usernames by calling the Apify API, appending the scraped data to a Google Sheet, and marking the usernames as processed. The automation integrates with Google Sheets and the Apify actor, providing a streamlined way to gather and organize Instagram profile information without manual intervention.

15s$0.0009