A read on your video comments — mood and topics

The scenario collects the comments on your videos, works out the mood and the main topics, files the read into a sheet and sends a summary to your messenger.

  • Audience mood, measured — not guessed
  • The main topics and viewer requests
  • A read for every video in the sheet
  • A short summary lands in chat
Google Sheets
Set it upScriptera

How it works

To move data from Microsoft Teams to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Schedule Trigger
  2. Then: Get row(s) in sheet
  3. Then: Youtube API Key
  4. Check: Loop Over Items
  5. Then: HTTP Request
  6. Then: Code
  7. Then: Basic LLM Chain
  8. Then: Code1
  9. Then: Append or update row in sheet
  10. Then: Aggregate
  11. Then: Code2
  12. Then: Send a text message
  13. Then: Structured Output Parser
  14. Then: OpenRouter Chat Model

You can launch this Microsoft Teams + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios