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

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "66e98b88-3ec6-4209-a857-3abf6f457631",
    "timestamp": 1780868080099
  },
  {
    "data": {
      "kind": "n8n-nodes-base.googleSheetsTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780868080099
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "66e98b88-3ec6-4209-a857-3abf6f457631",
    "timestamp": 1780868080099
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "a4c3475f-63d3-49a0-b37f-34ba65c46c46",
    "timestamp": 1780868080101
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780868080101
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780868080101
  },
  {
    "data": {
      "status": 200
    },
    "event": "sheets.read",
    "nodeId": "integration",
    "timestamp": 1780868080728
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 627,
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780868080728
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "a4c3475f-63d3-49a0-b37f-34ba65c46c46",
    "timestamp": 1780868080728
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "aef49d06-bd28-4073-a69c-a4ab005919e6",
    "timestamp": 1780868080736
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1780868080736
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "aef49d06-bd28-4073-a69c-a4ab005919e6",
    "timestamp": 1780868080736
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "23712547-0846-477d-b318-c6ef38f3decf",
    "timestamp": 1780868080738
  },
  {
    "data": {
      "service": "gmail",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780868080738
  },
  {
    "data": {
      "url": "https://gmail.googleapis.com/gmail/v1/users/me/messages?maxResults=5&q=in%3Ainbox",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780868080738
  },
  {
    "data": {
      "status": 200
    },
    "event": "gmail.read",
    "nodeId": "integration",
    "timestamp": 1780868080932
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "gmail",
      "latencyMs": 194,
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780868080932
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "23712547-0846-477d-b318-c6ef38f3decf",
    "timestamp": 1780868080932
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "c950b5b0-50e5-426d-8b3e-c84eb53d46a6",
    "timestamp": 1780868080937
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780868080937
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/Sink:append?valueInputOption=RAW",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780868080937
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780868081077
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 140,
      "operation": "update"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780868081077
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "c950b5b0-50e5-426d-8b3e-c84eb53d46a6",
    "timestamp": 1780868081077
  }
]