Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Split Out
  2. OpenAI Chat Model
  3. No Operation, do nothing
  4. Get Video Urls from Google Sheet
  5. check next fetch time is available or not
  6. check next fetch time is before the current time
  7. Get Comments for video urls
  8. Analyze sentiment of every comment
  9. Format fields as required to save in google sheet
  10. Insert and update comment in google sheet
  11. Update last fetched time and next_fetch_time
  12. No Operation, do nothing1
  13. When clicking ‘Test workflow’
  14. Check Success Response

Similar automations