Bear Brown
← All N8N workflows
AI & researchGoogle SheetsHTTP RequestIfOpenAI Chat ModelManual Trigger

YouTube Comment Sentiment Analyzer

Configured with Google Sheets, HTTP Request, OpenAI Chat Model, Sentiment Analysis, and additional nodes. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗14 nodes · MIT
Workflow preview
TransformSplit OutSplit OutAI & modelsOpenAI Chat ModelOpenAI Chat ModelRoutingNo Operation, donothingNo OpData storeGet Video Urls fromGoogle SheetGoogle SheetsRoutingcheck next fetch timeis available or notIfRoutingcheck next fetch timeis before the current…IfWeb / APIGet Comments for videourlsHTTP RequestAI & modelsAnalyze sentiment ofevery commentSentiment AnalysisTransformFormat fields asrequired to save in…Edit FieldsData storeInsert and updatecomment in google sheetGoogle SheetsData storeUpdate last fetchedtime and…Google SheetsRoutingNo Operation, donothing1No OpTriggerWhen clicking ‘Testworkflow’Manual TriggerRoutingCheck Success ResponseIf

Node categories in this workflow

  • Transform
  • AI & models
  • Routing
  • Data store
  • Web / API
  • Trigger

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
Split OutTransformSplit OutSee node parameters
OpenAI Chat ModelAI & modelsOpenAI Chat ModelSee node parameters
No Operation, do nothingRoutingNo OpSee node parameters
Get Video Urls from Google SheetData storeGoogle SheetsSee node parameters
check next fetch time is available or notRoutingIfSee node parameters
check next fetch time is before the current timeRoutingIfSee node parameters
Get Comments for video urlsWeb / APIHTTP RequestSee node parameters
Analyze sentiment of every commentAI & modelsSentiment AnalysisSee node parameters
Format fields as required to save in google sheetTransformEdit FieldsSee node parameters
Insert and update comment in google sheetData storeGoogle SheetsappendOrUpdate
Update last fetched time and next_fetch_timeData storeGoogle SheetsappendOrUpdate
No Operation, do nothing1RoutingNo OpSee node parameters
When clicking ‘Test workflow’TriggerManual TriggerSee node parameters
Check Success ResponseRoutingIfSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • googleApi
  • httpQueryAuth
  • openAiApi

Workflow notes

**How to Use This Workflow:**

How to Use This Workflow:

📝 YouTube Comment Sentiment Analyzer

  1. 🔘 Trigger: Click "Execute Workflow" to run it manually.

  2. 📄 Your Google Sheet should have 2 sheets:

    • Sheet1 (Results with Sentiment):

      • Column A: commentId (YouTube comment id)
      • Column B: video_url (url of video)
      • Column C: comment (YouTube comment)
      • Column D: authorName (Name of author as per Youtube)
      • Column E: likes (Number of likes on that particular comment)
      • Column f: reply (Number of replies on that particular comment)
      • Column g: sentiment (Analyzed sentiment of the comment)
      • Column h: published_at (timestamp of comment published)

    • Sheet2 (Video URLs):

      • Column A: video_urls (list of YouTube video URLs)
      • Column B: last_fetched_time (timestamp of the last fetch)
      • Column C: next_fetch_time (time for the next fetch)

  3. 🔐 Make sure these credentials are set up:

    • Google Sheets (Service Account)
    • YouTube Data API v3
    • OpenAI API Key (for sentiment analysis)

  4. ✅ What this workflow does:

    • Reads video URLs from Sheet2.
    • Checks last fetched time (if applicable).
    • Fetches new comments from YouTube.
    • Analyzes sentiment using OpenAI.
    • Appends comment, sentiment, video ID, and timestamp to Sheet1.
    • Updates last_fetched timestamp in Sheet2.

  5. 💡 Tip:

    • You can replace the Manual Trigger with a Cron node for automatic execution at specified intervals.
YouTube Comment Sentiment Analyzer

YouTube Comment Sentiment Analyzer

Purpose and structure

This folder contains the YouTube Comment Sentiment Analyzer workflow. Its executable nodes use googleSheets, httpRequest, if, lmChatOpenAi, manualTrigger, noOp, sentimentAnalysis, set, splitOut. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

When clicking ‘Test workflow’

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Splitout/2016_Splitout_Noop_Automation_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • 🚀 YouTube Comment Sentiment Analyzer with Google Sheets & OpenAI

More in AI & research

"Hey Siri, Ask Agent" workflow#️⃣Nostr #damus AI Powered Reporting + Gmail + Telegram(G) - Email Classification