Analyze YouTube comments sentiment & keywords with Gemini AI and Telegram reporting

by Budi SJ ✓ · 585 views · created 2025-08-15 · Market Research, Multimodal AI

What this workflow does

This AI workflow has 15 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, OpenRouter Chat Model and Telegram.

How it runs

Trigger: On a schedule (every day).

1. Get row(s) in sheet (Google Sheets): uses Google Sheets
2. Youtube API Key (Edit Fields (Set)): sets 1 field: Youtube API Key
3. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
4. HTTP Request: calls an HTTP API
5. Code: runs custom JavaScript code
6. Basic LLM Chain: sends a prompt to an LLM, with model: OpenRouter Chat Model; output parser: Structured Output Parser
7. Code: runs custom JavaScript code
8. Append or update row in sheet (Google Sheets): append or update
9. Aggregate: combines items into one
10. Code: runs custom JavaScript code

…plus 1 more step. See the full node list below.

Services it uses

Google SheetsOpenRouter Chat ModelTelegram

Before you upgrade to n8n 3.0

Nodes used (12)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• HTTP Requestn8n-nodes-base.httpRequest
• Edit Fields (Set)n8n-nodes-base.set
• Coden8n-nodes-base.code
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• OpenRouter Chat Model@n8n/n8n-nodes-langchain.lmChatOpenRouter
• Aggregaten8n-nodes-base.aggregate
• Telegramn8n-nodes-base.telegram
• No Operation, do nothingn8n-nodes-base.noOp

From the author

YouTube Comment Sentiment & Keyword Extractor Template Google Sheets: Click here to open This workflow automatically retrieves comments from YouTube videos listed in Google Sheets, analyzes sentiment and keywords using an LLM, stores the results, then…

View the original on n8n.io → Check your own copy