What it does
An n8n workflow that watches a Google Sheet for YouTube video IDs marked as Pending. For each video, it fetches up to 100 top comments through the YouTube API and asks GPT-4 to analyze sentiment, themes, questions and feedback. It then emails an HTML report and updates the sheet status so a video is not processed twice.
Use cases
- 01Summarize sentiment across a video's top comments
- 02Find recurring questions and feedback from viewers
- 03Receive an emailed report for each new video
Connects
Google Sheets · HTTP Request · Gmail · YouTube · Code · AI Agent · OpenAI Chat Model