YouTube Comment Sentiment & Keyword Extractor
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 generates an aggregate summary and sends a report to Telegram. ✨ Key Features Automated Scheduling** – Runs the process at regular intervals. Google Sheets Integration** – Fetches a list of videos and stores analysis results directly in Google Sheets. YouTube Comment Retrieval** – Retrieves top-level comments (up to 100 per video; can be extended with pagination). Comment Parsing** – Flattens the API response into one item per comment. AI Sentiment & Keyword Analysis** – Powered by an LLM model to extract: Sentiment (positive, neutral, negative) Sentiment score (-1 to 1) Keywords (cleaned from stopwords, emojis, hashtags) Language (ISO 639-1, 2-letter code) Data Normalization** – Ensures LLM output is consistent and safe to write to the sheet. Telegram Reporting** – Sends a concise report for each video directly to a Telegram chat. 🔐 Required Credentials Google Sheets OAuth2 API** – Read & write access to the spreadsheet. YouTube Data API Key** – To fetch comments via commentThreads. OpenRouter API Key** – To access the LLM model. Telegram Bot API** – To send reports via a Telegram bot. 🎁 Benefits End-to-End Automation** – From comment retrieval to reporting, no manual steps required. No Duplication** – Each comment is uniquely tracked by comment_id. Data Transparency** – Raw and analyzed data stored neatly in Google Sheets. Actionable Insights** – Sentiment and keyword summaries ready for content strategy decisions. Scalable** – Can be extended for pagination, reply comment analysis, or additional metrics. Cross-Platform** – Direct Telegram integration for easy monitoring on any device. An n8n automation workflow template by Budi SJ.
Budi SJ
web
free
Others in the same category, ranked by how often they are opened.
