AI Knowledge Base Generator from Google Sheets Data

c513b853-4cc0-434f-863d-7833678b0db9

Latency
28359ms
Cost
$0.0003
Tokens
113
Status
partial
gemini-2.5-flash

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "0404384b-10b6-4666-84a4-8870db30c607",
    "timestamp": 1783202936192
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202936192
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "0404384b-10b6-4666-84a4-8870db30c607",
    "timestamp": 1783202936192
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "84873f0c-81ce-442f-a33c-d7c6c2efa11b",
    "timestamp": 1783202936194
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202936194
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "84873f0c-81ce-442f-a33c-d7c6c2efa11b",
    "timestamp": 1783202936194
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "fbb1f3c3-06ad-44b5-b020-6fc3c8eda7c4",
    "timestamp": 1783202936197
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1783202936197
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1783202936197
  },
  {
    "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": "fbb1f3c3-06ad-44b5-b020-6fc3c8eda7c4",
    "timestamp": 1783202961536
  },
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "9b29e850-b9d0-4358-af62-92c20ab3b088",
    "timestamp": 1783202961541
  },
  {
    "data": {
      "kind": "n8n-nodes-base.executeWorkflowTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1783202961541
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "9b29e850-b9d0-4358-af62-92c20ab3b088",
    "timestamp": 1783202961541
  },
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "fa0c14be-03f4-4ed2-bd60-e93817382ded",
    "timestamp": 1783202961544
  },
  {
    "data": {
      "initialData": {
        "answer": "n8n offers a visual interface, extensive integrations, and a powerful automation engine that simplifies complex workflows.",
        "output": "This is a placeholder for the final generated knowledge base content.",
        "points": [
          {
            "name": "Ease of Use",
            "value": 5
          },
          {
            "name": "Integration Capabilities",
            "value": 4
          },
          {
            "name": "Automation Power",
            "value": 5
          }
        ],
        "result": {
          "map": [
            {
              "answer": "n8n is a powerful workflow automation tool.",
              "question": "What is n8n?"
            },
            {
              "answer": "n8n provides a wide range of pre-built integrations and allows custom integrations.",
              "question": "How does n8n handle integrations?"
            }
          ],
          "length": 2
        },
        "sheetID": "12345abcde",
        "question": "What are the key benefits of using n8n for workflow automation?",
        "sheetName": "Survey Responses",
        "properties": {
          "title": "n8n Automation Insights"
        },
        "surveyName": "n8n User Experience Survey",
        "Participant": "Alice Smith",
        "participant": "Alice Smith",
        "result.points": [
          {
            "name": "Ease of Use",
            "value": 5
          },
          {
            "name": "Integration Capabilities",
            "value": 4
          }
        ],
        "collectionName": "n8n_automation_insights",
        "result.payload": {
          "metadata": {
            "survey": "n8n User Experience Survey",
            "question": "What are the key benefits of using n8n for workflow automation?"
          }
        },
        "insightsSheetName": "Automation Insights"
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1783202961544
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "fa0c14be-03f4-4ed2-bd60-e93817382ded",
    "timestamp": 1783202961544
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "a6741f04-5a5b-47a9-ac08-eb562f9f6052",
    "timestamp": 1783202961548
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202961548
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "a6741f04-5a5b-47a9-ac08-eb562f9f6052",
    "timestamp": 1783202961548
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "30323019-59ba-4a19-a46e-196d469f097d",
    "timestamp": 1783202961550
  },
  {
    "event": "fetching GET https://sheets.googleapis.com/v4/spreadsheets/12345abcde",
    "nodeId": "http",
    "timestamp": 1783202961550
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/12345abcde",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1783202961550
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "http",
      "latencyMs": 250,
      "operation": "http-403",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202961698
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "30323019-59ba-4a19-a46e-196d469f097d",
    "timestamp": 1783202961698
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "da9a8ee8-5e3f-49db-8d1f-26a61ca82344",
    "timestamp": 1783202961703
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1783202961703
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 250,
      "operation": "read",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202961954
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "da9a8ee8-5e3f-49db-8d1f-26a61ca82344",
    "timestamp": 1783202961954
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "c78f1bf6-8390-48ee-88f4-7d1a893a8ade",
    "timestamp": 1783202961960
  },
  {
    "data": {
      "inputKeys": [
        "statusCode",
        "headers",
        "body",
        "simulated"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202961960
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "c78f1bf6-8390-48ee-88f4-7d1a893a8ade",
    "timestamp": 1783202961960
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "7663c3dd-f713-4034-bef6-0c000285f54f",
    "timestamp": 1783202961963
  },
  {
    "data": {
      "inputKeys": [
        "simulated",
        "echo",
        "items",
        "records"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202961963
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "7663c3dd-f713-4034-bef6-0c000285f54f",
    "timestamp": 1783202961963
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "70a0dcec-9f74-4af2-bd64-0ab762a77e51",
    "timestamp": 1783202961966
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1783202961966
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 250,
      "operation": "create",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202962218
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "70a0dcec-9f74-4af2-bd64-0ab762a77e51",
    "timestamp": 1783202962218
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "bddcafa8-6f54-4829-93c9-37bbb9e7edf3",
    "timestamp": 1783202962223
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1783202962223
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "bddcafa8-6f54-4829-93c9-37bbb9e7edf3",
    "timestamp": 1783202962223
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "4bad90b2-eefe-49c8-8caa-41cd4cb5e60f",
    "timestamp": 1783202962226
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1783202962226
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 250,
      "operation": "read",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202962478
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "4bad90b2-eefe-49c8-8caa-41cd4cb5e60f",
    "timestamp": 1783202962478
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "cbb42384-d46b-471f-a7d8-27e3de042492",
    "timestamp": 1783202962483
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202962483
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "cbb42384-d46b-471f-a7d8-27e3de042492",
    "timestamp": 1783202962483
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "47c64994-9d1f-42ca-a849-3eeab5335b66",
    "timestamp": 1783202962486
  },
  {
    "data": {
      "inputKeys": [
        "simulated",
        "echo",
        "items",
        "records"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202962486
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "47c64994-9d1f-42ca-a849-3eeab5335b66",
    "timestamp": 1783202962486
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "2579adf0-9c00-4b87-b53e-740044577ab0",
    "timestamp": 1783202962490
  },
  {
    "data": {
      "inputKeys": [
        "0"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202962490
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "2579adf0-9c00-4b87-b53e-740044577ab0",
    "timestamp": 1783202962490
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "c237d523-b290-41ca-b323-4cc7c7f6ff37",
    "timestamp": 1783202962492
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1783202962492
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "c237d523-b290-41ca-b323-4cc7c7f6ff37",
    "timestamp": 1783202962492
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "dcfaf927-6ecd-4ebe-aee0-5fb3367b2725",
    "timestamp": 1783202962495
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202962495
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "dcfaf927-6ecd-4ebe-aee0-5fb3367b2725",
    "timestamp": 1783202962495
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "7f44a770-4c5d-4404-ae95-d9dee8348380",
    "timestamp": 1783202962500
  },
  {
    "event": "fetching POST http://qdrant:6333/collections//points/scroll",
    "nodeId": "http",
    "timestamp": 1783202962500
  },
  {
    "data": {
      "url": "http://qdrant:6333/collections//points/scroll",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1783202962500
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "http",
      "latencyMs": 250,
      "operation": "fetch-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202962504
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "7f44a770-4c5d-4404-ae95-d9dee8348380",
    "timestamp": 1783202962504
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "2b6dc317-f8f3-4201-a9e1-d35ee578e79e",
    "timestamp": 1783202962507
  },
  {
    "event": "fetching POST http://qdrant:6333/collections//points",
    "nodeId": "http",
    "timestamp": 1783202962507
  },
  {
    "data": {
      "url": "http://qdrant:6333/collections//points",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1783202962507
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "http",
      "latencyMs": 250,
      "operation": "fetch-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202962510
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "2b6dc317-f8f3-4201-a9e1-d35ee578e79e",
    "timestamp": 1783202962510
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "d4a37d97-975a-4243-a7ea-81b3e30558a5",
    "timestamp": 1783202962512
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1783202962512
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "d4a37d97-975a-4243-a7ea-81b3e30558a5",
    "timestamp": 1783202962512
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "83d3b413-a661-4c4c-9b8d-6ee395a15348",
    "timestamp": 1783202962515
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202962515
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "83d3b413-a661-4c4c-9b8d-6ee395a15348",
    "timestamp": 1783202962515
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "14784dff-a8ea-4b6b-8379-b0c9051a8f98",
    "timestamp": 1783202962518
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202963019
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "14784dff-a8ea-4b6b-8379-b0c9051a8f98",
    "timestamp": 1783202963019
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "779b9411-db3e-44f3-ad2a-c9d40a70580d",
    "timestamp": 1783202963026
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202963526
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "779b9411-db3e-44f3-ad2a-c9d40a70580d",
    "timestamp": 1783202963526
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "a31ab677-f57c-4b78-a290-d4a913ed4f8e",
    "timestamp": 1783202963532
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202963532
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "a31ab677-f57c-4b78-a290-d4a913ed4f8e",
    "timestamp": 1783202963532
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "f31400fb-dd7a-4c62-90ec-e9d78bbaa5e8",
    "timestamp": 1783202963535
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202963535
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "f31400fb-dd7a-4c62-90ec-e9d78bbaa5e8",
    "timestamp": 1783202963535
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "450f89c5-ef0f-4bf8-8db9-6347247c7f4d",
    "timestamp": 1783202963538
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1783202963538
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "450f89c5-ef0f-4bf8-8db9-6347247c7f4d",
    "timestamp": 1783202963538
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "6ced8012-1dd3-4da3-8c27-e4f4dfc959f6",
    "timestamp": 1783202963541
  },
  {
    "data": {
      "of": 1,
      "kept": 1
    },
    "event": "filter",
    "nodeId": "passthrough",
    "timestamp": 1783202963541
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "6ced8012-1dd3-4da3-8c27-e4f4dfc959f6",
    "timestamp": 1783202963541
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "8ae81a55-75e2-40a3-bef6-0935ff08128f",
    "timestamp": 1783202963541
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "code",
      "latencyMs": 0,
      "operation": "no-source",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202963541
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "8ae81a55-75e2-40a3-bef6-0935ff08128f",
    "timestamp": 1783202963541
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "17584901-15d6-421f-ad69-3ba872276055",
    "timestamp": 1783202963545
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1783202963545
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1783202963545
  },
  {
    "data": {
      "model": "gemini-2.5-flash",
      "costUsd": 0.0002649,
      "provider": "openai",
      "latencyMs": 1004,
      "promptTokens": 8,
      "completionTokens": 105
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1783202964551
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "17584901-15d6-421f-ad69-3ba872276055",
    "timestamp": 1783202964551
  }
]