Automated Blog Post Creator with Google Sheets

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "35731842-9215-43df-9009-9b130d663237",
    "timestamp": 1782939664699
  },
  {
    "data": {
      "kind": "n8n-nodes-base.scheduleTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1782939664699
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "35731842-9215-43df-9009-9b130d663237",
    "timestamp": 1782939664699
  },
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "4c284d44-ac46-4cdf-9dcb-727b464269a0",
    "timestamp": 1782939664701
  },
  {
    "data": {
      "initialData": {
        "sheetSchedule": "ContentCalendar"
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1782939664701
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "4c284d44-ac46-4cdf-9dcb-727b464269a0",
    "timestamp": 1782939664701
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "52a39db8-f9cc-44bb-9c3e-a9abf5821a04",
    "timestamp": 1782939664702
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1782939664702
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1782939664702
  },
  {
    "data": {
      "model": "gpt-4o-mini-2024-07-18",
      "costUsd": 0.0001075,
      "provider": "openai",
      "latencyMs": 706,
      "promptTokens": 7,
      "completionTokens": 9
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1782939665409
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "52a39db8-f9cc-44bb-9c3e-a9abf5821a04",
    "timestamp": 1782939665409
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "20e00146-6bda-4a8a-9544-bf7e5fd4e12e",
    "timestamp": 1782939665412
  },
  {
    "data": {
      "inputKeys": [
        "sheetSchedule"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1782939665412
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "20e00146-6bda-4a8a-9544-bf7e5fd4e12e",
    "timestamp": 1782939665412
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "685490c8-6b45-40c2-b4db-e97a81c4be8e",
    "timestamp": 1782939665415
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1782939665415
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 250,
      "operation": "read",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939665667
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "685490c8-6b45-40c2-b4db-e97a81c4be8e",
    "timestamp": 1782939665667
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "b63e7345-67d0-4761-8c1a-49275f34e88d",
    "timestamp": 1782939665672
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1782939665672
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 250,
      "operation": "read",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939665923
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "b63e7345-67d0-4761-8c1a-49275f34e88d",
    "timestamp": 1782939665923
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "5fed06a3-3188-4aed-8040-04e245b74e20",
    "timestamp": 1782939665923
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "5fed06a3-3188-4aed-8040-04e245b74e20",
    "timestamp": 1782939665927
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "845e419b-15ad-4548-86c5-44bda0433b71",
    "timestamp": 1782939665927
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "845e419b-15ad-4548-86c5-44bda0433b71",
    "timestamp": 1782939665929
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "1d5c2731-61a1-434c-bdf1-294217e4ac1c",
    "timestamp": 1782939665931
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1782939665931
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "1d5c2731-61a1-434c-bdf1-294217e4ac1c",
    "timestamp": 1782939665931
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "e0b982d9-d24e-4fd0-bc03-8642cd4c988b",
    "timestamp": 1782939665932
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1782939665932
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "e0b982d9-d24e-4fd0-bc03-8642cd4c988b",
    "timestamp": 1782939665932
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "6a311ac4-032b-42da-b06e-c916209d2843",
    "timestamp": 1782939665934
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1782939665934
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "6a311ac4-032b-42da-b06e-c916209d2843",
    "timestamp": 1782939665934
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "aae766a4-d29e-4357-a344-74ee36a382e1",
    "timestamp": 1782939665935
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1782939665935
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "aae766a4-d29e-4357-a344-74ee36a382e1",
    "timestamp": 1782939665935
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "a1af0f00-de59-48d4-93d2-9cc20e7f1c1c",
    "timestamp": 1782939665935
  },
  {
    "event": "execution error (simulated): Cannot read properties of undefined (reading 'replace')",
    "nodeId": "code",
    "timestamp": 1782939665937
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "code",
      "latencyMs": 0,
      "operation": "exec-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939665937
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "a1af0f00-de59-48d4-93d2-9cc20e7f1c1c",
    "timestamp": 1782939665937
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "5b4c4bdf-8997-4c19-8e95-8c84b725404c",
    "timestamp": 1782939665939
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1782939665939
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1782939665939
  },
  {
    "data": {
      "model": "gpt-4o-mini-2024-07-18",
      "costUsd": 0.0001075,
      "provider": "openai",
      "latencyMs": 727,
      "promptTokens": 7,
      "completionTokens": 9
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1782939666669
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "5b4c4bdf-8997-4c19-8e95-8c84b725404c",
    "timestamp": 1782939666669
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "8dc422a3-6b86-4f57-8c4c-df6422f72f57",
    "timestamp": 1782939666674
  },
  {
    "event": "fetching POST https:///xmlrpc.php",
    "nodeId": "http",
    "timestamp": 1782939666674
  },
  {
    "data": {
      "url": "https:///xmlrpc.php",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1782939666674
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "http",
      "latencyMs": 250,
      "operation": "fetch-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939666740
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "8dc422a3-6b86-4f57-8c4c-df6422f72f57",
    "timestamp": 1782939666740
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "db294805-df67-4266-919f-94fb0f32c593",
    "timestamp": 1782939666740
  },
  {
    "event": "execution error (simulated): $(...).itemMatching is not a function",
    "nodeId": "code",
    "timestamp": 1782939666744
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "code",
      "latencyMs": 0,
      "operation": "exec-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939666744
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "db294805-df67-4266-919f-94fb0f32c593",
    "timestamp": 1782939666744
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "00e6d2ab-6dc4-42ba-8a92-04a35d104908",
    "timestamp": 1782939666744
  },
  {
    "event": "execution error (simulated): Cannot read properties of undefined (reading 'indexOf')",
    "nodeId": "code",
    "timestamp": 1782939666747
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "code",
      "latencyMs": 0,
      "operation": "exec-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939666747
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "00e6d2ab-6dc4-42ba-8a92-04a35d104908",
    "timestamp": 1782939666748
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "45c786f0-d795-4ed4-b6d2-f005b43e797f",
    "timestamp": 1782939666750
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939667251
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "45c786f0-d795-4ed4-b6d2-f005b43e797f",
    "timestamp": 1782939667251
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "f58306f5-a5e9-4e44-9c5d-3810e18e6605",
    "timestamp": 1782939667257
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939667758
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "f58306f5-a5e9-4e44-9c5d-3810e18e6605",
    "timestamp": 1782939667758
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "e0c993c1-678f-4236-8976-735cccb49fee",
    "timestamp": 1782939667763
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "update",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939668265
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "e0c993c1-678f-4236-8976-735cccb49fee",
    "timestamp": 1782939668265
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "23212e92-4ad1-4a8c-8e0a-04d8d2a4511d",
    "timestamp": 1782939668271
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1782939668271
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "23212e92-4ad1-4a8c-8e0a-04d8d2a4511d",
    "timestamp": 1782939668271
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "6ad42453-d56b-4bae-aaf3-eb689df998cc",
    "timestamp": 1782939668276
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "update",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1782939668776
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "6ad42453-d56b-4bae-aaf3-eb689df998cc",
    "timestamp": 1782939668776
  }
]