This n8n workflow automates the process of collecting comments from YouTube videos, performing sentiment analysis, and sending insightful reports via email. It begins by monitoring a Google Sheet for new or pending video IDs, then retrieves video details and comments using the YouTube API. The comments are processed to extract key data such as text, likes, and replies, along with basic sentiment scoring. An AI model (GPT-4) analyzes the comments to identify overall sentiment, main themes, viewer questions, and suggestions. The insights are formatted into a professional HTML email report, which is sent through Gmail. Finally, the workflow updates the Google Sheet to mark completed videos, avoiding duplicate processing. This automation is ideal for content creators and marketers aiming to monitor viewer engagement and gather structured feedback efficiently.

Node Count	11 – 20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatOpenAi, code, gmail, googleSheets, googleSheetsTrigger, httpRequest, if, limit, set, stickyNote, youTube