Equipment service dates — checked every morning, with alerts

Every morning the scenario reads the equipment sheet, finds devices coming due or overdue, alerts the technicians and supervisors and keeps a log.

  • The check runs daily, not from memory
  • Critical devices are separated — supervisors are warned about those
  • Overdue items get their status flipped right in the sheet
  • Alerts go out both by email and by message
Set it upScriptera

How it works

To get Microsoft Excel 365 notifications in smscRu, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Daily Equipment Check (6 AM)
  2. Then: Read Equipment Data
  3. Then: Process Equipment Alerts
  4. Then: Tack Break For 5 Sec
  5. Check: Filter Equipment with Alerts
  6. Then: Send Technician Email
  7. Check: Filter Critical Equipment
  8. Then: Send Critical Alert to Supervisors
  9. Then: Send Critical Alert Massage
  10. Then: Log Maintenance Alerts
  11. Check: Filter Overdue Equipment
  12. Then: Update Equipment Status
  13. Then: Send message

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

Similar scenarios