{
  "name": "Send one-time email alerts for urgent tasks with Google Sheets and Gmail",
  "nodes": [
    {
      "id": "3df564ee-8eb5-42f6-876f-331fe9dc7994",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        -608
      ],
      "parameters": {
        "width": 304,
        "height": 176,
        "content": "## Required\n\n• Google sheets credential\n• Gmail credential"
      }
    },
    {
      "id": "39c453ac-1335-4dac-a61b-e8f9753b3f80",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        176,
        -608
      ],
      "parameters": {
        "width": 560,
        "height": 800,
        "content": "## 1) Trigger, Filter & Row Info\n\nTrigger:\n- Google Sheets Trigger (on change in \"Priority\" column)\n\nFiltering:\n- IF node filters on:\n- Priority = \"Urgent\"\n- Notified is empty\n- row_number exists\n\nBes"
      }
    },
    {
      "id": "5959b1f3-b7d5-4e32-b5ae-031eb81a89d3",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        752,
        -608
      ],
      "parameters": {
        "width": 208,
        "height": 800,
        "content": "## 2) Send Email\n\nEmail Node:\n- Personalized message with:\n- Task name\n- Owner\n- Deadline\n- Status\n- Action required\n\n\nBest Practice:\n- Use line breaks (\\n) for formatting in email body.\n- Personalize"
      }
    },
    {
      "id": "39c9bcce-68db-4c16-ba91-532f0d453a11",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        -608
      ],
      "parameters": {
        "width": 304,
        "height": 800,
        "content": "## 3) Update Google Sheet\n\nUpdate Row Node:\n\n- Use: row_number = {{ $json.row_number }}\n- Set \"Notified\" to \"Yes\" or timestamp\n\nBest Practice:\n- Update a value to track that the email was sent\n- Avoid"
      }
    },
    {
      "id": "66e98b88-3ec6-4209-a857-3abf6f457631",
      "name": "Trigger when Urgent status",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        208,
        0
      ]
    },
    {
      "id": "a4c3475f-63d3-49a0-b37f-34ba65c46c46",
      "name": "Get the row number",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        416,
        0
      ]
    },
    {
      "id": "aef49d06-bd28-4073-a69c-a4ab005919e6",
      "name": "Condition to send the email",
      "type": "n8n-nodes-base.if",
      "position": [
        624,
        0
      ]
    },
    {
      "id": "23712547-0846-477d-b318-c6ef38f3decf",
      "name": "Email alert",
      "type": "n8n-nodes-base.gmail",
      "position": [
        832,
        -144
      ]
    },
    {
      "id": "c950b5b0-50e5-426d-8b3e-c84eb53d46a6",
      "name": "Update row avoiding spam",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1040,
        -144
      ]
    }
  ],
  "connections": {
    "Email alert": {
      "main": [
        [
          {
            "node": "Update row avoiding spam",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get the row number": {
      "main": [
        [
          {
            "node": "Condition to send the email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Trigger when Urgent status": {
      "main": [
        [
          {
            "node": "Get the row number",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Condition to send the email": {
      "main": [
        [
          {
            "node": "Email alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}