AI Question Generator for Google Sheets Documentation

e59c3c26-da10-474d-8166-fec533ff1605

Latency
31228ms
Cost
$0.0015
Tokens
611
Status
partial
gemini-2.5-flash

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "9c3c06eb-8b48-4229-9b16-7fe7c4f886c3",
    "timestamp": 1783204529907
  },
  {
    "data": {
      "initialData": {
        "data": {
          "name": "Basic Operations",
          "sheet": "Sheet1",
          "outdir": "/docs/google-sheets",
          "row_number": 1,
          "displayName": "Google Sheets Documentation - Basic Operations",
          "Category name": "Google Sheets"
        },
        "name": "Basic Operations",
        "text": "This document outlines the process for managing Google Sheets. It covers creating new sheets, adding and deleting columns and rows, formatting cells, and basic data entry.  For advanced features like formulas and pivot tables, refer to the separate 'Google Sheets Advanced Features' guide.",
        "sheet": "Sheet1",
        "answer": "To add a new column, select the column header to the right of where you want to insert the new column, right-click, and choose 'Insert 1 column left' or 'Insert 1 column right'.",
        "append": "Additionally, you can use the 'Insert' menu to add columns or rows.",
        "outdir": "/docs/google-sheets",
        "question": "How do I add a new column to an existing Google Sheet?",
        "ai_example": "Q: How do I delete a row?\nA: To delete a row, right-click on the row number you wish to delete and select 'Delete row'.",
        "text.length": 191,
        "ai_completion": "To add a new column in Google Sheets, you can right-click on the column header where you want to insert the new column (either to the left or right of it) and select the 'Insert 1 column left' or 'Insert 1 column right' option. Alternatively, you can go to the 'Insert' menu and choose 'Column left' or 'Column right'.",
        "text.substring": "This document outlines the process for managing Google Sheets.",
        "data.row_number": 1,
        "data.displayName": "Google Sheets Documentation - Basic Operations",
        "text.toLowerCase": "this document outlines the process for managing google sheets. it covers creating new sheets, adding and deleting columns and rows, formatting cells, and basic data entry.  for advanced features like formulas and pivot tables, refer to the separate 'google sheets advanced features' guide.",
        "data.Category name": "Google Sheets",
        "ai_completion_format": "text"
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1783204529907
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "9c3c06eb-8b48-4229-9b16-7fe7c4f886c3",
    "timestamp": 1783204529907
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "2a8d8297-18de-4e1f-b44b-93842f7c1709",
    "timestamp": 1783204529911
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1783204529911
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1783204529911
  },
  {
    "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": "2a8d8297-18de-4e1f-b44b-93842f7c1709",
    "timestamp": 1783204555220
  },
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "e5776c79-51e4-4469-8cf7-dff009ee0ffd",
    "timestamp": 1783204555226
  },
  {
    "data": {
      "kind": "n8n-nodes-base.executeWorkflowTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1783204555227
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "e5776c79-51e4-4469-8cf7-dff009ee0ffd",
    "timestamp": 1783204555227
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "a42de52f-292b-4b60-ba6d-ff1a672a9758",
    "timestamp": 1783204555232
  },
  {
    "data": {
      "service": "wordpress",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1783204555232
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "wordpress",
      "latencyMs": 250,
      "operation": "read",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204555484
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "a42de52f-292b-4b60-ba6d-ff1a672a9758",
    "timestamp": 1783204555484
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "abcad9f3-9f05-40e7-8925-32c59b1a6355",
    "timestamp": 1783204555490
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "webflow",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "create",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204555992
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "abcad9f3-9f05-40e7-8925-32c59b1a6355",
    "timestamp": 1783204555992
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "60942673-646f-43df-8c0c-c78975ea38c4",
    "timestamp": 1783204555998
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "http",
      "latencyMs": 250,
      "operation": "unresolvable-url",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204555998
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "60942673-646f-43df-8c0c-c78975ea38c4",
    "timestamp": 1783204555998
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "9abc3871-8103-4659-9afa-93142dabec01",
    "timestamp": 1783204556001
  },
  {
    "data": {
      "inputKeys": [
        "question",
        "answer",
        "text",
        "text.toLowerCase",
        "text.substring",
        "text.length",
        "append",
        "data.displayName",
        "data.Category name",
        "data",
        "name",
        "outdir",
        "data.row_number",
        "sheet",
        "ai_completion",
        "ai_completion_format",
        "ai_example"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783204556001
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "9abc3871-8103-4659-9afa-93142dabec01",
    "timestamp": 1783204556001
  },
  {
    "data": {
      "nodeType": "switch"
    },
    "event": "node_start",
    "nodeId": "99a4ca3b-3ad0-48a7-84d7-eb83b61e938b",
    "timestamp": 1783204556004
  },
  {
    "event": "no rule matched -> default",
    "nodeId": "switch",
    "timestamp": 1783204556004
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "switch"
    },
    "event": "node_end",
    "nodeId": "99a4ca3b-3ad0-48a7-84d7-eb83b61e938b",
    "timestamp": 1783204556004
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "417b1c53-ec19-4f59-9580-b6080d3bc103",
    "timestamp": 1783204556007
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1783204556007
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "417b1c53-ec19-4f59-9580-b6080d3bc103",
    "timestamp": 1783204556007
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "e2cc607b-8502-4beb-ace5-8670af845134",
    "timestamp": 1783204556011
  },
  {
    "data": {
      "inputKeys": [
        "question",
        "answer",
        "text",
        "text.toLowerCase",
        "text.substring",
        "text.length",
        "append",
        "data.displayName",
        "data.Category name",
        "data",
        "name",
        "outdir",
        "data.row_number",
        "sheet",
        "ai_completion",
        "ai_completion_format",
        "ai_example"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783204556011
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "e2cc607b-8502-4beb-ace5-8670af845134",
    "timestamp": 1783204556011
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "e5b7ebe7-0e0f-4f61-8a14-afc51eb37270",
    "timestamp": 1783204556015
  },
  {
    "data": {
      "inputKeys": [
        "question",
        "answer",
        "text",
        "text.toLowerCase",
        "text.substring",
        "text.length",
        "append",
        "data.displayName",
        "data.Category name",
        "data",
        "name",
        "outdir",
        "data.row_number",
        "sheet",
        "ai_completion",
        "ai_completion_format",
        "ai_example"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783204556015
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "e5b7ebe7-0e0f-4f61-8a14-afc51eb37270",
    "timestamp": 1783204556015
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "454ccacd-104c-4cad-b52e-72447a49fb04",
    "timestamp": 1783204556018
  },
  {
    "data": {
      "inputKeys": [
        "question",
        "answer",
        "text",
        "text.toLowerCase",
        "text.substring",
        "text.length",
        "append",
        "data.displayName",
        "data.Category name",
        "data",
        "name",
        "outdir",
        "data.row_number",
        "sheet",
        "ai_completion",
        "ai_completion_format",
        "ai_example"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783204556018
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "454ccacd-104c-4cad-b52e-72447a49fb04",
    "timestamp": 1783204556018
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "ce1905c2-f41a-4dea-bd03-a9ae1e893326",
    "timestamp": 1783204556020
  },
  {
    "data": {
      "inputKeys": [
        "question",
        "answer",
        "text",
        "text.toLowerCase",
        "text.substring",
        "text.length",
        "append",
        "data.displayName",
        "data.Category name",
        "data",
        "name",
        "outdir",
        "data.row_number",
        "sheet",
        "ai_completion",
        "ai_completion_format",
        "ai_example"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783204556020
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "ce1905c2-f41a-4dea-bd03-a9ae1e893326",
    "timestamp": 1783204556020
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "8f7cefc1-9fc0-474b-a81e-bf573068258b",
    "timestamp": 1783204556022
  },
  {
    "data": {
      "count": 1
    },
    "event": "splitOut",
    "nodeId": "passthrough",
    "timestamp": 1783204556022
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "8f7cefc1-9fc0-474b-a81e-bf573068258b",
    "timestamp": 1783204556022
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "a6c24857-ad3b-4561-b40b-8520064e861b",
    "timestamp": 1783204556024
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783204556024
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "a6c24857-ad3b-4561-b40b-8520064e861b",
    "timestamp": 1783204556024
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "2b4712cb-371c-45bc-a024-363ae951b0ac",
    "timestamp": 1783204556026
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783204556026
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "2b4712cb-371c-45bc-a024-363ae951b0ac",
    "timestamp": 1783204556026
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "9aeb5858-d6d4-4541-8a0d-851740d948ae",
    "timestamp": 1783204556028
  },
  {
    "data": {
      "count": 1
    },
    "event": "aggregate",
    "nodeId": "passthrough",
    "timestamp": 1783204556028
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "9aeb5858-d6d4-4541-8a0d-851740d948ae",
    "timestamp": 1783204556028
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "2c1d56c5-20f2-4691-ab89-87edf9902a5f",
    "timestamp": 1783204556030
  },
  {
    "data": {
      "inputKeys": [
        "items"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783204556030
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "2c1d56c5-20f2-4691-ab89-87edf9902a5f",
    "timestamp": 1783204556030
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "5147d5ef-f56d-49b0-9be8-0af7ccb8cdae",
    "timestamp": 1783204556032
  },
  {
    "data": {
      "service": "googleDrive",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1783204556032
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleDrive",
      "latencyMs": 250,
      "operation": "createFromText",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204556284
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "5147d5ef-f56d-49b0-9be8-0af7ccb8cdae",
    "timestamp": 1783204556284
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "d8495ac2-7f45-4dd5-8eb5-d95c9e572dd3",
    "timestamp": 1783204556289
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1783204556289
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 250,
      "operation": "read",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204556541
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "d8495ac2-7f45-4dd5-8eb5-d95c9e572dd3",
    "timestamp": 1783204556541
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "344c93e6-3ed9-4dd0-8a38-c2f853ef3cc1",
    "timestamp": 1783204556547
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783204556547
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "344c93e6-3ed9-4dd0-8a38-c2f853ef3cc1",
    "timestamp": 1783204556547
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "76aca3a6-c3ff-41fa-9fdf-30839df85669",
    "timestamp": 1783204556550
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783204556550
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "76aca3a6-c3ff-41fa-9fdf-30839df85669",
    "timestamp": 1783204556550
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "663b1ce2-ccb5-43d1-8871-c5fa7412151c",
    "timestamp": 1783204556553
  },
  {
    "data": {
      "inputKeys": [
        "simulated",
        "echo",
        "items",
        "records"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783204556553
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "663b1ce2-ccb5-43d1-8871-c5fa7412151c",
    "timestamp": 1783204556553
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "087249d0-d001-49c3-8695-e0e3f02b66e2",
    "timestamp": 1783204556555
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1783204556555
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "087249d0-d001-49c3-8695-e0e3f02b66e2",
    "timestamp": 1783204556555
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "edd9e2c7-9477-4145-bb1f-1424ccb2080f",
    "timestamp": 1783204556557
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "update",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204557059
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "edd9e2c7-9477-4145-bb1f-1424ccb2080f",
    "timestamp": 1783204557059
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "660fda59-4222-489a-a19a-b3ae0ed7c66f",
    "timestamp": 1783204557066
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1783204557066
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "660fda59-4222-489a-a19a-b3ae0ed7c66f",
    "timestamp": 1783204557066
  },
  {
    "data": {
      "nodeType": "switch"
    },
    "event": "node_start",
    "nodeId": "44d206a7-049c-4721-8934-2308a4b67821",
    "timestamp": 1783204557069
  },
  {
    "event": "matched rule 0 -> TEXT_REPLACE",
    "nodeId": "switch",
    "timestamp": 1783204557069
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "switch"
    },
    "event": "node_end",
    "nodeId": "44d206a7-049c-4721-8934-2308a4b67821",
    "timestamp": 1783204557069
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "e21d2a42-021f-4f8e-889d-68a851e9e688",
    "timestamp": 1783204557073
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "strapi",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "create",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204557573
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "e21d2a42-021f-4f8e-889d-68a851e9e688",
    "timestamp": 1783204557573
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "d0a97b0c-1271-48e7-8587-5aae565b9d95",
    "timestamp": 1783204557580
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1783204557580
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1783204557580
  },
  {
    "data": {
      "model": "gemini-2.5-flash",
      "costUsd": 0.0014857,
      "provider": "openai",
      "latencyMs": 3553,
      "promptTokens": 19,
      "completionTokens": 592
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1783204561135
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "d0a97b0c-1271-48e7-8587-5aae565b9d95",
    "timestamp": 1783204561135
  }
]