Automated Web Research Reporter to Google Sheets

8ddb2437-c1ff-4489-9351-1b929bdd20a3

Latency
27149ms
Cost
$0.0000
Tokens
205
Status
partial
gemini-2.5-flash-lite

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "71b06728-7f59-49e3-9365-3281189a6659",
    "timestamp": 1780879089125
  },
  {
    "data": {
      "initialData": {
        "input": "Research n8n.io for competitive analysis",
        "row_number": 2
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1780879089125
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "71b06728-7f59-49e3-9365-3281189a6659",
    "timestamp": 1780879089125
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "7d5d53ac-6d3c-4b24-97c7-deb6b76749e5",
    "timestamp": 1780879089128
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o",
    "nodeId": "llm",
    "timestamp": 1780879089128
  },
  {
    "data": {
      "model": "gpt-4o",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780879089128
  },
  {
    "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": "7d5d53ac-6d3c-4b24-97c7-deb6b76749e5",
    "timestamp": 1780879115043
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "24e2f3b0-8b90-49a9-bde6-0fb0c2baf52a",
    "timestamp": 1780879115050
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780879115050
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "24e2f3b0-8b90-49a9-bde6-0fb0c2baf52a",
    "timestamp": 1780879115050
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "ff7ab74c-dfc6-43ce-8c57-6edf935b4915",
    "timestamp": 1780879115053
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "toolserpapi",
      "latencyMs": 250,
      "operation": "run",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780879115305
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "ff7ab74c-dfc6-43ce-8c57-6edf935b4915",
    "timestamp": 1780879115305
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "4fe311f2-4983-4380-b4ed-a827a406fce5",
    "timestamp": 1780879115311
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780879115311
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "4fe311f2-4983-4380-b4ed-a827a406fce5",
    "timestamp": 1780879115311
  },
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "0c1dafa9-28fe-4ef4-b80e-d4034e16f6c0",
    "timestamp": 1780879115315
  },
  {
    "data": {
      "kind": "n8n-nodes-base.scheduleTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780879115315
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "0c1dafa9-28fe-4ef4-b80e-d4034e16f6c0",
    "timestamp": 1780879115315
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "f7896dbd-5c15-44e9-96ca-c695a66562cc",
    "timestamp": 1780879115318
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780879115318
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "f7896dbd-5c15-44e9-96ca-c695a66562cc",
    "timestamp": 1780879115318
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "67d485c9-3289-4bb3-9523-cd24c0b1aa05",
    "timestamp": 1780879115322
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780879115322
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780879115322
  },
  {
    "data": {
      "status": 200
    },
    "event": "sheets.read",
    "nodeId": "integration",
    "timestamp": 1780879115587
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 265,
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780879115587
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "67d485c9-3289-4bb3-9523-cd24c0b1aa05",
    "timestamp": 1780879115587
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "b37019e3-c7ab-4119-986d-c27d082a036e",
    "timestamp": 1780879115591
  },
  {
    "data": {
      "inputKeys": [
        "values"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780879115591
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "b37019e3-c7ab-4119-986d-c27d082a036e",
    "timestamp": 1780879115591
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "89ed0723-4dbe-428d-b1a9-ebdf515e42bb",
    "timestamp": 1780879115595
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780879115595
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "89ed0723-4dbe-428d-b1a9-ebdf515e42bb",
    "timestamp": 1780879115595
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "34ea3862-e8e5-4bf2-a9aa-2ad084376bb5",
    "timestamp": 1780879115599
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780879115599
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "34ea3862-e8e5-4bf2-a9aa-2ad084376bb5",
    "timestamp": 1780879115599
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "ff1cb26d-6138-4ee1-9f28-4ecc80c1c8ae",
    "timestamp": 1780879115604
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780879115604
  },
  {
    "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": 1780879115604
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780879115764
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 160,
      "operation": "update"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780879115764
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "ff1cb26d-6138-4ee1-9f28-4ecc80c1c8ae",
    "timestamp": 1780879115764
  },
  {
    "data": {
      "nodeType": "merge"
    },
    "event": "node_start",
    "nodeId": "6611f852-b4d6-4a07-9428-db206ef57cc3",
    "timestamp": 1780879115769
  },
  {
    "data": {
      "inputCount": 2
    },
    "event": "merged 2 inputs",
    "nodeId": "merge",
    "timestamp": 1780879115769
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "merge"
    },
    "event": "node_end",
    "nodeId": "6611f852-b4d6-4a07-9428-db206ef57cc3",
    "timestamp": 1780879115769
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "d7db2452-ba3d-4adb-bd8b-d17a92d1bce5",
    "timestamp": 1780879115772
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780879115772
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780879115772
  },
  {
    "data": {
      "model": "gemini-2.5-flash-lite",
      "costUsd": 0.0000271,
      "provider": "openai",
      "latencyMs": 500,
      "promptTokens": 183,
      "completionTokens": 22
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780879116274
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "d7db2452-ba3d-4adb-bd8b-d17a92d1bce5",
    "timestamp": 1780879116274
  }
]