Preventive-maintenance reminders — straight to the calendar

Every day the scenario checks the work plan in Google Sheets and for the due jobs sends a calendar invite to Microsoft Outlook — with the date and the task.

  • The work plan in Google Sheets
  • An event with date and task
  • A calendar invite file
  • An email to the person in charge at Microsoft Outlook
Set it up for yourselfScriptera

How it works

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

  1. Starts when: Daily Trigger
  2. Then: Read Maintenance Tasks
  3. Then: Generate ICS Data
  4. Then: Create ICS File
  5. Then: Send Calendar Invite Email

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

Similar scenarios