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

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

  • No review gets forgotten
  • A timely reminder to the employee at AWS SES
  • 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 AWS SES 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 AWS SES + Google Calendar integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios