Send one-time email alerts for urgent tasks with Google Sheets and Gmail

Description

This workflow sends a personalized email when a task in a Google Sheet is marked as Urgent, but only once per task.

It prevents duplicate notifications by updating the sheet after the email is sent. Ideal for collaborative task tracking where multiple people edit the same spreadsheet.

Context

When working with shared task lists in Google Sheets, it’s easy to miss critical updates — or worse, trigger multiple alerts for the same task.

This workflow ensures that each "Urgent" task only sends one email notification, and then marks it as “Notified” to avoid duplicates.

Target Users - Project Managers using Google Sheets - Operations or support teams managing collaborative task boards - Anyone who needs alert automation with built-in anti-spam logic

Technical Requirements