AI Customer Support Bot with Google Sheets

2b1cca7f-b23c-49de-9d8b-07cb4950f58a

Latency
4382ms
Cost
$0.0000
Tokens
0
Status
partial
gemini-2.5-flash-lite

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "trigger-webhook",
    "timestamp": 1780872260591
  },
  {
    "data": {
      "kind": "n8n-nodes-base.webhook"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780872260591
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "trigger-webhook",
    "timestamp": 1780872260591
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "validate-input",
    "timestamp": 1780872260591
  },
  {
    "event": "execution error (simulated): require is not defined",
    "nodeId": "code",
    "timestamp": 1780872260593
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "code",
      "latencyMs": 0,
      "operation": "exec-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780872260593
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "validate-input",
    "timestamp": 1780872260593
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "ai-respond",
    "timestamp": 1780872260595
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 500
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780872260595
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780872260595
  },
  {
    "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": "ai-respond",
    "timestamp": 1780872264688
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "merge-response",
    "timestamp": 1780872264688
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "merge-response",
    "timestamp": 1780872264691
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "log-sheets",
    "timestamp": 1780872264693
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780872264693
  },
  {
    "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": 1780872264693
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780872264969
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 276,
      "operation": "append"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780872264969
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "log-sheets",
    "timestamp": 1780872264969
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "respond",
    "timestamp": 1780872264973
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780872264973
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "respond",
    "timestamp": 1780872264973
  }
]