Vorlage - Blog-Erstellung

• •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
• •Google Sheets API-Anmeldedaten
• •OpenAI API Key

{
  "id": "W7g7Xt2KOVfqdX6H",
  "meta": {
    "instanceId": "a9966e7d53853abbaaeed78ba2b9971c959f5792b2cccdff75eb461951503a7f",
    "templateCredsSetupCompleted": true
  },
  "name": "template - Blog Generation",
  "tags": [],
  "nodes": [
    {
      "id": "c356df28-51e3-423d-aab8-706b9d3690c6",
      "name": "Zusammenführen",
      "type": "n8n-nodes-base.merge",
      "position": [
        760,
        60
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "9538c50f-97f3-4dc4-a3b6-f63ed21bd11b",
      "name": "Über Elemente schleifen",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1260,
        60
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "8ad05e8c-809a-4c02-8117-01420f55fa6b",
      "name": "Google Tabellen Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -860,
        40
      ],
      "parameters": {
        "event": "rowAdded",
        "options": {},
        "pollTimes": {
          "item": [
            {}
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "",
          "cachedResultName": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "TrzvQZYVopztSMKU",
          "name": "Google Sheets Trigger account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e869dfee-73a3-4d94-8b19-f210d04a0b91",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -920,
        -260
      ],
      "parameters": {
        "width": 880,
        "height": 760,
        "content": "## Entering the Data\n\nThis workflow is currently triggered whenever a new row is added to this Google Sheets. Then, it reads the rows and only moves forward for those without a \"done\" in the status column."
      },
      "typeVersion": 1
    },
    {
      "id": "833d877e-f935-4648-b69f-55e5e29c8973",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        -260
      ],
      "parameters": {
        "width": 1120,
        "height": 760,
        "content": "## Google Autocomplete and PAA\nGoogle Autocomplete is a feature that predicts a user’s search query as they type. In this workflow, the Autocomplete actor uses dynamic input: since the actor is triggered via a POST request, it pulls whatever content is currently in the \"Broad Words\" node at runtime. This node extracts general topic keywords from the \"Inspiration\" column in the Google Sheet, making it easier to generate relevant Autocomplete and PAA results.\n\nPAA (People Also Ask) is another Google feature that shows related questions and answers based on the original search query. These results are retrieved using SerpAPI.\n\nOnce both Autocomplete and PAA data are collected, they are merged and sent to ChatGPT for further analysis and content generation."
      },
      "typeVersion": 1
    },
    {
      "id": "9c141382-e315-4f01-bc5b-6e2c189b5506",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1220,
        -260
      ],
      "parameters": {
        "width": 1140,
        "height": 740,
        "content": "## ChatGPT-4 and Export\n\nThis \"Loop Over Items\" takes each input and, one at a time, puts it into ChatGPT which then generates a blog post based on the Autocomplete, PAA results, and Blog Inspiration Topic. Lastly, it is exported to Google Sheets and the status column is updated to \"done\". "
      },
      "typeVersion": 1
    },
    {
      "id": "d8e18fb8-a539-45e4-94e7-cc3975f21cb1",
      "name": "All of the Information",
      "type": "n8n-nodes-base.code",
      "position": [
        980,
        60
      ],
      "parameters": {
        "jsCode": "const autocompleteItems = $items(\"Autocomplete\");\nconst paaItems = $items(\"Format PAA (SerpAPI)\");\nconst topicItems = $items(\"Broad Words\");\n\nconst output = [];\n\nfunction normalize(str) {\n  return (str || \"\").toLowerCase().trim();\n}\n\nfor (let i = 0; i < topicItems.length; i++) {\n  const topicRaw = topicItems[i].json[\"Blog Inspiration\"] || \"Unknown Topic\";\n  const topic = topicRaw.trim();\n\n  // Normalize for matching\n  const normTopic = normalize(topic);\n\n  // Get autocomplete suggestions\n  const autocomplete = autocompleteItems[i]?.json?.autocomplete || [];\n\n  // Get PAA from autocomplete\n  const paaFromAutocomplete = autocompleteItems[i]?.json?.paa || [];\n\n  // Match SerpAPI result by normalized topic\n  const matchingPAAObj = paaItems.find(p => normalize(p.json.topic) === normTopic);\n  const paaFromSerpAPI = matchingPAAObj?.json?.paa || [];\n\n  // Merge + clean\n  const allPAA = [...paaFromAutocomplete, ...paaFromSerpAPI].filter(\n    q => q && typeof q === \"string\" && !q.toLowerCase().includes(\"no paa\")\n  );\n\n  output.push({\n    json: {\n      topic,\n      autocomplete,\n      paa: allPAA.length ? allPAA : undefined\n    }\n  });\n}\n\nreturn output;\n"
      },
      "typeVersion": 2
    },
    {
      "id": "64bd9019-b056-4ecb-b91f-60a3ec360d30",
      "name": "Read Rows",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -640,
        40
      ],
      "parameters": {
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Fujtlc6eM7k9s5AV",
          "name": "Google Sheets account 3"
        }
      },
      "executeOnce": true,
      "typeVersion": 4.5
    },
    {
      "id": "ff7793b0-ce67-4d3c-848e-d942df68a809",
      "name": "Only Reads Empty Status",
      "type": "n8n-nodes-base.code",
      "position": [
        -420,
        40
      ],
      "parameters": {
        "jsCode": "return items.filter(item => {\n  const status = item.json.Status?.trim();\n  return !status || status === \"\";\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "b53e7fa6-d6fa-473f-ba37-77f088da2979",
      "name": "Broad Words",
      "type": "n8n-nodes-base.code",
      "position": [
        160,
        -40
      ],
      "parameters": {
        "jsCode": "return items.map(item => {\n  const inspiration = item.json[\"Blog Inspiration\"];\n  // Simplify to just the last 3 words or a fallback keyword\n  const words = inspiration.split(\" \");\n  const shortTopic = words.slice(-3).join(\" \");\n  item.json.topic = shortTopic || \"photo ideas\";\n  return item;\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "befb3c85-7862-4cce-85fd-5e33c40dadcc",
      "name": "PAA (SerpAPI)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        160,
        220
      ],
      "parameters": {
        "url": "https://serpapi.com/search",
        "options": {},
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "q",
              "value": "={{ $('Only Reads Empty Status').item.json['Blog Inspiration'] }}"
            },
            {
              "name": "api_key"
            },
            {
              "name": "engine",
              "value": "google"
            },
            {
              "name": "hl",
              "value": "en"
            },
            {
              "name": "google_domain",
              "value": "google.com"
            },
            {
              "name": "device",
              "value": "desktop"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "bedcb5a4-10cb-43b3-a885-6d0f7e51691c",
      "name": "Autocomplete",
      "type": "n8n-nodes-base.httpRequest",
      "maxTries": 5,
      "position": [
        460,
        -40
      ],
      "parameters": {
        "url": "https://seo-api2.onrender.com/get-seo-data",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "topic",
              "value": "={{ $json.topic }}"
            }
          ]
        }
      },
      "retryOnFail": true,
      "typeVersion": 4.2,
      "waitBetweenTries": 5000
    },
    {
      "id": "2819cef3-19b5-43a7-b931-fda48e19ce49",
      "name": "Format PAA (SerpAPI)",
      "type": "n8n-nodes-base.code",
      "position": [
        480,
        220
      ],
      "parameters": {
        "jsCode": "const formatted = [];\n\nfor (const item of items) {\n  const data = item.json;\n  const query = data.search_information?.query_displayed || \"Unknown query\";\n\n  const paaList = [];\n\n  // ✅ PRIORITY 1: related_questions (People Also Ask)\n  if (Array.isArray(data.related_questions)) {\n    for (const q of data.related_questions) {\n      if (q.question && q.snippet) {\n        paaList.push(`(PAA) ${q.question} — ${q.snippet}`);\n      } else if (q.question) {\n        paaList.push(`(PAA) ${q.question}`);\n      }\n    }\n  }\n\n  // 🔄 FALLBACK 1: organic_results\n  if (paaList.length === 0 && Array.isArray(data.organic_results)) {\n    for (const result of data.organic_results) {\n      if (result.title && result.snippet) {\n        paaList.push(`(Organic) ${result.title} — ${result.snippet}`);\n      }\n    }\n  }\n\n  // 🔄 FALLBACK 2: answer_box\n  if (paaList.length === 0 && data.answer_box?.title && data.answer_box?.snippet) {\n    paaList.push(`(Answer Box) ${data.answer_box.title} — ${data.answer_box.snippet}`);\n  }\n\n  // 🔄 FALLBACK 3: related_searches\n  if (paaList.length === 0 && Array.isArray(data.related_searches)) {\n    for (const rel of data.related_searches) {\n      if (rel.query) {\n        paaList.push(`(Related Search) ${rel.query}`);\n      }\n    }\n  }\n\n  formatted.push({\n    json: {\n      topic: query,\n      paa: paaList.length > 0 ? paaList : null\n    }\n  });\n}\n\nreturn formatted;\n"
      },
      "typeVersion": 2
    },
    {
      "id": "264916e1-9d3e-4db6-9938-cb24615da143",
      "name": "Generate Blog Post",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1540,
        80
      ],
      "parameters": {
        "text": "=Write a blog post based on the following topic:\n{{ $json.topic }}\n\nYour audience is ___. The tone should feel warm, personal, emotionally resonant, and elegant.\n\nUse the following to guide the content:\n\nAutocomplete keywords:\n{{ $json.autocomplete }}\nWeave these naturally into the blog — not as a list. Use them to inspire talking points, not as SEO stuffing.\n\nPeople Also Ask questions, Organic Results, or Related Searches:\n{{ $json.paa }}\nReference or gently answer these questions where they align with the topic.\n\nContent Guidelines:\n\nGenerate a warm, SEO-optimized blog title that includes relevant keywords and reflects the post’s focus. Do not use clickbait or vague titles.\n\nStart with a warm, seasonal, or situational hook\n\nOffer client-relevant insights (e.g., wardrobe planning, session timing, location ideas, lifestyle reflections)\n\nUse clear, specific language — avoid filler, clichés, metaphors, or flowery phrasing\n\nAvoid headings unless they add structure\n\nKeep it narrative and around 500 words\n\nEnd with a gentle call-to-action (e.g., inviting readers to reach out with outfit questions, booking ideas, or planning support)\n\n",
        "options": {
          "systemMessage": ""
        },
        "promptType": "define"
      },
      "typeVersion": 1.8
    },
    {
      "id": "8a42f3e0-dee2-4b68-970d-771e1f5a4397",
      "name": "GPT-4",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1520,
        280
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o",
          "cachedResultName": "gpt-4o"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "niPVUMBH1mYOAFdj",
          "name": "OpenAi account 3"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "cf4bb6ec-8f18-465f-854a-f2354386a02a",
      "name": "Haftnotiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -920,
        560
      ],
      "parameters": {
        "width": 900,
        "height": 280,
        "content": "## Example Input\n\n![Result preview](https://i.imgur.com/QcsHM85.png)\n"
      },
      "typeVersion": 1
    },
    {
      "id": "64e00b0b-c74b-4bc1-904e-e5588c9257f2",
      "name": "Haftnotiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2420,
        -260
      ],
      "parameters": {
        "width": 1020,
        "height": 540,
        "content": "## Example Output \n\n![Another preview](https://i.imgur.com/8Kt4EOL.png)\n"
      },
      "typeVersion": 1
    },
    {
      "id": "94bc89a2-d61f-421d-9c5d-87d0ab2b3488",
      "name": "Update \"Done\" Status",
      "type": "n8n-nodes-base.set",
      "position": [
        1900,
        80
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "c99cfee7-74c6-46bf-9da8-97fa73cbfac4",
              "name": "Blog Draft ",
              "type": "string",
              "value": "={{ $json.output }}"
            },
            {
              "id": "acf40ab4-bbe1-4d5f-b3dc-5ac4320c0ff8",
              "name": "Blog Inspiration",
              "type": "string",
              "value": "={{ $('Loop Over Items').item.json.topic }}"
            },
            {
              "id": "2dbbac0b-8b55-4cae-a8d3-6857bb7f8b30",
              "name": "Status",
              "type": "string",
              "value": "done"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "3f9e78e2-1d2c-4242-9753-d57adfaa2cd9",
      "name": "Export",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2140,
        80
      ],
      "parameters": {
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Fujtlc6eM7k9s5AV",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "2609db84-b19f-48aa-a656-032ce8761830",
      "name": "Use Warten Node for Large Batches",
      "type": "n8n-nodes-base.wait",
      "position": [
        -180,
        40
      ],
      "webhookId": "a129fe57-aa57-4929-b88c-b0aa170e22a4",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "6eaa572d-ebbf-4f3a-8805-e549c49db795",
      "name": "Haftnotiz5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1700,
        -260
      ],
      "parameters": {
        "width": 680,
        "height": 1220,
        "content": "## Try It Out!\n\nThis n8n template helps you create SEO-optimized Blog Posts for your businesses website or for personal use.\n\nWhether you're managing a business or helping local restaurants improve their digital presence, this workflow helps you build SEO-Optimized Blog Posts in seconds using Google Autocomplete and People Also Ask (SerpAPI). \n\nWho Is It For? \n- This is helpful for people looking to SEO Optimize either another person's website or their own. \n\nHow It Works?\n- You start with a list of blog inspirations in Google Sheets (e.g., “Best Photo Session Spots”).\n- The workflow only processes rows where the “Status” column is not marked as “done”, though you can remove this condition if you’d like to process all rows each time. \n- The workflow pulls Google Autocomplete suggestions and PAA questions using: A custom-built SEO API I deployed via Render (for Google Autocomplete + PAA), SerpAPI (for additional PAA data). \n- These search insights are merged. For example, if your blog idea is “Photo Session Spots,” the workflow gathers related Google search phrases and questions users are asking.\n- Then, GPT-4 is used to draft a full blog post based on this data.\n- The finished post is saved back into your Google Sheet.\n\nHow To Use\n- Fill out the “Blog Inspiration” column in your Google Sheet with the topics you want to write about.\n- Update the OpenAI prompt in the ChatGPT node to match your tone or writing style. (Tip: Add a system prompt with context about your business or audience.)\n- You can trigger this manually, or replace it with a cron schedule, webhook, or other event.\n\nRequirements\n- A SerpAPI account to get PAA\n- An OpenAI account for ChatGPT\n- Access to Google Sheets and n8n\n\nHow To Set-Up? \n- Your Google Sheet should have three columns: \"Blog Inspiration\", \"Status\" → set this to “done” when a post has been generated, \"Blog Draft\" → this is automatically filled by the workflow. \n\n- To use the SerpAPI HTTP Request node: 1. Drag in an HTTP Request node, 2. Set the Method and URL depending on how you're using SerpAPI: Use POST to run the actor live on each request. Use GET to fetch from a static dataset (cheaper if reusing the same data). 3. Add query parameters for your SerpAPI key and input values. 4. Test the node.\nRefer to this n8n documentation for more help! https://docs.n8n.io/integrations/builtin/cluster-nodes/sub-nodes/n8n-nodes-langchain.toolserpapi/.\n \n- The “Autocomplete” node connects to a custom web service I built and deployed using Render. I wrote a Python script (hosted on GitHub) that pulls live Google Autocomplete suggestions and PAA questions based on any topic you send. This script was turned into an API and deployed as a public web service via Render. Anyone can use it by sending a POST request to: https://seo-api2.onrender.com/get-seo-data (the URL is already in the node). Since this is hosted on Render’s free tier, if the service hasn’t been used in the past ~15 minutes, it may “go to sleep.” When that happens, the first request can take 10–30 seconds to respond while it wakes up.\n\n\nHappy Automating! "
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "54400ae2-8bf3-4dcc-991d-b44832948053",
  "connections": {
    "8a42f3e0-dee2-4b68-970d-771e1f5a4397": {
      "ai_languageModel": [
        [
          {
            "node": "264916e1-9d3e-4db6-9938-cb24615da143",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "d8e18fb8-a539-45e4-94e7-cc3975f21cb1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3f9e78e2-1d2c-4242-9753-d57adfaa2cd9": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "64bd9019-b056-4ecb-b91f-60a3ec360d30": {
      "main": [
        [
          {
            "node": "ff7793b0-ce67-4d3c-848e-d942df68a809",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b53e7fa6-d6fa-473f-ba37-77f088da2979": {
      "main": [
        [
          {
            "node": "bedcb5a4-10cb-43b3-a885-6d0f7e51691c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bedcb5a4-10cb-43b3-a885-6d0f7e51691c": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "befb3c85-7862-4cce-85fd-5e33c40dadcc": {
      "main": [
        [
          {
            "node": "2819cef3-19b5-43a7-b931-fda48e19ce49",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "264916e1-9d3e-4db6-9938-cb24615da143",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "264916e1-9d3e-4db6-9938-cb24615da143": {
      "main": [
        [
          {
            "node": "94bc89a2-d61f-421d-9c5d-87d0ab2b3488",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2819cef3-19b5-43a7-b931-fda48e19ce49": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "94bc89a2-d61f-421d-9c5d-87d0ab2b3488": {
      "main": [
        [
          {
            "node": "3f9e78e2-1d2c-4242-9753-d57adfaa2cd9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "64bd9019-b056-4ecb-b91f-60a3ec360d30",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d8e18fb8-a539-45e4-94e7-cc3975f21cb1": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ff7793b0-ce67-4d3c-848e-d942df68a809": {
      "main": [
        [
          {
            "node": "Use Wait Node for Large Batches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Use Wait Node for Large Batches": {
      "main": [
        [
          {
            "node": "b53e7fa6-d6fa-473f-ba37-77f088da2979",
            "type": "main",
            "index": 0
          },
          {
            "node": "befb3c85-7862-4cce-85fd-5e33c40dadcc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}