Track sentiment and keywords in your YouTube comments automatically

Reads new YouTube comments, scores each one for sentiment, and sends you a Telegram summary report.

How the work actually flows

A straight line. Runs once per each video in your list.

Pattern: Multiple Instances without Synchronization (12)

flowchart TD trig(["scheduled check of videos"]):::trigtime s0[["pull comments per video"]]:::mi s1["score sentiment and keywords"]:::task s2[("save results, skip duplicates")]:::store s3["send video summary to Telegram"]:::svc trig --> s0 s0 --> s1 s1 --> s2 s2 --> s3 out[/"sentiment scores and summary report"/]:::out pay{{"instant read on audience reaction"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepAn outside serviceRuns once per itemA record or sheetResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Messaging & NotificationsSpreadsheet & Database OpsReporting & AnalyticsSurvey & FeedbackScheduling & Calendar
Connects
YouTubeGoogle SheetsTelegramOpenRouter

The problem it solves

You know your audience is talking in the comments, but reading through hundreds of them for every video takes hours you don't have. Important complaints or good ideas get buried, and you never get a clear read on how people actually feel.

Who it fits

A YouTube channel owner or content team that wants to understand audience reaction without reading every comment.

How it works

  1. On a set schedule, the system checks the videos listed in your spreadsheet
  2. It pulls the comments from each video
  3. AI reads every comment and tags its sentiment, score, keywords, and language
  4. Results are saved into your Google Sheet, with duplicates skipped
  5. A summary report for each video is sent to your Telegram chat
What you get

Sentiment trends across your comments

You get a Telegram summary of how viewers feel about each video, with every comment scored, tagged, and organized for you.

What you get

A running spreadsheet of comment-level sentiment scores plus a Telegram summary for each video.

What you need

A Google account, an OpenRouter API key, and a Telegram bot.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Generate AI videos and auto-publish them to YouTube

Turns a short text prompt into an AI-generated video and publishes it to YouTube with optimized title and tags.

Advanced

Generate AI videos and publish them to YouTube automatically

Turns a short prompt into an AI-generated video, then writes the title, description, and publishes it to YouTube.

Advanced

Log receipts to Google Sheets by photo through Telegram

Reads a photo of a receipt, pulls out the details, and logs the purchase to Google Sheets automatically.

Advanced

Send AI-generated polls to multiple Telegram groups automatically

Twice a day, AI writes an engaging poll and sends it to all your Telegram groups, then logs the results.

Advanced
Back to the AI Playbook