Deadline reminders: a week, 3 days, and day-of

The scenario reads due dates from a sheet and emails reminders in advance and on the deadline day.

  • Due dates pulled straight from your sheet
  • Three nudges: a week, three days, day-of
  • Nothing slips out of sight
  • Works for the whole team at once
Set it up for yourselfScriptera

How it works

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

  1. Starts when: Schedule Trigger
  2. Then: Get row(s) in sheet
  3. Check: Loop Over Items
  4. Check: Check Due Today (IF)
  5. If no: 3日以内
  6. If yes: Send 3-Day Reminder (Gmail)
  7. If no: Check Within 7 Days (IF)
  8. If yes: Send 7-Day Reminder

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

Similar scenarios