Automated Blog Post Creator with Google Sheets

8cf81eae-7dc2-4cdc-aa9e-c143e755c5dc

Latency
12165ms
Cost
$0.0036
Tokens
1,452
Status
partial
gemini-3-flash-preview

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "35731842-9215-43df-9009-9b130d663237",
    "timestamp": 1780643155263
  },
  {
    "data": {
      "kind": "n8n-nodes-base.scheduleTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780643155263
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "35731842-9215-43df-9009-9b130d663237",
    "timestamp": 1780643155263
  },
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "4c284d44-ac46-4cdf-9dcb-727b464269a0",
    "timestamp": 1780643155267
  },
  {
    "data": {
      "initialData": {
        "sheetSchedule": "ContentCalendar"
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1780643155267
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "4c284d44-ac46-4cdf-9dcb-727b464269a0",
    "timestamp": 1780643155267
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "52a39db8-f9cc-44bb-9c3e-a9abf5821a04",
    "timestamp": 1780643155270
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780643155270
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780643155270
  },
  {
    "data": {
      "model": "gemini-3-flash-preview",
      "costUsd": 0.0022053000000000003,
      "provider": "openai",
      "latencyMs": 6453,
      "promptTokens": 1,
      "completionTokens": 882
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780643161724
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "52a39db8-f9cc-44bb-9c3e-a9abf5821a04",
    "timestamp": 1780643161724
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "20e00146-6bda-4a8a-9544-bf7e5fd4e12e",
    "timestamp": 1780643161728
  },
  {
    "data": {
      "inputKeys": [
        "sheetSchedule"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780643161728
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "20e00146-6bda-4a8a-9544-bf7e5fd4e12e",
    "timestamp": 1780643161728
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "685490c8-6b45-40c2-b4db-e97a81c4be8e",
    "timestamp": 1780643161731
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780643161731
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780643161731
  },
  {
    "data": {
      "status": 200
    },
    "event": "sheets.read",
    "nodeId": "integration",
    "timestamp": 1780643162037
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 306,
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780643162037
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "685490c8-6b45-40c2-b4db-e97a81c4be8e",
    "timestamp": 1780643162037
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "b63e7345-67d0-4761-8c1a-49275f34e88d",
    "timestamp": 1780643162041
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780643162041
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/A1%3AZ100",
      "method": "GET"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780643162041
  },
  {
    "data": {
      "status": 200
    },
    "event": "sheets.read",
    "nodeId": "integration",
    "timestamp": 1780643162222
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 181,
      "operation": "read"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780643162222
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "b63e7345-67d0-4761-8c1a-49275f34e88d",
    "timestamp": 1780643162222
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "5fed06a3-3188-4aed-8040-04e245b74e20",
    "timestamp": 1780643162222
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "5fed06a3-3188-4aed-8040-04e245b74e20",
    "timestamp": 1780643162226
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "845e419b-15ad-4548-86c5-44bda0433b71",
    "timestamp": 1780643162226
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "845e419b-15ad-4548-86c5-44bda0433b71",
    "timestamp": 1780643162230
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "1d5c2731-61a1-434c-bdf1-294217e4ac1c",
    "timestamp": 1780643162234
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1780643162234
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "1d5c2731-61a1-434c-bdf1-294217e4ac1c",
    "timestamp": 1780643162234
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "e0b982d9-d24e-4fd0-bc03-8642cd4c988b",
    "timestamp": 1780643162236
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1780643162237
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "e0b982d9-d24e-4fd0-bc03-8642cd4c988b",
    "timestamp": 1780643162237
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "6a311ac4-032b-42da-b06e-c916209d2843",
    "timestamp": 1780643162239
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1780643162239
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "6a311ac4-032b-42da-b06e-c916209d2843",
    "timestamp": 1780643162239
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "aae766a4-d29e-4357-a344-74ee36a382e1",
    "timestamp": 1780643162241
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1780643162241
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "aae766a4-d29e-4357-a344-74ee36a382e1",
    "timestamp": 1780643162241
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "a1af0f00-de59-48d4-93d2-9cc20e7f1c1c",
    "timestamp": 1780643162241
  },
  {
    "event": "execution error: Cannot read properties of undefined (reading 'replace')",
    "nodeId": "code",
    "timestamp": 1780643162244
  },
  {
    "data": {
      "error": "Code node execution failed: Cannot read properties of undefined (reading 'replace')",
      "status": "error",
      "degraded": true,
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "a1af0f00-de59-48d4-93d2-9cc20e7f1c1c",
    "timestamp": 1780643162245
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "5b4c4bdf-8997-4c19-8e95-8c84b725404c",
    "timestamp": 1780643162247
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780643162247
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780643162247
  },
  {
    "data": {
      "model": "gemini-3-flash-preview",
      "costUsd": 0.0014203,
      "provider": "openai",
      "latencyMs": 4164,
      "promptTokens": 1,
      "completionTokens": 568
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780643166412
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "5b4c4bdf-8997-4c19-8e95-8c84b725404c",
    "timestamp": 1780643166412
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "8dc422a3-6b86-4f57-8c4c-df6422f72f57",
    "timestamp": 1780643166418
  },
  {
    "event": "fetching POST https:///xmlrpc.php",
    "nodeId": "http",
    "timestamp": 1780643166418
  },
  {
    "data": {
      "url": "https:///xmlrpc.php",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780643166418
  },
  {
    "data": {
      "error": "fetch failed",
      "status": "error",
      "degraded": true,
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "8dc422a3-6b86-4f57-8c4c-df6422f72f57",
    "timestamp": 1780643166486
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "db294805-df67-4266-919f-94fb0f32c593",
    "timestamp": 1780643166486
  },
  {
    "event": "execution error: $(...).itemMatching is not a function",
    "nodeId": "code",
    "timestamp": 1780643166490
  },
  {
    "data": {
      "error": "Code node execution failed: $(...).itemMatching is not a function",
      "status": "error",
      "degraded": true,
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "db294805-df67-4266-919f-94fb0f32c593",
    "timestamp": 1780643166491
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "00e6d2ab-6dc4-42ba-8a92-04a35d104908",
    "timestamp": 1780643166491
  },
  {
    "event": "execution error: Cannot read properties of undefined (reading 'indexOf')",
    "nodeId": "code",
    "timestamp": 1780643166494
  },
  {
    "data": {
      "error": "Code node execution failed: Cannot read properties of undefined (reading 'indexOf')",
      "status": "error",
      "degraded": true,
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "00e6d2ab-6dc4-42ba-8a92-04a35d104908",
    "timestamp": 1780643166495
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "45c786f0-d795-4ed4-b6d2-f005b43e797f",
    "timestamp": 1780643166498
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780643166498
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/Sink:append?valueInputOption=RAW",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780643166498
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780643166836
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 338,
      "operation": "append"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780643166836
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "45c786f0-d795-4ed4-b6d2-f005b43e797f",
    "timestamp": 1780643166836
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "f58306f5-a5e9-4e44-9c5d-3810e18e6605",
    "timestamp": 1780643166841
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780643166841
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/Sink:append?valueInputOption=RAW",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780643166841
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780643167036
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 195,
      "operation": "append"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780643167036
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "f58306f5-a5e9-4e44-9c5d-3810e18e6605",
    "timestamp": 1780643167036
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "e0c993c1-678f-4236-8976-735cccb49fee",
    "timestamp": 1780643167040
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780643167040
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/Sink:append?valueInputOption=RAW",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780643167040
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780643167222
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 182,
      "operation": "update"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780643167222
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "e0c993c1-678f-4236-8976-735cccb49fee",
    "timestamp": 1780643167222
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "23212e92-4ad1-4a8c-8e0a-04d8d2a4511d",
    "timestamp": 1780643167229
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1780643167229
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "23212e92-4ad1-4a8c-8e0a-04d8d2a4511d",
    "timestamp": 1780643167229
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "6ad42453-d56b-4bae-aaf3-eb689df998cc",
    "timestamp": 1780643167235
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": true
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1780643167235
  },
  {
    "data": {
      "url": "https://sheets.googleapis.com/v4/spreadsheets/1e8XpVw-np2ABv8gBd_VYhphaHZUYnJ5zoOa--qocbPE/values/Sink:append?valueInputOption=RAW",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1780643167235
  },
  {
    "data": {
      "tab": "Sink",
      "status": 200
    },
    "event": "sheets.write",
    "nodeId": "integration",
    "timestamp": 1780643167428
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 193,
      "operation": "update"
    },
    "event": "integration_call",
    "nodeId": "integration",
    "timestamp": 1780643167428
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "6ad42453-d56b-4bae-aaf3-eb689df998cc",
    "timestamp": 1780643167428
  }
]