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

The scenario checks the review schedule in таблица daily, sends reminders to Microsoft Outlook, sets meetings in Google Calendar, and notifies HR in Google Chat.

  • No review gets forgotten
  • A timely reminder to the employee at Microsoft Outlook
  • The meeting is set in Google Calendar automatically
  • HR stays informed via Google Chat, statuses in таблица
Google Sheets
Set it up for yourselfScriptera

How it works

To get Microsoft Outlook notifications in Google Calendar, 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 Microsoft Outlook + Google Calendar integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios