AutomationMart
Home/Browse/YouTube comment sentiment analysis with Google Gemini AI and Google Sheets
n8n

YouTube comment sentiment analysis with Google Gemini AI and Google Sheets

n8nn8n14 modulesv1.0
Google SheetsLinkedInInstagramGemini

This workflow automatically collects all comments from a specified YouTube video and analyzes the sentiment of each comment using an AI model (e.g., GPT, Claude or Gemini). The sentiment (Positive, Neutral, or Negative), its strength, and confidence score are extracted and saved into a connected Google Sheet for easy access, reporting, and visualization. --- Advantages: 🧠 AI-Powered Sentiment Analysis Uses modern language models (LLMs) to categorize comments with high accuracy. 📺 Ideal for YouT

At a glance

YouTube comment sentiment analysis with Google Gemini AI and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, LinkedIn, Instagram, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, LinkedIn, Instagram, Gemini
Modules
14
Price
Free
Version
v1.0
YouTube comment sentiment analysis with Google Gemini AI and Google Sheets workflow diagram

About this workflow

This workflow automatically collects all comments from a specified YouTube video and analyzes the sentiment of each comment using an AI model (e.g., GPT, Claude or Gemini). The sentiment (Positive, Neutral, or Negative), its strength, and confidence score are extracted and saved into a connected Google Sheet for easy access, reporting, and visualization. --- Advantages: 🧠 AI-Powered Sentiment Analysis Uses modern language models (LLMs) to categorize comments with high accuracy. 📺 Ideal for YouTube Creators & Marketers Provides insights into audience perception of videos, campaigns, or products. 📈 Real-Time Feedback Monitoring Quickly identify trends in viewer sentiment across large comment volumes. 📊 Automatic Reporting Saves results in Google Sheets for easy sharing or dashboard integration. 🔁 Handles Pagination Automatically fetches all comments, even from multi-page videos. ⚙️ No-Code Customization Easily adaptable to other platforms (e.g., TikTok, Instagram) or data sources. 📥 Simple Setup Requires just a YouTube video ID and API key — no coding needed. 🔁 Loop and Update Logic Continuously updates sheet with new results, avoiding duplicate processing. 🧩 Modular Design Easy to expand (e.g., reply classification, toxic comment detection, translation). 💬 Multi-Language Compatibility AI can be configured to analyze comments in different languages with minimal setup. --- How It Works 1. Trigger: The workflow starts manually ("When clicking ‘Test workflow’") or can be scheduled. 2. Fetch Comments: The "Get API Comments" node retrieves comments from a YouTube video using the YouTube API. 3. Process Comments: - Extracts comments and replies via the "Comments" node. - Splits them into individual entries ("Split comments"). - Saves raw comments to Google Sheets ("Save comments"). 4. Sentiment Analysis: - Uses Google Gemini AI (or another model) to classify each comment as Positive, Neutral, or Negative. - Captures strength and confidence metrics for deeper insights. 5. Update Results: The "Update sentiment" node writes the analysis back to Google Sheets, marking processed rows. 6. Pagination Handling: Checks for multiple pages of comments ("Multipage?") and loops until all are processed. --- Set Up Steps 1. Prepare Google Sheet: - Clone the template: YouTube Comments Sheet. - Ensure columns exist: VIDEOID, COMMENTS, SENTIMENT, STRENGTH, CONFIDENCE, and DO (tracking column). 2. Configure YouTube API: - Obtain a YouTube API key from Google Developers Console. - Add it to the "Get API Comments" node under Youtube Query Auth (parameter: key). 3. Set Video ID: - Replace the default xxxxxxxx in the "ID Video" node with your target YouTube video ID. 4. AI Integration: - Ensure Google Gemini API credentials are configured in the "Google Gemini" node. 5. Run the Workflow: - Test manually or automate execution (e.g., hourly/daily) to analyze new comments. Output: A Google Sheet with categorized sentiments, enabling trend analysis and audience engagement tracking. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Add new leads from Facebook Lead Ads to Google Sheets and update existing rows

Automatically add new Facebook Lead Ads leads to Google Sheets and update existing rows, ensuring your data stays current and organized.

Free

Generate and publish Instagram carousels with Gemini and Google Slides

Generate and publish Instagram carousels automatically Turn a single topic into a published Instagram Carousel in minutes. Creating educational carousel posts usually takes hours: writing the script, designing the slides in Figma/Canva, exporting images, and scheduling. This workflow automates the entire pipeline using Gemini AI, Google Slides, and the Meta Graph API. It generates the content, designs the visuals by manipulating a template, and publishes the carousel directly to your Instagram B

Free

Sync new Google Sheets rows to Ninox for record management

Streamline your data management process by automatically syncing updates from Google Sheets to Ninox. With this template, every time a new row is added or an existing row is modified in your Google Sheets, Make will create or update the corresponding records in Ninox. This ensures that your database is always up-to-date, allowing for more efficient project management and collaboration. Make sure your Google Sheets has the necessary columns set up to match the fields in Ninox for seamless integra

Free

Automate sales meeting prep with AI & APIFY sent to WhatsApp

This n8n template builds a meeting assistant that compiles timely reminders of upcoming meetings filled with email history and recent LinkedIn activity of other people on the invite. This is then discreetly sent via WhatsApp ensuring the user is always prepared, informed and ready to impress! How it works A scheduled trigger fires hourly to check for upcoming personal meetings. When found, the invite is analysed by an AI agent to pull email and LinkedIn details of the other invitees. 2 subwor

Free

Atualiza Estágio no CRM (Agendor)

Template by Thales Laray, da Escola de Automação & I.A https://instagram.com/thaleslaray

Free

Add new Google Sheets rows as TimeCamp tasks

When you add new rows to your Google Sheets sheet, a corresponding TimeCamp task will be created.

Free

IOT device control with MQTT and webhook

IOT device control with MQTT and webhook This workflow is for users wanting a practical example of how to control IOT systems using the MQTT protocol in an an n8n environment. The template provides typical n8n MQTT and Webhook node implementation and configuration settings necessary to set IOT device inputs and outputs. How it works A webpage with IOT control 'on and 'off' buttons is presented to the user. When a button is selected on the webpage the value is sent via a webhook to trigger the ac

Free

GitHub automation hub: complete API controls for AI agents

Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? Join the community Quick Setup Guide: 1️⃣ Import this template into your n8n instance. 2️⃣ Configure GitHub credentials for the nodes. 3️⃣ Connect your MCP client --------- THAT'S IT! ------- tl;dr Supercharge your GitHub project management and development by integrating powerful AI capabilities directly into your n8n workflows! This template deploys a robust SSE endpoint spec

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free