AI Knowledge Base Generator from Google Sheets Data

9d24d4a2-b85c-4b7c-a168-10ea04262872

Latency
7755ms
Cost
$0.0020
Tokens
819
Status
success
gemini-3-flash-preview

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "0404384b-10b6-4666-84a4-8870db30c607",
    "timestamp": 1783202965657
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202965657
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "0404384b-10b6-4666-84a4-8870db30c607",
    "timestamp": 1783202965657
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "84873f0c-81ce-442f-a33c-d7c6c2efa11b",
    "timestamp": 1783202965660
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202965660
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "84873f0c-81ce-442f-a33c-d7c6c2efa11b",
    "timestamp": 1783202965660
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "fbb1f3c3-06ad-44b5-b020-6fc3c8eda7c4",
    "timestamp": 1783202965662
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1783202965662
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1783202965662
  },
  {
    "data": {
      "model": "gemini-3-flash-preview",
      "costUsd": 0.0017952999999999999,
      "provider": "openai",
      "latencyMs": 4520,
      "promptTokens": 1,
      "completionTokens": 718
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1783202970184
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "fbb1f3c3-06ad-44b5-b020-6fc3c8eda7c4",
    "timestamp": 1783202970184
  },
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "9b29e850-b9d0-4358-af62-92c20ab3b088",
    "timestamp": 1783202970188
  },
  {
    "data": {
      "kind": "n8n-nodes-base.executeWorkflowTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1783202970188
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "9b29e850-b9d0-4358-af62-92c20ab3b088",
    "timestamp": 1783202970188
  },
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "fa0c14be-03f4-4ed2-bd60-e93817382ded",
    "timestamp": 1783202970192
  },
  {
    "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": 1783202970192
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "fa0c14be-03f4-4ed2-bd60-e93817382ded",
    "timestamp": 1783202970192
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "a6741f04-5a5b-47a9-ac08-eb562f9f6052",
    "timestamp": 1783202970195
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202970195
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "a6741f04-5a5b-47a9-ac08-eb562f9f6052",
    "timestamp": 1783202970195
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "30323019-59ba-4a19-a46e-196d469f097d",
    "timestamp": 1783202970198
  },
  {
    "event": "fetching GET https://sheets.googleapis.com/v4/spreadsheets/12345abcde",
    "nodeId": "http",
    "timestamp": 1783202970198
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/12345abcde",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1783202970198
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "http",
      "latencyMs": 250,
      "operation": "http-403",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202970363
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "30323019-59ba-4a19-a46e-196d469f097d",
    "timestamp": 1783202970363
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "da9a8ee8-5e3f-49db-8d1f-26a61ca82344",
    "timestamp": 1783202970366
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1783202970366
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 250,
      "operation": "read",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202970618
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "da9a8ee8-5e3f-49db-8d1f-26a61ca82344",
    "timestamp": 1783202970618
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "c78f1bf6-8390-48ee-88f4-7d1a893a8ade",
    "timestamp": 1783202970623
  },
  {
    "data": {
      "inputKeys": [
        "statusCode",
        "headers",
        "body",
        "simulated"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202970623
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "c78f1bf6-8390-48ee-88f4-7d1a893a8ade",
    "timestamp": 1783202970623
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "7663c3dd-f713-4034-bef6-0c000285f54f",
    "timestamp": 1783202970627
  },
  {
    "data": {
      "inputKeys": [
        "simulated",
        "echo",
        "items",
        "records"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202970627
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "7663c3dd-f713-4034-bef6-0c000285f54f",
    "timestamp": 1783202970627
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "70a0dcec-9f74-4af2-bd64-0ab762a77e51",
    "timestamp": 1783202970630
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1783202970630
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 250,
      "operation": "create",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202970880
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "70a0dcec-9f74-4af2-bd64-0ab762a77e51",
    "timestamp": 1783202970880
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "bddcafa8-6f54-4829-93c9-37bbb9e7edf3",
    "timestamp": 1783202970885
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1783202970885
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "bddcafa8-6f54-4829-93c9-37bbb9e7edf3",
    "timestamp": 1783202970885
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "4bad90b2-eefe-49c8-8caa-41cd4cb5e60f",
    "timestamp": 1783202970889
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1783202970889
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 250,
      "operation": "read",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202971140
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "4bad90b2-eefe-49c8-8caa-41cd4cb5e60f",
    "timestamp": 1783202971140
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "cbb42384-d46b-471f-a7d8-27e3de042492",
    "timestamp": 1783202971146
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202971146
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "cbb42384-d46b-471f-a7d8-27e3de042492",
    "timestamp": 1783202971146
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "47c64994-9d1f-42ca-a849-3eeab5335b66",
    "timestamp": 1783202971149
  },
  {
    "data": {
      "inputKeys": [
        "simulated",
        "echo",
        "items",
        "records"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202971149
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "47c64994-9d1f-42ca-a849-3eeab5335b66",
    "timestamp": 1783202971149
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "2579adf0-9c00-4b87-b53e-740044577ab0",
    "timestamp": 1783202971154
  },
  {
    "data": {
      "inputKeys": [
        "0"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202971154
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "2579adf0-9c00-4b87-b53e-740044577ab0",
    "timestamp": 1783202971154
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "c237d523-b290-41ca-b323-4cc7c7f6ff37",
    "timestamp": 1783202971156
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1783202971156
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "c237d523-b290-41ca-b323-4cc7c7f6ff37",
    "timestamp": 1783202971156
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "dcfaf927-6ecd-4ebe-aee0-5fb3367b2725",
    "timestamp": 1783202971159
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202971159
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "dcfaf927-6ecd-4ebe-aee0-5fb3367b2725",
    "timestamp": 1783202971159
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "7f44a770-4c5d-4404-ae95-d9dee8348380",
    "timestamp": 1783202971162
  },
  {
    "event": "fetching POST http://qdrant:6333/collections//points/scroll",
    "nodeId": "http",
    "timestamp": 1783202971162
  },
  {
    "data": {
      "url": "http://qdrant:6333/collections//points/scroll",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1783202971162
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "http",
      "latencyMs": 250,
      "operation": "fetch-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202971167
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "7f44a770-4c5d-4404-ae95-d9dee8348380",
    "timestamp": 1783202971167
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "2b6dc317-f8f3-4201-a9e1-d35ee578e79e",
    "timestamp": 1783202971170
  },
  {
    "event": "fetching POST http://qdrant:6333/collections//points",
    "nodeId": "http",
    "timestamp": 1783202971170
  },
  {
    "data": {
      "url": "http://qdrant:6333/collections//points",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1783202971170
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "http",
      "latencyMs": 250,
      "operation": "fetch-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202971174
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "2b6dc317-f8f3-4201-a9e1-d35ee578e79e",
    "timestamp": 1783202971174
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "d4a37d97-975a-4243-a7ea-81b3e30558a5",
    "timestamp": 1783202971177
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1783202971177
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "d4a37d97-975a-4243-a7ea-81b3e30558a5",
    "timestamp": 1783202971177
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "83d3b413-a661-4c4c-9b8d-6ee395a15348",
    "timestamp": 1783202971179
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202971179
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "83d3b413-a661-4c4c-9b8d-6ee395a15348",
    "timestamp": 1783202971179
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "14784dff-a8ea-4b6b-8379-b0c9051a8f98",
    "timestamp": 1783202971182
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202971683
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "14784dff-a8ea-4b6b-8379-b0c9051a8f98",
    "timestamp": 1783202971683
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "779b9411-db3e-44f3-ad2a-c9d40a70580d",
    "timestamp": 1783202971690
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202972190
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "779b9411-db3e-44f3-ad2a-c9d40a70580d",
    "timestamp": 1783202972190
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "a31ab677-f57c-4b78-a290-d4a913ed4f8e",
    "timestamp": 1783202972193
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783202972193
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "a31ab677-f57c-4b78-a290-d4a913ed4f8e",
    "timestamp": 1783202972193
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "f31400fb-dd7a-4c62-90ec-e9d78bbaa5e8",
    "timestamp": 1783202972197
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783202972197
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "f31400fb-dd7a-4c62-90ec-e9d78bbaa5e8",
    "timestamp": 1783202972197
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "450f89c5-ef0f-4bf8-8db9-6347247c7f4d",
    "timestamp": 1783202972199
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1783202972199
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "450f89c5-ef0f-4bf8-8db9-6347247c7f4d",
    "timestamp": 1783202972199
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "6ced8012-1dd3-4da3-8c27-e4f4dfc959f6",
    "timestamp": 1783202972201
  },
  {
    "data": {
      "of": 1,
      "kept": 1
    },
    "event": "filter",
    "nodeId": "passthrough",
    "timestamp": 1783202972201
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "6ced8012-1dd3-4da3-8c27-e4f4dfc959f6",
    "timestamp": 1783202972201
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "8ae81a55-75e2-40a3-bef6-0935ff08128f",
    "timestamp": 1783202972202
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "code",
      "latencyMs": 0,
      "operation": "no-source",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783202972202
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "8ae81a55-75e2-40a3-bef6-0935ff08128f",
    "timestamp": 1783202972202
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "17584901-15d6-421f-ad69-3ba872276055",
    "timestamp": 1783202972205
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1783202972205
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1783202972205
  },
  {
    "data": {
      "model": "gemini-3-flash-preview",
      "costUsd": 0.0002324,
      "provider": "openai",
      "latencyMs": 1206,
      "promptTokens": 8,
      "completionTokens": 92
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1783202973412
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "17584901-15d6-421f-ad69-3ba872276055",
    "timestamp": 1783202973412
  }
]