Daily riddle shorts on YouTube — automatically

Every day the scenario comes up with a fresh, non-repeating riddle, builds it into a vertical clip and posts it to YouTube itself — with an email notification.

  • A new clip every day
  • Riddles with no repeats
  • No filming or editing needed
  • The link arrives by email
Embeddings OpenAIDefault Data LoaderPinecone Vector Store
Connect Pinecone and goScriptera

How it works

To get Pinecone notifications in Microsoft Excel 365, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Schedule Trigger
  2. Then: Riddle generation AI Agent
  3. Then: Fetch Audio From Sheet (Ensuring Rotation)
  4. Check: Merge
  5. Then: Render Youtube Short
  6. Then: Wait
  7. Then: Youtube Upload HTTP request Setup
  8. Then: Get Binary for Rendered Short
  9. Then: Upload Binary to Youtube HTTP
  10. Then: Send Notification with YouTube link
  11. Then: Update Audio Used Status
  12. Then: Update Next Shorts title
  13. Then: Check if all audio tracks have been used
  14. Check: If
  15. If no: get all track rows
  16. Then: update all track rows back to unused
  17. Then: Convert Riddles JSON to 1 Text item for Vector Insertion
  18. Then: Insert Riddles to Vector Store
  19. Then: Fetch Current Shorts Title (Numbered)
  20. Then: Calculate Next Shorts Title Number (To update at the end)
  21. Then: Anthropic Chat Model
  22. Then: Embeddings OpenAI
  23. Then: Default Data Loader
  24. Then: Recursive Character Text Splitter
  25. Then: Embeddings OpenAI1
  26. Then: Structured Output Parser
  27. Then: Vector Store to Find Previous Riddles

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

Similar scenarios