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

Google Sheets account with edit access

Gmail account for sending notifications

Google Sheet with columns:

Priority

Notified

Task

Owner

Deadline

Status

Next Step

Workflow Steps

Trigger: Watches for changes in Google Sheets (e.g., edits to the "Priority" column)

IF Node – Checks that:

Priority = Urgent

Notified is empty

row exists (required for update)

Send Email: Sends a personalized message with task details

Update Row: Writes “Yes” in the Notified column to avoid duplicate alerts

Setup Instructions

To set up this workflow:

Connect your Google Sheets and Gmail credentials in n8n.

Copy the spreadsheet structure or use your own

Import the workflow, select your Sheet (and the column to check if you use a different Google Sheets template), and test by marking a task as “Urgent”.

Check that an email is sent and the “Notified” column updates to “Yes”.-

Key Features

✅ One email per urgent task — prevents duplicates 📧 Dynamic email content with task info 🧠 Built-in anti-spam logic 📋 Simple to configure and reuse 💬 Customizable for any team’s needs

Expected Output

An email alert is sent only once per task marked as Urgent

The Notified field is updated in the Google Sheet

A clean and scalable alert system with no duplicates

Tutorial video: Watch the Youtube Tutorial video

About me : I’m Yassin a Project & Product Manager Scaling tech products with data-driven project management. 📬 Feel free to connect with me on Linkedin