AutomationMart
Home/Browse/🚀 YouTube comment sentiment analyzer with Google Sheets & OpenAI
n8n

🚀 YouTube comment sentiment analyzer with Google Sheets & OpenAI

n8nn8n14 modulesv1.0
NotionAirtableGoogle SheetsOpenAI

YouTube Comment Sentiment Analyzer with Google Sheets & OpenAI --- Who Should Use This? Influencers, marketers, and data teams who need instant insights into audience sentiment—without manual exports or scattered tools. --- The Challenge - Manual exports from YouTube Studio - Time-consuming sentiment tagging - Data scattered across multiple platforms Our workflow automates everything: from fetching comments to logging analysis—so you can focus on insights, not spreadsheets. --- What You’ll Ge

At a glance

🚀 YouTube comment sentiment analyzer with Google Sheets & OpenAI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Notion, Airtable, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Notion, Airtable, Google Sheets, OpenAI
Modules
14
Price
Free
Version
v1.0
🚀 YouTube comment sentiment analyzer with Google Sheets & OpenAI workflow diagram

About this workflow

YouTube Comment Sentiment Analyzer with Google Sheets & OpenAI --- Who Should Use This? Influencers, marketers, and data teams who need instant insights into audience sentiment—without manual exports or scattered tools. --- The Challenge - Manual exports from YouTube Studio - Time-consuming sentiment tagging - Data scattered across multiple platforms Our workflow automates everything: from fetching comments to logging analysis—so you can focus on insights, not spreadsheets. --- What You’ll Get 1. Dynamic Input Read a list of YouTube URLs from your Google Sheet. 2. Full Comment Harvest Pull all top-level comments (handles pagination 100/page). 3. Deep Sentiment Scan Classify each comment as Positive, Neutral, or Negative using OpenAI. 4. Smart Formatting Capture metadata (author, likes, timestamp) alongside sentiment. 5. Seamless Storage Append or update rows in your Google Sheet—ready for reporting. --- Easy Setup 1. Prepare Google Sheet - Create a sheet with a videourls column (full YouTube links). - Add and authorize a Google Sheets Oauth or service-account credential in n8n. 2. Enable YouTube API - Activate Data API v3 in Google Cloud, grab an API key, and save as an HTTP credential in n8n. 3. Configure OpenAI - Enter your API key under the “OpenAI Chat” credential in n8n. 4. Import the Workflow - Paste the provided JSON into n8n. 5. Run Manually - Use the Manual Trigger node to start fetching and analyzing comments on demand. --- Customize to Your Needs - Filter Comments: Add an IF node to process only comments with specific keywords or minimum likes. - Automate Schedule: Swap the Manual Trigger for a Cron node if you later want periodic runs. - Extended Analysis: Swap sentiment classification for topic extraction, summarization, or translation by tweaking the LLM prompt. - Alternate Destinations: Replace Google Sheets with Airtable, Notion, or any database node. --- Tags YouTube Google Sheets OpenAI Sentiment Analysis n8n Manual Trigger

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

Create Streamlabs alerts for new Google Sheets rows

Make will watch your Google Sheets rows at regular intervals and create Streamlabs alerts. Here's the [sheet](https://docs.google.com/spreadsheets/d/1xWeO2LdJAafcHFVh-yJgqljMeEaAc6sDyWDFHBSlNNQ/edit?usp=sharing) used in this scenario.

Free

Automated blog post generation with GPT-4 and publishing to Ghost CMS

Writes original, thought-provoking blog posts using AI 🕓 Runs every 12 hours automatically ✍️ Publishes directly to Ghost blog with title, tags, and SEO meta 🔧 Features Scheduled every 12 hours OpenAI generates a multi-part blog post with metadata Markdown-compatible output (no HTML) Automatically published to Ghost CMS using authenticated API (🔐 no hardcoded keys) Fully modular and general-purpose — edit prompt for any blog theme! ⚙️ Nodes Overview Step Node T

Free

Generate barcode from data in Google Sheets rows and save it to FileCloud

When a new row is added in Google Sheets spreadsheet, a new Barcode with data from the row is generated and the output file with the barcode is then uploaded to specified folder in FileCloud.

Free

Automate customer feedback analysis with Forms, AI, Google Sheets and WhatsApp

Automate Customer Feedback Analysis with Google Sheets, WhatsApp, and Email Introduction: Drowning in Data, Starving for Insight? Imagine this: Your team launches a new feature. Feedback starts pouring in emails, support tickets, social media mentions, and survey responses. You know gold is buried in there, but manually reading, tagging, and summarising hundreds, maybe thousands, of comments? It takes days, maybe weeks. By the time you have a clear picture, the moment might have passed. Sounds e

Free

Save Memberships in Memberstack to a Google Sheets spreadsheet

Every time an event occurs on membership from a member in Memberstack, Make will automatically add information to your Google Sheets spreadsheet as a new row. The template uses [this example spreadsheet.](https://docs.google.com/spreadsheets/d/1Cjmv0NUDYSRL0QmuEXc_KNvqVsErKcj80VevTYzoWbY/edit?usp=sharing)

Free

Google Search Console and analytics analysis with AI optimizations

What Is This? This workflow is a comprehensive solution for automating website audits and optimizations, leveraging advanced technologies to boost SEO effectiveness and overall site performance. Who Is It For? Designed for SEO specialists, digital marketers, webmasters, and content teams, this workflow empowers anyone responsible for website performance to automate and scale their audit processes. Agencies managing multiple client sites, in-house SEO teams aiming to save time on routine

Free

Automate lead intelligence & outreach with GPT-4o, LinkedIn, HubSpot & Outlook

AI Lead Intelligence & Outreach: Verified Emails, HubSpot Sync & Outlook Drafts Who is this for? This workflow is designed for sales/RevOps teams, B2B founders, SDR/AE teams, and agencies who live in HubSpot and need consistent, compliant first-touch outreach at scale. If you regularly build reusable, multi-client n8n automations, this template will save you hours of manual work. --- What prob

Free

Close tickets faster 🛠️ Zammad tool MCP server 💪 all 20 operations

Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? Join the community Complete MCP server exposing all Zammad Tool operations to AI agents. Zero configuration needed - all 20 operations pre-built. ⚡ Quick Setup 1. Import this workflow into your n8n instance 2. Activate the workflow to start your MCP server 3. Copy the webhook URL from the MCP trigger node 4. Connect AI agents using the MCP URL 🔧 How it Works • MCP Trigger: Serv

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