Extract Invoice and Payment Spend to Sheets

ae6b7317-f2e2-49c9-a8bc-399bf4831420

Latency
10029ms
Cost
$0.0001
Tokens
542
Status
partial
gemini-2.5-flash-lite

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "8e1e0861-9f06-4fe2-a9c1-423bab246959",
    "timestamp": 1780866340452
  },
  {
    "data": {
      "kind": "n8n-nodes-base.gmailTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780866340452
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "8e1e0861-9f06-4fe2-a9c1-423bab246959",
    "timestamp": 1780866340452
  },
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "364fe355-672a-4074-800a-a7496c4fb1b2",
    "timestamp": 1780866340454
  },
  {
    "data": {
      "kind": "n8n-nodes-base.gmailTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780866340454
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "364fe355-672a-4074-800a-a7496c4fb1b2",
    "timestamp": 1780866340454
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "0d75443d-0d23-4120-95e5-b3128a760fb4",
    "timestamp": 1780866340456
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866340456
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "0d75443d-0d23-4120-95e5-b3128a760fb4",
    "timestamp": 1780866340456
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "7ade499c-015b-4903-8129-6c135264bf75",
    "timestamp": 1780866340458
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling google/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780866340458
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "google"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780866340458
  },
  {
    "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": 1780866344556
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "250bbd9a-3d22-4a04-910c-7cec437b3c33",
    "timestamp": 1780866344558
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/llama-3.2-11b-text-preview",
    "nodeId": "llm",
    "timestamp": 1780866344558
  },
  {
    "data": {
      "model": "llama-3.2-11b-text-preview",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780866344558
  },
  {
    "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": 1780866348653
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "b8d2b2fc-748c-43c5-a82b-d5e7357bbef8",
    "timestamp": 1780866348654
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866348654
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "b8d2b2fc-748c-43c5-a82b-d5e7357bbef8",
    "timestamp": 1780866348654
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "e3218faf-2486-46e0-bf43-3bc52927e2bd",
    "timestamp": 1780866348656
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866348656
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "e3218faf-2486-46e0-bf43-3bc52927e2bd",
    "timestamp": 1780866348656
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "3772b3dc-7601-4005-9b61-263b2c1abd5f",
    "timestamp": 1780866348657
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866348657
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "3772b3dc-7601-4005-9b61-263b2c1abd5f",
    "timestamp": 1780866348657
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "0d9f8bde-af54-480c-bdc9-15cd5b0e6f28",
    "timestamp": 1780866348658
  },
  {
    "data": {
      "inputKeys": [
        "output",
        "date",
        "subject",
        "spend",
        "text",
        "html",
        "labelIds",
        "from",
        "email_date",
        "email_subject",
        "email_content",
        "email_type"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866348658
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "0d9f8bde-af54-480c-bdc9-15cd5b0e6f28",
    "timestamp": 1780866348658
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "c1c4c490-d7a9-4b16-a81b-a338103764b6",
    "timestamp": 1780866348660
  },
  {
    "data": {
      "inputKeys": [
        "output",
        "date",
        "subject",
        "spend",
        "text",
        "html",
        "labelIds",
        "from",
        "email_date",
        "email_subject",
        "email_content",
        "email_type"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866348660
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "c1c4c490-d7a9-4b16-a81b-a338103764b6",
    "timestamp": 1780866348660
  },
  {
    "data": {
      "nodeType": "switch"
    },
    "event": "node_start",
    "nodeId": "01c5a934-9412-4ef9-81a8-c4aef19c8868",
    "timestamp": 1780866348662
  },
  {
    "event": "no rule matched -> default",
    "nodeId": "switch",
    "timestamp": 1780866348662
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "switch"
    },
    "event": "node_end",
    "nodeId": "01c5a934-9412-4ef9-81a8-c4aef19c8868",
    "timestamp": 1780866348662
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "10d57038-940e-47aa-84ea-3850f61ac757",
    "timestamp": 1780866348663
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866348663
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "10d57038-940e-47aa-84ea-3850f61ac757",
    "timestamp": 1780866348663
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "c2829f41-1e3f-40bc-8d4b-9fd1bac41381",
    "timestamp": 1780866348664
  },
  {
    "data": {
      "inputKeys": [
        "output",
        "date",
        "subject",
        "spend",
        "text",
        "html",
        "labelIds",
        "from",
        "email_date",
        "email_subject",
        "email_content",
        "email_type"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866348664
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "c2829f41-1e3f-40bc-8d4b-9fd1bac41381",
    "timestamp": 1780866348664
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "ecf9ea3c-3f34-43ef-b101-ca4a420e4c24",
    "timestamp": 1780866348666
  },
  {
    "data": {
      "inputKeys": [
        "output",
        "date",
        "subject",
        "spend",
        "text",
        "html",
        "labelIds",
        "from",
        "email_date",
        "email_subject",
        "email_content",
        "email_type"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866348666
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "ecf9ea3c-3f34-43ef-b101-ca4a420e4c24",
    "timestamp": 1780866348666
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "dae6d22e-587d-4102-b006-20a341ede5ee",
    "timestamp": 1780866348667
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1780866348667
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "dae6d22e-587d-4102-b006-20a341ede5ee",
    "timestamp": 1780866348667
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "112f5198-871e-42f9-9376-5fa074497413",
    "timestamp": 1780866348668
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780866348668
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780866348668
  },
  {
    "data": {
      "model": "gemini-2.5-flash-lite",
      "costUsd": 0.00008810000000000001,
      "provider": "openai",
      "latencyMs": 913,
      "promptTokens": 117,
      "completionTokens": 191
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780866349582
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "112f5198-871e-42f9-9376-5fa074497413",
    "timestamp": 1780866349582
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "87ab4932-aae5-4c5a-a175-c782bebdf781",
    "timestamp": 1780866349585
  },
  {
    "data": {
      "inputKeys": [
        "0"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866349585
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "87ab4932-aae5-4c5a-a175-c782bebdf781",
    "timestamp": 1780866349585
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "39b10715-54fe-4c07-9ca1-afbe43ae519e",
    "timestamp": 1780866349587
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780866349587
  },
  {
    "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": 1780866349587
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780866349768
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 181,
      "operation": "append"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780866349768
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "39b10715-54fe-4c07-9ca1-afbe43ae519e",
    "timestamp": 1780866349768
  },
  {
    "data": {
      "nodeType": "merge"
    },
    "event": "node_start",
    "nodeId": "b9c3cb29-e68e-4ae0-8930-185c17bc6cab",
    "timestamp": 1780866349770
  },
  {
    "data": {
      "inputCount": 2
    },
    "event": "merged 2 inputs",
    "nodeId": "merge",
    "timestamp": 1780866349770
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "merge"
    },
    "event": "node_end",
    "nodeId": "b9c3cb29-e68e-4ae0-8930-185c17bc6cab",
    "timestamp": 1780866349770
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "b50d632c-b762-4f61-b34a-91f941100668",
    "timestamp": 1780866349772
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780866349772
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780866349772
  },
  {
    "data": {
      "model": "gemini-2.5-flash-lite",
      "costUsd": 0.00005700000000000001,
      "provider": "openai",
      "latencyMs": 529,
      "promptTokens": 122,
      "completionTokens": 112
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780866350303
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "b50d632c-b762-4f61-b34a-91f941100668",
    "timestamp": 1780866350303
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "10fe4a38-139b-4284-9e86-dd36e472f59e",
    "timestamp": 1780866350306
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780866350306
  },
  {
    "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": 1780866350306
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780866350481
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 175,
      "operation": "append"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780866350481
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "10fe4a38-139b-4284-9e86-dd36e472f59e",
    "timestamp": 1780866350481
  }
]