Extract Invoice and Payment Spend to Sheets

209f3e67-b65a-4794-bdff-b2bbb5ce92e7

Latency
53734ms
Cost
$0.0008
Tokens
516
Status
partial
gemini-2.5-flash

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "8e1e0861-9f06-4fe2-a9c1-423bab246959",
    "timestamp": 1782939626717
  },
  {
    "data": {
      "kind": "n8n-nodes-base.gmailTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1782939626717
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "8e1e0861-9f06-4fe2-a9c1-423bab246959",
    "timestamp": 1782939626717
  },
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "364fe355-672a-4074-800a-a7496c4fb1b2",
    "timestamp": 1782939626719
  },
  {
    "data": {
      "kind": "n8n-nodes-base.gmailTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1782939626719
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "364fe355-672a-4074-800a-a7496c4fb1b2",
    "timestamp": 1782939626719
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "0d75443d-0d23-4120-95e5-b3128a760fb4",
    "timestamp": 1782939626720
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1782939626720
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "0d75443d-0d23-4120-95e5-b3128a760fb4",
    "timestamp": 1782939626720
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "7ade499c-015b-4903-8129-6c135264bf75",
    "timestamp": 1782939626721
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling google/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1782939626721
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "google"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1782939626721
  },
  {
    "data": {
      "error": "Google Gemini API error (500): {\n  \"error\": {\n    \"code\": 500,\n    \"message\": \"An internal error has occurred. Please retry or report in https://developers.generativeai.google/guide/troubleshooting\",\n    \"status\": \"INTERNAL\"\n  }\n}\n",
      "status": "error",
      "degraded": true,
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "7ade499c-015b-4903-8129-6c135264bf75",
    "timestamp": 1782939652160
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "250bbd9a-3d22-4a04-910c-7cec437b3c33",
    "timestamp": 1782939652162
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/llama-3.2-11b-text-preview",
    "nodeId": "llm",
    "timestamp": 1782939652162
  },
  {
    "data": {
      "model": "llama-3.2-11b-text-preview",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1782939652162
  },
  {
    "data": {
      "error": "Google Gemini API error (500): {\n  \"error\": {\n    \"code\": 500,\n    \"message\": \"An internal error has occurred. Please retry or report in https://developers.generativeai.google/guide/troubleshooting\",\n    \"status\": \"INTERNAL\"\n  }\n}\n",
      "status": "error",
      "degraded": true,
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "250bbd9a-3d22-4a04-910c-7cec437b3c33",
    "timestamp": 1782939677442
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "b8d2b2fc-748c-43c5-a82b-d5e7357bbef8",
    "timestamp": 1782939677446
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1782939677446
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "b8d2b2fc-748c-43c5-a82b-d5e7357bbef8",
    "timestamp": 1782939677446
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "e3218faf-2486-46e0-bf43-3bc52927e2bd",
    "timestamp": 1782939677449
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1782939677449
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "e3218faf-2486-46e0-bf43-3bc52927e2bd",
    "timestamp": 1782939677449
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "3772b3dc-7601-4005-9b61-263b2c1abd5f",
    "timestamp": 1782939677451
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1782939677451
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "3772b3dc-7601-4005-9b61-263b2c1abd5f",
    "timestamp": 1782939677451
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "0d9f8bde-af54-480c-bdc9-15cd5b0e6f28",
    "timestamp": 1782939677452
  },
  {
    "data": {
      "inputKeys": [
        "date",
        "from",
        "html",
        "text",
        "spend",
        "output",
        "subject",
        "labelIds",
        "email_date",
        "email_type",
        "email_content",
        "email_subject"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1782939677452
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "0d9f8bde-af54-480c-bdc9-15cd5b0e6f28",
    "timestamp": 1782939677452
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "c1c4c490-d7a9-4b16-a81b-a338103764b6",
    "timestamp": 1782939677453
  },
  {
    "data": {
      "inputKeys": [
        "date",
        "from",
        "html",
        "text",
        "spend",
        "output",
        "subject",
        "labelIds",
        "email_date",
        "email_type",
        "email_content",
        "email_subject"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1782939677453
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "c1c4c490-d7a9-4b16-a81b-a338103764b6",
    "timestamp": 1782939677453
  },
  {
    "data": {
      "nodeType": "switch"
    },
    "event": "node_start",
    "nodeId": "01c5a934-9412-4ef9-81a8-c4aef19c8868",
    "timestamp": 1782939677455
  },
  {
    "event": "no rule matched -> default",
    "nodeId": "switch",
    "timestamp": 1782939677455
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "switch"
    },
    "event": "node_end",
    "nodeId": "01c5a934-9412-4ef9-81a8-c4aef19c8868",
    "timestamp": 1782939677455
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "10d57038-940e-47aa-84ea-3850f61ac757",
    "timestamp": 1782939677458
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1782939677458
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "10d57038-940e-47aa-84ea-3850f61ac757",
    "timestamp": 1782939677458
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "c2829f41-1e3f-40bc-8d4b-9fd1bac41381",
    "timestamp": 1782939677459
  },
  {
    "data": {
      "inputKeys": [
        "date",
        "from",
        "html",
        "text",
        "spend",
        "output",
        "subject",
        "labelIds",
        "email_date",
        "email_type",
        "email_content",
        "email_subject"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1782939677459
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "c2829f41-1e3f-40bc-8d4b-9fd1bac41381",
    "timestamp": 1782939677459
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "ecf9ea3c-3f34-43ef-b101-ca4a420e4c24",
    "timestamp": 1782939677461
  },
  {
    "data": {
      "inputKeys": [
        "date",
        "from",
        "html",
        "text",
        "spend",
        "output",
        "subject",
        "labelIds",
        "email_date",
        "email_type",
        "email_content",
        "email_subject"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1782939677461
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "ecf9ea3c-3f34-43ef-b101-ca4a420e4c24",
    "timestamp": 1782939677461
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "dae6d22e-587d-4102-b006-20a341ede5ee",
    "timestamp": 1782939677462
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1782939677462
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "dae6d22e-587d-4102-b006-20a341ede5ee",
    "timestamp": 1782939677462
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "112f5198-871e-42f9-9376-5fa074497413",
    "timestamp": 1782939677464
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1782939677464
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1782939677464
  },
  {
    "data": {
      "model": "gemini-2.5-flash",
      "costUsd": 0.0003576,
      "provider": "openai",
      "latencyMs": 733,
      "promptTokens": 117,
      "completionTokens": 129
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1782939678200
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "112f5198-871e-42f9-9376-5fa074497413",
    "timestamp": 1782939678200
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "87ab4932-aae5-4c5a-a175-c782bebdf781",
    "timestamp": 1782939678209
  },
  {
    "data": {
      "inputKeys": [
        "0"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1782939678209
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "87ab4932-aae5-4c5a-a175-c782bebdf781",
    "timestamp": 1782939678209
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "39b10715-54fe-4c07-9ca1-afbe43ae519e",
    "timestamp": 1782939678211
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939678713
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "39b10715-54fe-4c07-9ca1-afbe43ae519e",
    "timestamp": 1782939678713
  },
  {
    "data": {
      "nodeType": "merge"
    },
    "event": "node_start",
    "nodeId": "b9c3cb29-e68e-4ae0-8930-185c17bc6cab",
    "timestamp": 1782939678718
  },
  {
    "data": {
      "inputCount": 2
    },
    "event": "merged 2 inputs",
    "nodeId": "merge",
    "timestamp": 1782939678718
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "merge"
    },
    "event": "node_end",
    "nodeId": "b9c3cb29-e68e-4ae0-8930-185c17bc6cab",
    "timestamp": 1782939678718
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "b50d632c-b762-4f61-b34a-91f941100668",
    "timestamp": 1782939678721
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1782939678721
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1782939678721
  },
  {
    "data": {
      "model": "gemini-2.5-flash",
      "costUsd": 0.0004066,
      "provider": "openai",
      "latencyMs": 1220,
      "promptTokens": 122,
      "completionTokens": 148
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1782939679943
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "b50d632c-b762-4f61-b34a-91f941100668",
    "timestamp": 1782939679944
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "10fe4a38-139b-4284-9e86-dd36e472f59e",
    "timestamp": 1782939679951
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939680451
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "10fe4a38-139b-4284-9e86-dd36e472f59e",
    "timestamp": 1782939680451
  }
]