Performance reviews on schedule — reminders, meetings and statuses on their own

The scenario checks the review schedule in таблица daily, sends reminders to Gmail, sets meetings in Home Assistant, and notifies HR in WhatsApp Business Cloud.

  • No review gets forgotten
  • A timely reminder to the employee at Gmail
  • The meeting is set in Home Assistant automatically
  • HR stays informed via WhatsApp Business Cloud, statuses in таблица
Google Sheets

How it works

To get Gmail notifications in Home Assistant, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Daily Check at 8 AM
  2. Then: Get Review Schedule
  3. Then: Filter Upcoming Reviews
  4. Check: Reviews Scheduled?
  5. If yes: Split Into Items
  6. Then: Prepare Review Data
  7. Then: Send Email Reminder
  8. Then: Notify HR on Slack
  9. Then: Update Review Status
  10. Then: Update Calendar Event

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