Fresh news on a topic with a breakdown — to a table and messenger

On schedule the scenario gathers fresh articles, summarizes and categorizes them, saves them to a table and sends a digest to your messenger.

  • Fresh articles on the topic — automatically
  • A short summary and a category
  • An archive builds up in the table
  • A digest arrives in your messenger

How it works

Automating Microsoft SQL and pachca takes no code: a ready-made scenario does the routine for you.

  1. Starts when: Schedule Trigger1
  2. Then: TechCrunchNews-AI1
  3. Then: GetDate1
  4. Then: Split URL3
  5. Then: Edit Fields6
  6. Check: SelectDate
  7. If yes: Loop Over Items1
  8. Then: SetData
  9. Then: NewsData
  10. Then: Send a text message
  11. Then: TimeWaitRandom1
  12. Then: Wait1
  13. Then: URL_Content
  14. Then: GetBody
  15. Then: AI Agent1
  16. Then: Structured Output Parser1
  17. Then: Gpt-4.1-nano

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