Back to Templates

Analyze YouTube comments with OpenAI and send reports via email and chat

Created by

Created by: SpaGreen Creative || spagreen
SpaGreen Creative

Last update

Last update 20 hours ago

Categories

Share

Who it's for

This advanced n8n workflow is designed for YouTube content creators, social media managers, digital marketers, and agency owners who need a deep, automated understanding of their video performance. It acts as a virtual audience research analyst, automatically fetching video details, scraping all comments (handling pagination), and analyzing them with AI to extract sentiment, trends, and content ideas.

Features

  • Complete Comment Scraping: Fetches all YouTube comments using automatic API pagination.
  • Telegram Control: Start analysis directly from Telegram with Admin/User access checks and owner alerts.
  • Smart ID Extraction: Detects and extracts Video ID from different message formats automatically.
  • AI-Powered Analysis: Uses LangChain + OpenAI to generate insights on sentiment, audience, engagement, and content opportunities.
  • Multi-Format Reporting: Sends reports in HTML/Markdown through Gmail, Telegram, and WhatsApp simultaneously.
  • Cloud Archiving: Saves reports automatically to Google Drive with the video title as the document name.
  • Actionable Insights: Identifies viewer pain points, keyword ideas, and optimization opportunities for future videos.

Requirements

  • YouTube Data API v3: A valid Google API Key with access to the commentThreads and video resources is required for fetching data.
  • OpenAI API: Required for the LangChain Agent (using models like gpt-4.1-mini) to analyze the data and generate the comprehensive report.
  • Telegram API: For triggering the workflow and receiving the final report.
  • Gmail & Google Drive: Google OAuth2 credentials are needed to send the report email and save the file to your drive.
  • Rapiwa (WhatsApp): API credentials to send the report via WhatsApp messages.

Important Notes

  • API Key Configuration: Replace "add_your_google_API_key" in Edit Fields (Set API key) with your valid YouTube Data API key.
  • Telegram Setup: Add your Admin ID and Chat ID in the Telegram message nodes for correct notifications.
  • Video Input: Send a Telegram message containing VIDEO_ID, video id, or videoid to trigger the workflow.
  • Cost Management: Large videos with many comments can use high OpenAI token limits since all comments are analyzed.
  • Permissions: Make sure YouTube Data API v3 is enabled in your Google Cloud Project.

Support & Help