Extract Invoice and Payment Spend to Sheets

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "8e1e0861-9f06-4fe2-a9c1-423bab246959",
    "timestamp": 1782939620398
  },
  {
    "data": {
      "kind": "n8n-nodes-base.gmailTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1782939620398
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "8e1e0861-9f06-4fe2-a9c1-423bab246959",
    "timestamp": 1782939620398
  },
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "364fe355-672a-4074-800a-a7496c4fb1b2",
    "timestamp": 1782939620400
  },
  {
    "data": {
      "kind": "n8n-nodes-base.gmailTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1782939620400
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "364fe355-672a-4074-800a-a7496c4fb1b2",
    "timestamp": 1782939620400
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "0d75443d-0d23-4120-95e5-b3128a760fb4",
    "timestamp": 1782939620401
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1782939620401
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "0d75443d-0d23-4120-95e5-b3128a760fb4",
    "timestamp": 1782939620401
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "7ade499c-015b-4903-8129-6c135264bf75",
    "timestamp": 1782939620402
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling google/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1782939620402
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "google"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1782939620402
  },
  {
    "data": {
      "model": "gpt-4o-mini-2024-07-18",
      "costUsd": 0.0001075,
      "provider": "google",
      "latencyMs": 511,
      "promptTokens": 7,
      "completionTokens": 9
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1782939620918
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "7ade499c-015b-4903-8129-6c135264bf75",
    "timestamp": 1782939620918
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "250bbd9a-3d22-4a04-910c-7cec437b3c33",
    "timestamp": 1782939620919
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/llama-3.2-11b-text-preview",
    "nodeId": "llm",
    "timestamp": 1782939620919
  },
  {
    "data": {
      "model": "llama-3.2-11b-text-preview",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1782939620919
  },
  {
    "data": {
      "model": "gpt-4o-mini-2024-07-18",
      "costUsd": 0.0001075,
      "provider": "openai",
      "latencyMs": 697,
      "promptTokens": 7,
      "completionTokens": 9
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1782939621633
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "250bbd9a-3d22-4a04-910c-7cec437b3c33",
    "timestamp": 1782939621633
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "b8d2b2fc-748c-43c5-a82b-d5e7357bbef8",
    "timestamp": 1782939621635
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1782939621635
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "b8d2b2fc-748c-43c5-a82b-d5e7357bbef8",
    "timestamp": 1782939621635
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "e3218faf-2486-46e0-bf43-3bc52927e2bd",
    "timestamp": 1782939621636
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1782939621636
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "e3218faf-2486-46e0-bf43-3bc52927e2bd",
    "timestamp": 1782939621636
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "3772b3dc-7601-4005-9b61-263b2c1abd5f",
    "timestamp": 1782939621637
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1782939621637
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "3772b3dc-7601-4005-9b61-263b2c1abd5f",
    "timestamp": 1782939621637
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "0d9f8bde-af54-480c-bdc9-15cd5b0e6f28",
    "timestamp": 1782939621638
  },
  {
    "data": {
      "inputKeys": [
        "date",
        "from",
        "html",
        "text",
        "spend",
        "output",
        "subject",
        "labelIds",
        "email_date",
        "email_type",
        "email_content",
        "email_subject"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1782939621638
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "0d9f8bde-af54-480c-bdc9-15cd5b0e6f28",
    "timestamp": 1782939621638
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "c1c4c490-d7a9-4b16-a81b-a338103764b6",
    "timestamp": 1782939621640
  },
  {
    "data": {
      "inputKeys": [
        "date",
        "from",
        "html",
        "text",
        "spend",
        "output",
        "subject",
        "labelIds",
        "email_date",
        "email_type",
        "email_content",
        "email_subject"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1782939621640
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "c1c4c490-d7a9-4b16-a81b-a338103764b6",
    "timestamp": 1782939621640
  },
  {
    "data": {
      "nodeType": "switch"
    },
    "event": "node_start",
    "nodeId": "01c5a934-9412-4ef9-81a8-c4aef19c8868",
    "timestamp": 1782939621641
  },
  {
    "event": "no rule matched -> default",
    "nodeId": "switch",
    "timestamp": 1782939621641
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "switch"
    },
    "event": "node_end",
    "nodeId": "01c5a934-9412-4ef9-81a8-c4aef19c8868",
    "timestamp": 1782939621641
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "10d57038-940e-47aa-84ea-3850f61ac757",
    "timestamp": 1782939621642
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1782939621642
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "10d57038-940e-47aa-84ea-3850f61ac757",
    "timestamp": 1782939621642
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "c2829f41-1e3f-40bc-8d4b-9fd1bac41381",
    "timestamp": 1782939621643
  },
  {
    "data": {
      "inputKeys": [
        "date",
        "from",
        "html",
        "text",
        "spend",
        "output",
        "subject",
        "labelIds",
        "email_date",
        "email_type",
        "email_content",
        "email_subject"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1782939621643
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "c2829f41-1e3f-40bc-8d4b-9fd1bac41381",
    "timestamp": 1782939621643
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "ecf9ea3c-3f34-43ef-b101-ca4a420e4c24",
    "timestamp": 1782939621644
  },
  {
    "data": {
      "inputKeys": [
        "date",
        "from",
        "html",
        "text",
        "spend",
        "output",
        "subject",
        "labelIds",
        "email_date",
        "email_type",
        "email_content",
        "email_subject"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1782939621644
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "ecf9ea3c-3f34-43ef-b101-ca4a420e4c24",
    "timestamp": 1782939621644
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "dae6d22e-587d-4102-b006-20a341ede5ee",
    "timestamp": 1782939621645
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1782939621645
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "dae6d22e-587d-4102-b006-20a341ede5ee",
    "timestamp": 1782939621645
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "112f5198-871e-42f9-9376-5fa074497413",
    "timestamp": 1782939621646
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1782939621646
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1782939621646
  },
  {
    "data": {
      "model": "gpt-4o-mini-2024-07-18",
      "costUsd": 0.0012875,
      "provider": "openai",
      "latencyMs": 1618,
      "promptTokens": 99,
      "completionTokens": 104
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1782939623265
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "112f5198-871e-42f9-9376-5fa074497413",
    "timestamp": 1782939623265
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "87ab4932-aae5-4c5a-a175-c782bebdf781",
    "timestamp": 1782939623267
  },
  {
    "data": {
      "inputKeys": [
        "0"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1782939623267
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "87ab4932-aae5-4c5a-a175-c782bebdf781",
    "timestamp": 1782939623267
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "39b10715-54fe-4c07-9ca1-afbe43ae519e",
    "timestamp": 1782939623268
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939623769
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "39b10715-54fe-4c07-9ca1-afbe43ae519e",
    "timestamp": 1782939623769
  },
  {
    "data": {
      "nodeType": "merge"
    },
    "event": "node_start",
    "nodeId": "b9c3cb29-e68e-4ae0-8930-185c17bc6cab",
    "timestamp": 1782939623770
  },
  {
    "data": {
      "inputCount": 2
    },
    "event": "merged 2 inputs",
    "nodeId": "merge",
    "timestamp": 1782939623770
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "merge"
    },
    "event": "node_end",
    "nodeId": "b9c3cb29-e68e-4ae0-8930-185c17bc6cab",
    "timestamp": 1782939623770
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "b50d632c-b762-4f61-b34a-91f941100668",
    "timestamp": 1782939623771
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1782939623771
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1782939623771
  },
  {
    "data": {
      "model": "gpt-4o-mini-2024-07-18",
      "costUsd": 0.00122,
      "provider": "openai",
      "latencyMs": 1389,
      "promptTokens": 104,
      "completionTokens": 96
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1782939625162
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "b50d632c-b762-4f61-b34a-91f941100668",
    "timestamp": 1782939625162
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "10fe4a38-139b-4284-9e86-dd36e472f59e",
    "timestamp": 1782939625193
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939625693
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "10fe4a38-139b-4284-9e86-dd36e472f59e",
    "timestamp": 1782939625693
  }
]