Sentiment analysis of YouTube comments with Google Sheets integration

• Analyze audience sentiment on YouTube comments for marketing insights.
• Track viewer engagement and feedback on video content.
• Automate the collection and analysis of comments for reporting purposes.

Retrieve video URLs from a Google Sheet. Check the last fetch time to determine if new comments should be fetched. Fetch comments from YouTube for each video URL. Analyze the sentiment of each comment using OpenAI's language model. Format the results and append them to a Google Sheet.

1. 1
   Import the workflow template into your n8n instance.
2. 2
   Set up Google Sheets and OpenAI credentials.
3. 3
   Create a Google Sheet with two sheets: one for video URLs and another for sentiment analysis results.
4. 4
   Run the workflow to start analyzing comments.