A daily digest to subscribers by their topics — hands-off

The scenario takes subscribers and their topics from a sheet, gathers fresh material, summarizes it and emails each one a personal digest every day.

  • Takes subscribers and topics from Microsoft SharePoint
  • Gathers fresh material and summarizes it
  • Never repeats what it already sent
  • Emails each one a personal digest via Gmail
Set it up for yourselfScriptera

How it works

To move data from Microsoft SharePoint to Gmail automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Schedule Trigger
  2. Then: Get Subscribers
  3. Then: Parse Rows
  4. Then: Get Unique Categories
  5. Then: Categories to Items
  6. Then: Fetch Latest 10 per Category
  7. Then: Append Category
  8. Check: For Each Category
  9. Then: Flatten Workflows
  10. Check: Merge
  11. Check: For Each Subscriber
  12. Check: Has New Workflows?
  13. If yes: Generate HTML Template
  14. Then: Send Daily Digest
  15. Then: Get Relevant Workflows
  16. Then: Workflow to Items
  17. Then: Remove Already Seen
  18. Then: Combine Workflows
  19. Then: With User Reference
  20. Then: Workflows to Items
  21. Then: Workflow Summarizer
  22. Then: Collect Fields
  23. Then: Aggregate
  24. Then: OpenAI Chat Model

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

Similar scenarios