Weekly discount newsletter that builds and sends itself

Once a week the scenario grabs the discounted items from your catalog, works out the promo dates, lays out the email and sends it to the list from your sheet.

  • The email is built from live discounts, not a stale template
  • Promo dates are calculated for you
  • Recipients come straight from your sheet
  • No separate paid email platform needed
Algolia
Set it upScriptera

How it works

To move data from Microsoft Excel 365 to Mautic automatically, use a ready-made scenario — no manual exports.

  1. Starts when: On sundays 8.00 am
  2. Then: Request products from Algolia
  3. Then: Extract Discounted Products
  4. Then: Keep only useful product data
  5. Then: Put back all hits in one clean array
  6. Check: Merge data for newsletter
  7. Then: Aggregate data for Newsletter
  8. Then: Newsletter Generation (HTML Format)
  9. Then: Get row(s) in sheet
  10. Then: Send newsletter
  11. Then: What day are we ?
  12. Check: Sunday ?
  13. If yes: Output date of today
  14. Then: Clean Promo start date
  15. Then: Calculate end of range
  16. Then: Clean Promo end date
  17. Then: Output Promo Validity Date Range
  18. If no: Find last Monday's date
  19. Then: Find last Sunday's date
  20. Then: Date range generator (low code)
  21. Starts when: Test trigger for low-code branch

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

Similar scenarios