AI Chat Interface for Querying Google Sheets

36da50f1-b3e8-4eb4-8143-4ae16f4fd24b

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

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "89af21df-1125-4df6-9d43-a643e02bb53f",
    "timestamp": 1780866350626
  },
  {
    "data": {
      "kind": "n8n-nodes-base.executeWorkflowTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780866350626
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "89af21df-1125-4df6-9d43-a643e02bb53f",
    "timestamp": 1780866350626
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "616eebc5-5c5c-4fa1-b13f-61a477742c72",
    "timestamp": 1780866350627
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866350627
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "616eebc5-5c5c-4fa1-b13f-61a477742c72",
    "timestamp": 1780866350627
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "891ad3a8-72f0-45ad-8777-1647a7342c00",
    "timestamp": 1780866350628
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866350628
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "891ad3a8-72f0-45ad-8777-1647a7342c00",
    "timestamp": 1780866350628
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "0f3ca6ff-fc01-4f33-b1a7-cb82a0ec5c88",
    "timestamp": 1780866350630
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866350630
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "0f3ca6ff-fc01-4f33-b1a7-cb82a0ec5c88",
    "timestamp": 1780866350630
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "d955e499-5a3e-45a3-9fc8-266e2f687ecc",
    "timestamp": 1780866350631
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-3.5-turbo-0125",
    "nodeId": "llm",
    "timestamp": 1780866350631
  },
  {
    "data": {
      "model": "gpt-3.5-turbo-0125",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780866350631
  },
  {
    "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": "d955e499-5a3e-45a3-9fc8-266e2f687ecc",
    "timestamp": 1780866354830
  },
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "28fbda0b-1e01-4f59-af5b-fe02eba899b1",
    "timestamp": 1780866354832
  },
  {
    "data": {
      "kind": "@n8n/n8n-nodes-langchain.chatTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780866354832
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "28fbda0b-1e01-4f59-af5b-fe02eba899b1",
    "timestamp": 1780866354832
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "daca1624-6c35-473a-bf3a-5fa0686a0a62",
    "timestamp": 1780866354833
  },
  {
    "data": {
      "inputKeys": [
        "sheetUrl",
        "query",
        "row_number",
        "operation"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866354833
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "daca1624-6c35-473a-bf3a-5fa0686a0a62",
    "timestamp": 1780866354833
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "c89614f4-d8b1-4f7b-9e7c-856e3f89eadb",
    "timestamp": 1780866354835
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780866354835
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780866354835
  },
  {
    "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": "c89614f4-d8b1-4f7b-9e7c-856e3f89eadb",
    "timestamp": 1780866358939
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "f895d926-0f70-415b-9492-c3ecf186e761",
    "timestamp": 1780866358945
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780866358945
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780866358945
  },
  {
    "data": {
      "status": 200
    },
    "event": "sheets.read",
    "nodeId": "integration",
    "timestamp": 1780866359251
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 306,
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780866359251
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "f895d926-0f70-415b-9492-c3ecf186e761",
    "timestamp": 1780866359251
  },
  {
    "data": {
      "nodeType": "switch"
    },
    "event": "node_start",
    "nodeId": "69b9e70a-9104-4731-9f16-8324a3f7e423",
    "timestamp": 1780866359255
  },
  {
    "event": "no rule matched -> default",
    "nodeId": "switch",
    "timestamp": 1780866359255
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "switch"
    },
    "event": "node_end",
    "nodeId": "69b9e70a-9104-4731-9f16-8324a3f7e423",
    "timestamp": 1780866359255
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "68edca41-0196-47d8-9378-31fed0a70918",
    "timestamp": 1780866359256
  },
  {
    "data": {
      "inputKeys": [
        "values"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866359256
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "68edca41-0196-47d8-9378-31fed0a70918",
    "timestamp": 1780866359256
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "dbb887f0-93a7-466e-9c9f-8aa4e7da935d",
    "timestamp": 1780866359258
  },
  {
    "data": {
      "inputKeys": [
        "values"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866359258
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "dbb887f0-93a7-466e-9c9f-8aa4e7da935d",
    "timestamp": 1780866359258
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "041d32ca-e59a-4b67-a3e6-4e2f19e3de72",
    "timestamp": 1780866359259
  },
  {
    "data": {
      "of": 1,
      "kept": 1
    },
    "event": "filter",
    "nodeId": "passthrough",
    "timestamp": 1780866359259
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "041d32ca-e59a-4b67-a3e6-4e2f19e3de72",
    "timestamp": 1780866359259
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "7a9dea08-f9e9-4139-842a-9066a9cf04ea",
    "timestamp": 1780866359259
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "7a9dea08-f9e9-4139-842a-9066a9cf04ea",
    "timestamp": 1780866359261
  }
]