Automated Blog Post Creator with Google Sheets
8ea5d527-ef7f-49ac-add8-958b6306bb9e
Latency
3857ms
Cost
$0.0002
Tokens
32
Status
successgpt-4o-mini
Workflow Graph
Trace
[
{
"data": {
"nodeType": "trigger"
},
"event": "node_start",
"nodeId": "35731842-9215-43df-9009-9b130d663237",
"timestamp": 1783204299317
},
{
"data": {
"kind": "n8n-nodes-base.scheduleTrigger"
},
"event": "seeded",
"nodeId": "trigger",
"timestamp": 1783204299317
},
{
"data": {
"status": "ok",
"nodeType": "trigger"
},
"event": "node_end",
"nodeId": "35731842-9215-43df-9009-9b130d663237",
"timestamp": 1783204299317
},
{
"data": {
"nodeType": "manualTrigger"
},
"event": "node_start",
"nodeId": "4c284d44-ac46-4cdf-9dcb-727b464269a0",
"timestamp": 1783204299319
},
{
"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": 1783204299319
},
{
"data": {
"status": "ok",
"nodeType": "manualTrigger"
},
"event": "node_end",
"nodeId": "4c284d44-ac46-4cdf-9dcb-727b464269a0",
"timestamp": 1783204299319
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "52a39db8-f9cc-44bb-9c3e-a9abf5821a04",
"timestamp": 1783204299320
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783204299320
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783204299320
},
{
"data": {
"model": "gpt-4o-mini-2024-07-18",
"costUsd": 0.0001075,
"provider": "openai",
"latencyMs": 691,
"promptTokens": 7,
"completionTokens": 9
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1783204300014
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "52a39db8-f9cc-44bb-9c3e-a9abf5821a04",
"timestamp": 1783204300014
},
{
"data": {
"nodeType": "set"
},
"event": "node_start",
"nodeId": "20e00146-6bda-4a8a-9544-bf7e5fd4e12e",
"timestamp": 1783204300020
},
{
"data": {
"inputKeys": [
"sheetSchedule",
"urlSpreadsheet",
"Key",
"Value",
"sheetConfig",
"model",
"row",
"data",
"postId"
],
"mergeKeys": []
},
"event": "merged",
"nodeId": "set",
"timestamp": 1783204300020
},
{
"data": {
"status": "ok",
"nodeType": "set"
},
"event": "node_end",
"nodeId": "20e00146-6bda-4a8a-9544-bf7e5fd4e12e",
"timestamp": 1783204300020
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "685490c8-6b45-40c2-b4db-e97a81c4be8e",
"timestamp": 1783204300023
},
{
"data": {
"service": "googleSheets",
"resolved": false
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1783204300023
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "googleSheets",
"latencyMs": 250,
"operation": "read",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783204300275
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "685490c8-6b45-40c2-b4db-e97a81c4be8e",
"timestamp": 1783204300275
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "b63e7345-67d0-4761-8c1a-49275f34e88d",
"timestamp": 1783204300281
},
{
"data": {
"service": "googleSheets",
"resolved": false
},
"event": "credential_access",
"nodeId": "_context",
"timestamp": 1783204300281
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "googleSheets",
"latencyMs": 250,
"operation": "read",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783204300532
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "b63e7345-67d0-4761-8c1a-49275f34e88d",
"timestamp": 1783204300532
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "5fed06a3-3188-4aed-8040-04e245b74e20",
"timestamp": 1783204300533
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "5fed06a3-3188-4aed-8040-04e245b74e20",
"timestamp": 1783204300539
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "845e419b-15ad-4548-86c5-44bda0433b71",
"timestamp": 1783204300539
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "845e419b-15ad-4548-86c5-44bda0433b71",
"timestamp": 1783204300543
},
{
"data": {
"nodeType": "if"
},
"event": "node_start",
"nodeId": "1d5c2731-61a1-434c-bdf1-294217e4ac1c",
"timestamp": 1783204300545
},
{
"event": "false branch",
"nodeId": "if",
"timestamp": 1783204300545
},
{
"data": {
"status": "ok",
"nodeType": "if"
},
"event": "node_end",
"nodeId": "1d5c2731-61a1-434c-bdf1-294217e4ac1c",
"timestamp": 1783204300545
},
{
"data": {
"nodeType": "if"
},
"event": "node_start",
"nodeId": "e0b982d9-d24e-4fd0-bc03-8642cd4c988b",
"timestamp": 1783204300550
},
{
"event": "true branch",
"nodeId": "if",
"timestamp": 1783204300550
},
{
"data": {
"status": "ok",
"nodeType": "if"
},
"event": "node_end",
"nodeId": "e0b982d9-d24e-4fd0-bc03-8642cd4c988b",
"timestamp": 1783204300550
},
{
"data": {
"nodeType": "if"
},
"event": "node_start",
"nodeId": "6a311ac4-032b-42da-b06e-c916209d2843",
"timestamp": 1783204300552
},
{
"event": "false branch",
"nodeId": "if",
"timestamp": 1783204300552
},
{
"data": {
"status": "ok",
"nodeType": "if"
},
"event": "node_end",
"nodeId": "6a311ac4-032b-42da-b06e-c916209d2843",
"timestamp": 1783204300552
},
{
"data": {
"nodeType": "if"
},
"event": "node_start",
"nodeId": "aae766a4-d29e-4357-a344-74ee36a382e1",
"timestamp": 1783204300554
},
{
"event": "true branch",
"nodeId": "if",
"timestamp": 1783204300554
},
{
"data": {
"status": "ok",
"nodeType": "if"
},
"event": "node_end",
"nodeId": "aae766a4-d29e-4357-a344-74ee36a382e1",
"timestamp": 1783204300554
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "a1af0f00-de59-48d4-93d2-9cc20e7f1c1c",
"timestamp": 1783204300554
},
{
"event": "execution error (simulated): Cannot read properties of undefined (reading 'replace')",
"nodeId": "code",
"timestamp": 1783204300557
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "exec-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783204300557
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "a1af0f00-de59-48d4-93d2-9cc20e7f1c1c",
"timestamp": 1783204300557
},
{
"data": {
"nodeType": "llm"
},
"event": "node_start",
"nodeId": "5b4c4bdf-8997-4c19-8e95-8c84b725404c",
"timestamp": 1783204300559
},
{
"data": {
"messages": 1,
"maxTokens": 1024
},
"event": "calling openai/gpt-4o-mini",
"nodeId": "llm",
"timestamp": 1783204300559
},
{
"data": {
"model": "gpt-4o-mini",
"provider": "openai"
},
"event": "llm_call",
"nodeId": "_context",
"timestamp": 1783204300559
},
{
"data": {
"model": "gpt-4o-mini-2024-07-18",
"costUsd": 0.0001075,
"provider": "openai",
"latencyMs": 550,
"promptTokens": 7,
"completionTokens": 9
},
"event": "llm_result",
"nodeId": "_context",
"timestamp": 1783204301121
},
{
"data": {
"status": "ok",
"nodeType": "llm"
},
"event": "node_end",
"nodeId": "5b4c4bdf-8997-4c19-8e95-8c84b725404c",
"timestamp": 1783204301121
},
{
"data": {
"nodeType": "http"
},
"event": "node_start",
"nodeId": "8dc422a3-6b86-4f57-8c4c-df6422f72f57",
"timestamp": 1783204301126
},
{
"event": "fetching POST https:///xmlrpc.php",
"nodeId": "http",
"timestamp": 1783204301126
},
{
"data": {
"url": "https:///xmlrpc.php",
"method": "POST"
},
"event": "http_fetch",
"nodeId": "_context",
"timestamp": 1783204301126
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "http",
"latencyMs": 250,
"operation": "fetch-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783204301130
},
{
"data": {
"status": "ok",
"nodeType": "http"
},
"event": "node_end",
"nodeId": "8dc422a3-6b86-4f57-8c4c-df6422f72f57",
"timestamp": 1783204301130
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "db294805-df67-4266-919f-94fb0f32c593",
"timestamp": 1783204301130
},
{
"event": "execution error (simulated): $(...).itemMatching is not a function",
"nodeId": "code",
"timestamp": 1783204301133
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "exec-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783204301133
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "db294805-df67-4266-919f-94fb0f32c593",
"timestamp": 1783204301134
},
{
"data": {
"nodeType": "code"
},
"event": "node_start",
"nodeId": "00e6d2ab-6dc4-42ba-8a92-04a35d104908",
"timestamp": 1783204301134
},
{
"event": "execution error (simulated): Cannot read properties of undefined (reading 'indexOf')",
"nodeId": "code",
"timestamp": 1783204301137
},
{
"data": {
"mode": "read",
"status": "ok",
"service": "code",
"latencyMs": 0,
"operation": "exec-failed",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783204301137
},
{
"data": {
"status": "ok",
"nodeType": "code"
},
"event": "node_end",
"nodeId": "00e6d2ab-6dc4-42ba-8a92-04a35d104908",
"timestamp": 1783204301137
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "45c786f0-d795-4ed4-b6d2-f005b43e797f",
"timestamp": 1783204301140
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "googleSheets",
"safeMode": true,
"latencyMs": 500,
"operation": "append",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783204301643
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "45c786f0-d795-4ed4-b6d2-f005b43e797f",
"timestamp": 1783204301643
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "f58306f5-a5e9-4e44-9c5d-3810e18e6605",
"timestamp": 1783204301652
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "googleSheets",
"safeMode": true,
"latencyMs": 500,
"operation": "append",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783204302154
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "f58306f5-a5e9-4e44-9c5d-3810e18e6605",
"timestamp": 1783204302154
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "e0c993c1-678f-4236-8976-735cccb49fee",
"timestamp": 1783204302160
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "googleSheets",
"safeMode": true,
"latencyMs": 500,
"operation": "update",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783204302662
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "e0c993c1-678f-4236-8976-735cccb49fee",
"timestamp": 1783204302662
},
{
"data": {
"nodeType": "if"
},
"event": "node_start",
"nodeId": "23212e92-4ad1-4a8c-8e0a-04d8d2a4511d",
"timestamp": 1783204302667
},
{
"event": "false branch",
"nodeId": "if",
"timestamp": 1783204302668
},
{
"data": {
"status": "ok",
"nodeType": "if"
},
"event": "node_end",
"nodeId": "23212e92-4ad1-4a8c-8e0a-04d8d2a4511d",
"timestamp": 1783204302668
},
{
"data": {
"nodeType": "integration"
},
"event": "node_start",
"nodeId": "6ad42453-d56b-4bae-aaf3-eb689df998cc",
"timestamp": 1783204302672
},
{
"data": {
"mode": "write",
"status": "ok",
"service": "googleSheets",
"safeMode": true,
"latencyMs": 500,
"operation": "update",
"simulated": true
},
"event": "integration_mocked",
"nodeId": "integration",
"timestamp": 1783204303174
},
{
"data": {
"status": "ok",
"nodeType": "integration"
},
"event": "node_end",
"nodeId": "6ad42453-d56b-4bae-aaf3-eb689df998cc",
"timestamp": 1783204303174
}
]