Automated Blog Post Creator with Google Sheets

3a518acf-cd5c-4f9b-b956-7c4cdb60c4b8

Latency
7566ms
Cost
$0.0018
Tokens
702
Status
success
gemini-3-flash-preview

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "35731842-9215-43df-9009-9b130d663237",
    "timestamp": 1783204358390
  },
  {
    "data": {
      "kind": "n8n-nodes-base.scheduleTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1783204358390
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "35731842-9215-43df-9009-9b130d663237",
    "timestamp": 1783204358390
  },
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "4c284d44-ac46-4cdf-9dcb-727b464269a0",
    "timestamp": 1783204358393
  },
  {
    "data": {
      "initialData": {
        "Key": "row_number",
        "row": {
          "Title": "Automating Workflows with n8n",
          "final": "This is the final generated content for the blog post.",
          "Action": "publish",
          "prompt": "Write a blog post about the benefits of using n8n for workflow automation. Focus on time-saving, cost reduction, and improved efficiency. Target audience: small business owners and marketing professionals. Include a call to action to try n8n.",
          "Scheduled": "2024-07-28T10:00:00Z",
          "row_number": 3,
          "takeAction": true,
          "urlWordpress": "https://your-wordpress-site.com/xmlrpc.php",
          "actionPublish": true,
          "wordpressUsername": "your_wp_username",
          "wordpressApplicationPassword": "your_wp_app_password"
        },
        "data": {
          "Title": "Automating Workflows with n8n",
          "Action": "publish",
          "Prompt": "Write a blog post about the benefits of using n8n for workflow automation. Focus on time-saving, cost reduction, and improved efficiency. Target audience: small business owners and marketing professionals. Include a call to action to try n8n.",
          "Status": "pending",
          "Scheduled": "2024-07-28T10:00:00Z",
          "row_number": 3
        },
        "Value": "3",
        "model": "gpt-4o",
        "postId": 12345,
        "sheetConfig": "Config",
        "sheetSchedule": "BlogPosts",
        "urlSpreadsheet": "https://docs.google.com/spreadsheets/d/1AbCdEfGhIjKlMnOpQrStUvWxYz0123456789AbCdEfGh"
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1783204358393
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "4c284d44-ac46-4cdf-9dcb-727b464269a0",
    "timestamp": 1783204358393
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "52a39db8-f9cc-44bb-9c3e-a9abf5821a04",
    "timestamp": 1783204358395
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1783204358395
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1783204358395
  },
  {
    "data": {
      "model": "gemini-3-flash-preview",
      "costUsd": 0.0014628,
      "provider": "openai",
      "latencyMs": 3771,
      "promptTokens": 1,
      "completionTokens": 585
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1783204362168
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "52a39db8-f9cc-44bb-9c3e-a9abf5821a04",
    "timestamp": 1783204362168
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "20e00146-6bda-4a8a-9544-bf7e5fd4e12e",
    "timestamp": 1783204362173
  },
  {
    "data": {
      "inputKeys": [
        "sheetSchedule",
        "urlSpreadsheet",
        "Key",
        "Value",
        "sheetConfig",
        "model",
        "row",
        "data",
        "postId"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1783204362173
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "20e00146-6bda-4a8a-9544-bf7e5fd4e12e",
    "timestamp": 1783204362173
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "685490c8-6b45-40c2-b4db-e97a81c4be8e",
    "timestamp": 1783204362177
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1783204362177
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 250,
      "operation": "read",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204362430
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "685490c8-6b45-40c2-b4db-e97a81c4be8e",
    "timestamp": 1783204362430
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "b63e7345-67d0-4761-8c1a-49275f34e88d",
    "timestamp": 1783204362434
  },
  {
    "data": {
      "service": "googleSheets",
      "resolved": false
    },
    "event": "credential_access",
    "nodeId": "_context",
    "timestamp": 1783204362434
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "googleSheets",
      "latencyMs": 250,
      "operation": "read",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204362687
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "b63e7345-67d0-4761-8c1a-49275f34e88d",
    "timestamp": 1783204362687
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "5fed06a3-3188-4aed-8040-04e245b74e20",
    "timestamp": 1783204362687
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "5fed06a3-3188-4aed-8040-04e245b74e20",
    "timestamp": 1783204362693
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "845e419b-15ad-4548-86c5-44bda0433b71",
    "timestamp": 1783204362693
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "845e419b-15ad-4548-86c5-44bda0433b71",
    "timestamp": 1783204362697
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "1d5c2731-61a1-434c-bdf1-294217e4ac1c",
    "timestamp": 1783204362702
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1783204362702
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "1d5c2731-61a1-434c-bdf1-294217e4ac1c",
    "timestamp": 1783204362702
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "e0b982d9-d24e-4fd0-bc03-8642cd4c988b",
    "timestamp": 1783204362705
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1783204362705
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "e0b982d9-d24e-4fd0-bc03-8642cd4c988b",
    "timestamp": 1783204362705
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "6a311ac4-032b-42da-b06e-c916209d2843",
    "timestamp": 1783204362708
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1783204362708
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "6a311ac4-032b-42da-b06e-c916209d2843",
    "timestamp": 1783204362708
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "aae766a4-d29e-4357-a344-74ee36a382e1",
    "timestamp": 1783204362711
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1783204362711
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "aae766a4-d29e-4357-a344-74ee36a382e1",
    "timestamp": 1783204362711
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "a1af0f00-de59-48d4-93d2-9cc20e7f1c1c",
    "timestamp": 1783204362711
  },
  {
    "event": "execution error (simulated): Cannot read properties of undefined (reading 'replace')",
    "nodeId": "code",
    "timestamp": 1783204362713
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "code",
      "latencyMs": 0,
      "operation": "exec-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204362713
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "a1af0f00-de59-48d4-93d2-9cc20e7f1c1c",
    "timestamp": 1783204362713
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "5b4c4bdf-8997-4c19-8e95-8c84b725404c",
    "timestamp": 1783204362716
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1783204362716
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1783204362716
  },
  {
    "data": {
      "model": "gemini-3-flash-preview",
      "costUsd": 0.0002878,
      "provider": "openai",
      "latencyMs": 1183,
      "promptTokens": 1,
      "completionTokens": 115
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1783204363900
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "5b4c4bdf-8997-4c19-8e95-8c84b725404c",
    "timestamp": 1783204363900
  },
  {
    "data": {
      "nodeType": "http"
    },
    "event": "node_start",
    "nodeId": "8dc422a3-6b86-4f57-8c4c-df6422f72f57",
    "timestamp": 1783204363906
  },
  {
    "event": "fetching POST https:///xmlrpc.php",
    "nodeId": "http",
    "timestamp": 1783204363906
  },
  {
    "data": {
      "url": "https:///xmlrpc.php",
      "method": "POST"
    },
    "event": "http_fetch",
    "nodeId": "_context",
    "timestamp": 1783204363906
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "http",
      "latencyMs": 250,
      "operation": "fetch-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204363911
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "http"
    },
    "event": "node_end",
    "nodeId": "8dc422a3-6b86-4f57-8c4c-df6422f72f57",
    "timestamp": 1783204363911
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "db294805-df67-4266-919f-94fb0f32c593",
    "timestamp": 1783204363911
  },
  {
    "event": "execution error (simulated): $(...).itemMatching is not a function",
    "nodeId": "code",
    "timestamp": 1783204363915
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "code",
      "latencyMs": 0,
      "operation": "exec-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204363915
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "db294805-df67-4266-919f-94fb0f32c593",
    "timestamp": 1783204363915
  },
  {
    "data": {
      "nodeType": "code"
    },
    "event": "node_start",
    "nodeId": "00e6d2ab-6dc4-42ba-8a92-04a35d104908",
    "timestamp": 1783204363915
  },
  {
    "event": "execution error (simulated): Cannot read properties of undefined (reading 'indexOf')",
    "nodeId": "code",
    "timestamp": 1783204363918
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "code",
      "latencyMs": 0,
      "operation": "exec-failed",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204363918
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "code"
    },
    "event": "node_end",
    "nodeId": "00e6d2ab-6dc4-42ba-8a92-04a35d104908",
    "timestamp": 1783204363918
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "45c786f0-d795-4ed4-b6d2-f005b43e797f",
    "timestamp": 1783204363922
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204364424
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "45c786f0-d795-4ed4-b6d2-f005b43e797f",
    "timestamp": 1783204364424
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "f58306f5-a5e9-4e44-9c5d-3810e18e6605",
    "timestamp": 1783204364430
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "append",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204364932
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "f58306f5-a5e9-4e44-9c5d-3810e18e6605",
    "timestamp": 1783204364932
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "e0c993c1-678f-4236-8976-735cccb49fee",
    "timestamp": 1783204364938
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "update",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204365440
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "e0c993c1-678f-4236-8976-735cccb49fee",
    "timestamp": 1783204365440
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "23212e92-4ad1-4a8c-8e0a-04d8d2a4511d",
    "timestamp": 1783204365448
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1783204365448
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "23212e92-4ad1-4a8c-8e0a-04d8d2a4511d",
    "timestamp": 1783204365448
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "6ad42453-d56b-4bae-aaf3-eb689df998cc",
    "timestamp": 1783204365453
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "googleSheets",
      "safeMode": true,
      "latencyMs": 500,
      "operation": "update",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1783204365956
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "6ad42453-d56b-4bae-aaf3-eb689df998cc",
    "timestamp": 1783204365956
  }
]