This n8n workflow automates the process of analyzing the sentiment of YouTube comments and storing the results in Google Sheets. The workflow fetches video URLs from a Google Sheet, checks if new comments need to be retrieved based on timing, and then uses YouTube API to get comments for each video. It leverages OpenAI’s GPT-4 model to analyze the sentiment of each comment, categorizing them into Positive, Neutral, or Negative. The comments along with their sentiment analysis and metadata are then appended or updated in a Google Sheet. Additionally, the workflow updates the timestamps for last fetch and next scheduled fetch, enabling periodic sentiment monitoring of YouTube comments. This workflow is practical for content creators, social media managers, and businesses seeking to gauge audience sentiment in comments over time.
YouTube Comment Sentiment Analysis Workflow
Node Count | 11 – 20 Nodes |
---|---|
Nodes Used | @n8n/n8n-nodes-langchain.lmChatOpenAi, @n8n/n8n-nodes-langchain.sentimentAnalysis, googleSheets, httpRequest, if, manualTrigger, noOp, set, splitOut, stickyNote |
Reviews
There are no reviews yet.