Deadline reminders and an evening recap — in your chat

The scenario reads the tasks from your sheet, reminds the chat about approaching and overdue deadlines, marks what it sent and posts an evening recap of what got done.

  • Reminders go out by themselves — no nagging required
  • The same reminder doesn't repeat endlessly
  • In the evening, a recap of what the team closed
  • The task list is edited in an ordinary sheet
Google Sheets
Set it upScriptera

How it works

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

  1. Starts when: Start: Cron Trigger
  2. Then: Fetch Tasks from Google Sheets
  3. Check: Check Task Deadlines
  4. If yes: Send a Slack Reminder
  5. If no: Update Last Reminder Sent
  6. Starts when: Daily Recap Trigger
  7. Then: Fetch Completed Tasks
  8. Then: Send a Slack Reminder1

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

Similar scenarios