This n8n workflow automates the process of fetching YouTube video comments, analyzing their sentiment, and recording the results in a Google Sheet. It is designed to help content creators, social media managers, and marketing teams gain insights into audience feedback beyond simple engagement metrics.
The workflow begins with a manual trigger or scheduled execution, retrieving URLs of YouTube videos marked as ‘Ready’ from a Google Sheet. It then sends requests to the YouTube API to fetch comments associated with each video. If comments are available, they are processed and passed to an AI language model, such as Google Gemini, for sentiment analysis, categorizing comments as Positive, Neutral, or Negative.
The analyzed comments, along with their metadata (author, likes, replies, timestamp), are stored in the data sheet. If no comments are found, the workflow simply updates the video’s status as ‘Finished’ in the sheet, marking it processed. This automation is especially useful for monitoring audience sentiment, performing feedback analysis, or managing large volumes of YouTube comments efficiently.
The system’s flexible design allows for easy customization, including changing AI models, modifying sentiment categories, or integrating additional notification channels. It streamlines comment analysis, supports reputation management, and helps optimize content strategy based on audience feedback.
Reviews
There are no reviews yet.