Library / Reports, Analytics & Dashboards
Reports, Analytics & Dashboards
Analyze YouTube Comment Sentiment with OpenAI and Sheets
When you run it, it fetches comments for YouTube videos listed in Google Sheets, has OpenAI score their sentiment and writes the results back.
What it does
# 🚀 YouTube Comment Sentiment Analyzer with Google Sheets & OpenAI
The steps
- Split Out
- OpenAI Chat Model
- No Operation, do nothing
- Get Video Urls from Google Sheet
- check next fetch time is available or not
- check next fetch time is before the current time
- Get Comments for video urls
- Analyze sentiment of every comment
- Format fields as required to save in google sheet
- Insert and update comment in google sheet
- Update last fetched time and next_fetch_time
- No Operation, do nothing1
- When clicking ‘Test workflow’
- Check Success Response
Similar automations
Reports, Analytics & DashboardsAnalyze YouTube Comment Sentiment with OpenAI28 stepsReports, Analytics & DashboardsAnalyze YouTube Comment Sentiment with Gemini and QuickChart14 stepsReports, Analytics & DashboardsAnalyze YouTube Comments with OpenAI and Report by Gmail12 stepsContent Writing & GenerationAnalyze YouTube Audience Comments with Gemini and OpenAI13 steps