テンプレート - ブログ生成
上級
これはContent Creation, Multimodal AI分野の自動化ワークフローで、21個のノードを含みます。主にSet, Code, Wait, Merge, HttpRequestなどのノードを使用。 Googleの自動補完とGPT-4を使ってSEO最適化されたブログ記事を作成する
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •OpenAI API Key
使用ノード (21)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "W7g7Xt2KOVfqdX6H",
"meta": {
"instanceId": "a9966e7d53853abbaaeed78ba2b9971c959f5792b2cccdff75eb461951503a7f",
"templateCredsSetupCompleted": true
},
"name": "template - Blog Generation",
"tags": [],
"nodes": [
{
"id": "c356df28-51e3-423d-aab8-706b9d3690c6",
"name": "マージ",
"type": "n8n-nodes-base.merge",
"position": [
760,
60
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "9538c50f-97f3-4dc4-a3b6-f63ed21bd11b",
"name": "アイテムをループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1260,
60
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "8ad05e8c-809a-4c02-8117-01420f55fa6b",
"name": "Google Sheetsトリガー",
"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": "付箋",
"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": "付箋1",
"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": "付箋2",
"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": "全情報",
"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": "行を読み取り",
"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": "空のステータスのみ読み取り",
"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": "広範なキーワード",
"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": "オートコンプリート",
"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": "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": "ブログ記事を生成",
"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": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-920,
560
],
"parameters": {
"width": 900,
"height": 280,
"content": "## Example Input\n\n\n"
},
"typeVersion": 1
},
{
"id": "64e00b0b-c74b-4bc1-904e-e5588c9257f2",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2420,
-260
],
"parameters": {
"width": 1020,
"height": 540,
"content": "## Example Output \n\n\n"
},
"typeVersion": 1
},
{
"id": "94bc89a2-d61f-421d-9c5d-87d0ab2b3488",
"name": "「完了」ステータスを更新",
"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": "エクスポート",
"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": "大規模バッチには待機ノードを使用",
"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": "付箋5",
"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
}
]
]
},
"c356df28-51e3-423d-aab8-706b9d3690c6": {
"main": [
[
{
"node": "d8e18fb8-a539-45e4-94e7-cc3975f21cb1",
"type": "main",
"index": 0
}
]
]
},
"3f9e78e2-1d2c-4242-9753-d57adfaa2cd9": {
"main": [
[
{
"node": "9538c50f-97f3-4dc4-a3b6-f63ed21bd11b",
"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": "c356df28-51e3-423d-aab8-706b9d3690c6",
"type": "main",
"index": 0
}
]
]
},
"befb3c85-7862-4cce-85fd-5e33c40dadcc": {
"main": [
[
{
"node": "2819cef3-19b5-43a7-b931-fda48e19ce49",
"type": "main",
"index": 0
}
]
]
},
"9538c50f-97f3-4dc4-a3b6-f63ed21bd11b": {
"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": "c356df28-51e3-423d-aab8-706b9d3690c6",
"type": "main",
"index": 1
}
]
]
},
"94bc89a2-d61f-421d-9c5d-87d0ab2b3488": {
"main": [
[
{
"node": "3f9e78e2-1d2c-4242-9753-d57adfaa2cd9",
"type": "main",
"index": 0
}
]
]
},
"8ad05e8c-809a-4c02-8117-01420f55fa6b": {
"main": [
[
{
"node": "64bd9019-b056-4ecb-b91f-60a3ec360d30",
"type": "main",
"index": 0
}
]
]
},
"d8e18fb8-a539-45e4-94e7-cc3975f21cb1": {
"main": [
[
{
"node": "9538c50f-97f3-4dc4-a3b6-f63ed21bd11b",
"type": "main",
"index": 0
}
]
]
},
"ff7793b0-ce67-4d3c-848e-d942df68a809": {
"main": [
[
{
"node": "2609db84-b19f-48aa-a656-032ce8761830",
"type": "main",
"index": 0
}
]
]
},
"2609db84-b19f-48aa-a656-032ce8761830": {
"main": [
[
{
"node": "b53e7fa6-d6fa-473f-ba37-77f088da2979",
"type": "main",
"index": 0
},
{
"node": "befb3c85-7862-4cce-85fd-5e33c40dadcc",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - コンテンツ作成, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
テンプレートHP - コンテンツスケジュール
GPT-4、Apify、Google Sheetsを使ってInstagramコンテンツの自動スケジュール生成
Set
Code
Wait
+
Set
Code
Wait
24 ノードkeisha kalra
コンテンツ作成
💥 NanoBanana、Seedream 4、ChatGPT Image、Veo 3 を使って動画広告を自動化 - VIDEO
AI（NanoBanana、Seedream、GPT-4o、Veo 3）を使って動画広告キャンペーンを自動化し公開
Set
Code
Wait
+
Set
Code
Wait
63 ノードDr. Firas
コンテンツ作成
OpenAI、RunwayML、ElevenLabsを使って無顔の短い動画を自動化
OpenAI、RunwayML、ElevenLabs を使ってアニメ顔の短い動画を自動化：スクリプトからソーシャルメディアへ
Set
Code
Wait
+
Set
Code
Wait
56 ノードLeeWei
コンテンツ作成
WordPressブログの自動化プロフェッショナル版（先端研究）v2.1マーケットプラグイン
GPT-4o、Perplexity AI、そして多言語対応を使ったSEO最適化ブログ作成の自動化
If
Set
Xml
+
If
Set
Xml
125 ノードDaniel Ng
コンテンツ作成
OpenAI、ElevenLabs、Fal.ai を使用した動画・パ odcast・ASM R向けのウイルス性コンテンツ自動作成
OpenAI、ElevenLabs、そして Fal.ai を使って動画、ポッドキャスト、ASMR に向けたウイルスのコンテンツ作成を自動化
Set
Code
Wait
+
Set
Code
Wait
97 ノードAdam Crafts
コンテンツ作成
バッチSEOコンテンツ生成とAI画像付きWebflowドラフト作成（テンプレート）
GPT、Gemini画像、Webflowデラフトで行う大量SEOコンテンツ生成
If
Set
Code
+
If
Set
Code
54 ノードDahiana
コンテンツ作成
