記事構造の分析で主要出力を生成

• •ターゲットAPIの認証情報が必要な場合あり
• •Google Sheets API認証情報
• •Google Drive API認証情報

{
  "id": "XbA6Q2NrTmh3RvvK",
  "meta": {
    "instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
    "templateCredsSetupCompleted": true
  },
  "name": "Lead Magnet Generation",
  "tags": [],
  "nodes": [
    {
      "id": "0e3082c1-cb3d-4b6e-9367-c3da75a02da5",
      "name": "HTTP リクエスト",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1060,
        160
      ],
      "parameters": {
        "url": "https://lead-magnet-idea-generator-ai.p.rapidapi.com/index.php",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "contentType": "multipart-form-data",
        "sendHeaders": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "topic",
              "value": "={{ $json.Topic }}"
            },
            {
              "name": "website",
              "value": "={{ $json['Website Url'] }}"
            }
          ]
        },
        "headerParameters": {
          "parameters": [
            {
              "name": "x-rapidapi-host",
              "value": "lead-magnet-idea-generator-ai.p.rapidapi.com"
            },
            {
              "name": "x-rapidapi-key"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "5dd91b00-0670-430f-aeed-365cee02225b",
      "name": "ループ処理",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        480,
        0
      ],
      "parameters": {
        "options": {
          "reset": false
        }
      },
      "typeVersion": 3
    },
    {
      "id": "2e99095a-b29f-428c-990d-b6fffd40adcb",
      "name": "待機",
      "type": "n8n-nodes-base.wait",
      "position": [
        1640,
        140
      ],
      "webhookId": "74ac1ccb-f843-41b8-97c4-b8d32892a5ea",
      "parameters": {
        "amount": 10
      },
      "typeVersion": 1.1
    },
    {
      "id": "952b9061-9f2c-41b4-9f0a-1567160f3540",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        800,
        20
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "e0b7b7c8-3a7a-466d-bae7-269282b49d34",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Topic }}",
              "rightValue": ""
            },
            {
              "id": "64dde394-0e49-4306-a24a-de2bf448fc95",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Content }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "9a000b36-5933-4891-9b1d-e31ef6092ed8",
      "name": "Google スプレッドシート1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        180,
        0
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": ""
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "qUtlCnYpk7bXXaYp",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "64b72bb3-a25a-4cc7-843a-79f25486afd8",
      "name": "Google ドライブ Trigger",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        -80,
        0
      ],
      "parameters": {
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "triggerOn": "specificFile",
        "fileToWatch": {
          "__rl": true,
          "mode": "url",
          "value": ""
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "qUtlCnYpk7bXXaYp",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2d1d2710-ea6a-4953-bdd7-8f6341177066",
      "name": "Google スプレッドシート2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1360,
        140
      ],
      "parameters": {
        "columns": {
          "value": {
            "Topic": "={{ $('If').item.json.Topic }}",
            "Content": "={{ $json.data }}",
            "Website Url": "={{ $('If').item.json['Website Url'] }}",
            "Generated Date": "={{ new Date().toLocaleString() }}"
          },
          "schema": [
            {
              "id": "Topic",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Topic",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Website Url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Website Url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Content",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Content",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Generated Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Generated Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Topic"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": ""
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "qUtlCnYpk7bXXaYp",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "831e52d3-07f3-4f33-b820-9e33b13d5506",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        -480
      ],
      "parameters": {
        "width": 660,
        "height": 940,
        "content": "# 🚀 Lead Magnet Idea Generation Workflow\n\n## 🧩 Purpose\nAutomatically generates **lead magnet content ideas** based on a Google Sheet containing topics and website URLs. It checks for rows where content is missing and fills it using an AI API.\n\n---\n\n## ✅ Problem Solved\n\n| ❌ Problem                            | ✅ Solution                                                                 |\n|--------------------------------------|-----------------------------------------------------------------------------|\n| Manual content idea generation       | Automatically generates using a Lead Magnet AI API                          |\n| Missing content in sheet rows        | Detects missing \"Content\" and fills it intelligently                        |\n| No record of when ideas were created | Appends current date/time on content creation                               |\n| Repeated manual checks               | Uses Google Drive Trigger to monitor changes every minute                   |\n\n---\n\n## 🔄 Workflow Overview\n\n```mermaid\ngraph TD\n    A[Google Drive Trigger] --> B[Google Sheets1 (Read Data)]\n    B --> C[Loop Over Items]\n    C --> D{If: Topic not empty AND Content empty?}\n    D -->|Yes| E[HTTP Request (Generate Content)]\n    E --> F[Google Sheets2 (Write Data)]\n    F --> G[Wait (10s)]\n    G --> C\n    D -->|No| C\n"
      },
      "typeVersion": 1
    },
    {
      "id": "0c29124c-3409-4682-8dda-a4319e8844a8",
      "name": "付箋1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -420
      ],
      "parameters": {
        "height": 640,
        "content": "### 📌 Node: Google Drive Trigger\n\n- **Type:** Trigger (n8n-nodes-base.googleDriveTrigger)\n- **Function:** Watches a specific Google Sheet file for changes.\n- **Trigger Mode:** Every minute (`pollTimes`)\n- **Why it's used:** To detect changes in the spreadsheet and initiate the automation workflow.\n- **Authentication:** Google Service Account\n- **Watched File:** \n"
      },
      "typeVersion": 1
    },
    {
      "id": "731e5f13-05c1-43bb-9810-a41955f2ecf5",
      "name": "付箋2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        120,
        -420
      ],
      "parameters": {
        "height": 640,
        "content": "### 📌 Node: Google Sheets1\n\n- **Type:** Google Sheets (Read)\n- **Function:** Reads all data from the specified sheet.\n- **Why it's used:** Fetches rows to process for lead magnet generation.\n- **Sheet Name:** Sheet1 (gid=0)\n- **Authentication:** Google Service Account\n"
      },
      "typeVersion": 1
    },
    {
      "id": "9fbf2aed-8272-47b0-8a89-5b0abcf02e79",
      "name": "付箋3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        -420
      ],
      "parameters": {
        "height": 640,
        "content": "### 📌 Node: Loop Over Items\n\n- **Type:** Split In Batches (n8n-nodes-base.splitInBatches)\n- **Function:** Processes each row one at a time.\n- **Why it's used:** Ensures efficient row-by-row processing to control API load.\n- **Options:**\n  - `reset: false`\n"
      },
      "typeVersion": 1
    },
    {
      "id": "52a1ecbe-9942-4f6f-9d32-a44a0e3e3a1f",
      "name": "付箋4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        700,
        -420
      ],
      "parameters": {
        "height": 640,
        "content": "### 📌 Node: If\n\n- **Type:** Conditional Check\n- **Function:** Filters rows where:\n  - `Topic` is **not empty**\n  - `Content` is **empty**\n- **Why it's used:** To skip rows that already have generated content or are missing topics.\n- **Condition Logic:**\n  - `Topic` → `notEmpty`\n  - `Content` → `empty`\n- **Combinator:** `AND`\n"
      },
      "typeVersion": 1
    },
    {
      "id": "86e47d98-d052-4203-b056-9442f20b0fa4",
      "name": "付箋5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        980,
        -420
      ],
      "parameters": {
        "width": 280,
        "height": 820,
        "content": "### 📌 Node: HTTP Request\n\n- **Type:** HTTP Request (POST)\n- **Function:** Sends topic and website to an external AI API to generate lead magnet ideas.\n- **URL:** `https://lead-magnet-idea-generator-ai.p.rapidapi.com/index.php`\n- **Headers:**\n  - `x-rapidapi-host: lead-magnet-idea-generator-ai.p.rapidapi.com`\n  - `x-rapidapi-key: <your-api-key>`\n- **Body Content-Type:** `multipart/form-data`\n- **Body Parameters:**\n  - `topic`: `={{ $json.Topic }}`\n  - `website`: `={{ $json['Website Url'] }}`\n- **Why it's used:** Automates lead magnet idea generation via third-party API.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "866680d1-8d17-45ab-81eb-b7a1cb9448d0",
      "name": "付箋6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1280,
        -420
      ],
      "parameters": {
        "height": 700,
        "content": "### 📌 Node: Google Sheets2\n\n- **Type:** Google Sheets (Append or Update)\n- **Function:** Updates the same row with generated content and timestamp.\n- **Why it's used:** Writes the result back into the Google Sheet.\n- **Columns Mapping:**\n  - `Topic`: `={{ $('If').item.json.Topic }}`\n  - `Website Url`: `={{ $('If').item.json['Website Url'] }}`\n  - `Content`: `={{ $json.data }}`\n  - `Generated Date`: `={{ new Date().toLocaleString() }}`\n- **Matching Column:** Topic\n- **Authentication:** Google Service Account\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "0d382187-48dc-45cc-bc27-cba36049bd6b",
      "name": "付箋7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1560,
        -420
      ],
      "parameters": {
        "height": 680,
        "content": "### 📌 Node: Wait\n\n- **Type:** Wait Node\n- **Function:** Pauses the workflow for 10 seconds after writing data.\n- **Why it's used:** Prevents rapid API hits and allows smooth looping.\n- **Wait Time:** 10 seconds\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "4caf167f-472a-4c9e-aef3-4b77c3fa4b93",
  "connections": {
    "952b9061-9f2c-41b4-9f0a-1567160f3540": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Google Sheets2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets1": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets2": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "952b9061-9f2c-41b4-9f0a-1567160f3540",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Drive Trigger": {
      "main": [
        [
          {
            "node": "Google Sheets1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}