An email for an urgent task — exactly once

When a task in таблица is marked urgent, the scenario emails via Gmail and marks the row so no duplicates are sent.

  • A notification exactly when the task is urgent
  • One email per task, no repeats
  • No spam from repeated alerts
  • The sent status recorded in таблица
Google Sheets