Analyze business data from Google Sheets with an OpenAI chatbot

6ac34fb4-d14b-48cd-bb32-263a21e14e90

Latency
5203ms
Cost
$0.0000
Tokens
344
Status
partial
gemini-2.5-flash-lite

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "e23ee5e6-10ae-414d-8288-d7a84a31a4ba",
    "timestamp": 1780869818671
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780869818671
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "e23ee5e6-10ae-414d-8288-d7a84a31a4ba",
    "timestamp": 1780869818671
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "8f6256ac-7d37-4535-9080-3d3a0dca6995",
    "timestamp": 1780869818674
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4.1-mini",
    "nodeId": "llm",
    "timestamp": 1780869818674
  },
  {
    "data": {
      "model": "gpt-4.1-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780869818674
  },
  {
    "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": "8f6256ac-7d37-4535-9080-3d3a0dca6995",
    "timestamp": 1780869822782
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "18a994f5-2e75-4e26-8b74-2ccd523f9a3f",
    "timestamp": 1780869822787
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780869822787
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780869822787
  },
  {
    "data": {
      "status": 200
    },
    "event": "sheets.read",
    "nodeId": "integration",
    "timestamp": 1780869823014
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 227,
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780869823014
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "18a994f5-2e75-4e26-8b74-2ccd523f9a3f",
    "timestamp": 1780869823014
  },
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "a492f95a-e09a-4fb8-8e87-852912fa3c20",
    "timestamp": 1780869823019
  },
  {
    "data": {
      "kind": "@n8n/n8n-nodes-langchain.chatTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780869823019
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "a492f95a-e09a-4fb8-8e87-852912fa3c20",
    "timestamp": 1780869823019
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "962ab14a-1645-4173-888a-725dfd2eeb7d",
    "timestamp": 1780869823022
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780869823022
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780869823022
  },
  {
    "data": {
      "status": 200
    },
    "event": "sheets.read",
    "nodeId": "integration",
    "timestamp": 1780869823172
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 150,
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780869823173
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "962ab14a-1645-4173-888a-725dfd2eeb7d",
    "timestamp": 1780869823173
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "e5e31fdf-737c-406c-887c-d6d2321d50a6",
    "timestamp": 1780869823177
  },
  {
    "data": {
      "messages": 2,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780869823177
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780869823177
  },
  {
    "data": {
      "model": "gemini-2.5-flash-lite",
      "costUsd": 0.0000413,
      "provider": "openai",
      "latencyMs": 433,
      "promptTokens": 321,
      "completionTokens": 23
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780869823616
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "e5e31fdf-737c-406c-887c-d6d2321d50a6",
    "timestamp": 1780869823616
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "ea2ea688-6780-491a-a758-941f076ff583",
    "timestamp": 1780869823621
  },
  {
    "data": {
      "inputKeys": [
        "text",
        "model",
        "usage"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780869823621
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "ea2ea688-6780-491a-a758-941f076ff583",
    "timestamp": 1780869823621
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "ba4a4417-b727-45f1-a301-18e75c8f902b",
    "timestamp": 1780869823623
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "chat",
      "latencyMs": 250,
      "operation": "run",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780869823874
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "ba4a4417-b727-45f1-a301-18e75c8f902b",
    "timestamp": 1780869823874
  }
]