A daily topic newsletter — on autopilot

Each morning the scenario gathers fresh news, AI selects by your topic, and the ready digest goes out to subscribers via smscRu.

  • The digest goes out every morning
  • News selected by your topic
  • An article archive in таблица
  • Sent to subscribers from smscRu
Google Sheets

How it works

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

  1. Starts when: Trigger at 08:30 am
  2. Then: Query EU News Website
  3. Then: Extract Articles Blocks
  4. Then: Split Out by Article Block
  5. Then: Parse Article Blocks
  6. Check: If
  7. If yes: Loop Over Articles
  8. Then: Agent Classification
  9. Then: Sustainability Flag
  10. Check: Merge Article + Flag
  11. Then: Record Results
  12. Then: Get Sustainability News
  13. Then: Generate Email HTML
  14. Then: Send to your mailing list
  15. Then: OpenAI Chat Model3
  16. Then: Structured Output Parser

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