Automated AI Email Reports from Google Sheets

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "n0",
    "timestamp": 1780344246587
  },
  {
    "data": {
      "kind": "n8n-nodes-base.scheduleTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780344246587
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "n0",
    "timestamp": 1780344246587
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "n1",
    "timestamp": 1780344246587
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780344246587
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780344246587
  },
  {
    "data": {
      "status": 200
    },
    "event": "sheets.read",
    "nodeId": "integration",
    "timestamp": 1780344246914
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 327,
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780344246914
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "n1",
    "timestamp": 1780344246914
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "n2",
    "timestamp": 1780344246914
  },
  {
    "data": {
      "messages": 2,
      "maxTokens": 200
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780344246914
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780344246914
  },
  {
    "data": {
      "model": "gpt-4o-mini-2024-07-18",
      "costUsd": 0.0007775,
      "provider": "openai",
      "latencyMs": 1942,
      "promptTokens": 43,
      "completionTokens": 67
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780344248856
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "n2",
    "timestamp": 1780344248856
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "n3",
    "timestamp": 1780344248856
  },
  {
    "data": {
      "service": "gmail",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780344248856
  },
  {
    "data": {
      "url": "https://gmail.googleapis.com/gmail/v1/users/me/messages/send",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780344248856
  },
  {
    "data": {
      "status": 200
    },
    "event": "gmail.send",
    "nodeId": "integration",
    "timestamp": 1780344249266
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "gmail",
      "latencyMs": 410,
      "operation": "send"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780344249266
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "n3",
    "timestamp": 1780344249266
  }
]