Who Should Use This?

Influencers, marketers, and data teams who want real‑time sentiment insights on YouTube comments—no manual exporting, no juggling platforms.

---

The Challenge

• Tedious Exports
  Manually downloading comments from YouTube Studio.

• Slow Sentiment Tagging
  Spending hours categorizing feedback by hand.

• Dispersed Data
  Scattered across multiple tools and spreadsheets.

---

Automated Workflow

From grabbing comments to logging sentiment in your sheet, everything happens seamlessly—letting you focus on insights instead of repetitive tasks.

---

What You’ll Get

1. Dynamic Input
   Pull video URLs straight from a “video_urls” column in Google Sheets.

2. Complete Comment Retrieval
   Fetch every top‑level comment, handling pagination in batches of 100.

3. AI‑Driven Sentiment Analysis
   Classify each comment as Positive, Neutral, or Negative using OpenAI.

4. Rich Metadata Capture
   Record author name, like counts, timestamps alongside sentiment labels.

5. Instant Sheet Updates
   Append new rows or update existing entries—your sheet stays reporting‑ready.

---

Easy Setup

1. Prepare Your Google Sheet
   Create a sheet with a video_urls column listing full YouTube links.

2. Authorize Google Sheets Access
   Add an OAuth or service‑account credential to n8n.

3. Enable YouTube Data API
   Turn on Data API v3 in Google Cloud, grab an API key, and store it in n8n’s HTTP credentials.

4. Configure OpenAI
   Enter your OpenAI API key under the “OpenAI Chat” credential in n8n.

5. Import the Workflow
   Copy the provided JSON into n8n.

6. Run on Demand
   Trigger manually in n8n to fetch and analyze comments instantly.

---

Customize to Your Needs

• Filter by Keywords or Likes
  Insert an IF node to only process comments matching your criteria.

• Schedule Regular Runs
  Swap the Manual Trigger for a Cron node for automated, recurring analysis.

• Advanced LLM Outputs
  Swap out sentiment classification for topic tagging, summaries, or translations by tweaking the chat prompt.

• Alternate Destinations
  Point results to Airtable, Notion, or any other database node instead of Google Sheets.