Summaries of new videos from the channels you follow — to your messenger

The scenario watches your chosen channels and, as soon as a new video drops, sends a short summary from its subtitles to your messenger.

  • New videos tracked on their own
  • A short summary instead of an hour of watching
  • The recap lands in your messenger
  • Add channels just by typing
Google SheetsYouTube
Set it upScriptera

How it works

To connect Telegram and Google Sheets, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: Schedule Trigger
  2. Then: Get RSS Links
  3. Check: Batch RSS Items
  4. Then: Fetch RSS Feed
  5. Then: Parse RSS XML
  6. Then: If newly published
  7. Check: Check for new videos
  8. If yes: Filter for New Video
  9. Check: Check if the Video Exists
  10. If yes: Log New Videos
  11. Then: Fetch Video Details
  12. Then: Fetch Subtitles URL
  13. Then: Format Response
  14. Then: Get Subtitles
  15. Then: Get Timestamps
  16. Check: Check for Timestamps
  17. If yes: Formatted Chapter Text
  18. Then: Build AI Payload
  19. Then: Generate Summary
  20. Then: Generate Slack Blocks - Detailed Summary
  21. Then: Post to Slack
  22. If no: Formatted Transcript w/o Chapters
  23. If no: Link is Processed
  24. Starts when: Slack Trigger
  25. Then: Get Channel ID
  26. Then: RSS Feed URL
  27. Then: AI Agent
  28. Then: Get Rows
  29. Then: Delete Row
  30. Then: Append Row
  31. Then: OpenAI Chat Model

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

Similar scenarios