A daily topic news summary from many sources

How it works

To connect Microsoft SQL and Zulip, you don't need a developer: a ready-made scenario links them in minutes.

1. Starts when: Run daily at 6 AM
2. Then: ⚙️ Configure digest settings
3. Then: Initialize run timestamp
4. Then: Create run record
5. Then: Build feed source list
6. Then: Fetch feed content
7. Then: Parse articles from feeds
8. Check: Any articles found?
9. If yes: Deduplicate by URL and title
10. Then: Check database for recent duplicates
11. Then: Remove already-seen articles
12. Then: Select top articles for extraction
13. Then: Extract full text via Jina
14. Then: Assemble extracted content
15. Then: Prepare analysis prompts
16. Then: Analyze article with Claude
17. Then: Score and rank articles
18. Then: Select articles for digest
19. Then: Compile digest with Claude
20. Then: Format multi-channel outputs
21. Then: Send digest to Discord
22. Then: Send digest to Slack
23. Then: Build article save query
24. Then: Save articles to database
25. Then: Mark run as completed
26. If no: Mark run as empty
27. Then: Claude Sonnet (compiler)
28. Then: Claude Haiku (analyzer)

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