AI破冰コンテンツジェネレーター:Dumpling AIを使用してWebサイトをスクレイピングしAirtableに保存

中級

これはAI, Marketing分野の自動化ワークフローで、9個のノードを含みます。主にWait, Airtable, HttpRequest, SplitInBatches, ScheduleTriggerなどのノードを使用、AI技術を活用したスマート自動化を実現。 AI破冰コンテンツジェネレーター:Dumpling AIを使用してWebサイトをスクレイピングしAirtableに保存

前提条件
  • Airtable API Key
  • ターゲットAPIの認証情報が必要な場合あり
  • OpenAI API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
  "id": "FQ3d3ucbw3NXgnUo",
  "meta": {
    "instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
    "templateCredsSetupCompleted": true
  },
  "name": "AI Icebreaker Builder: Scrape Sites with Dumpling AI and Save to Airtable",
  "tags": [],
  "nodes": [
    {
      "id": "40c158ab-6e9c-4296-873c-c879714b65a6",
      "name": "No Operation, do nothing",
      "type": "n8n-nodes-base.noOp",
      "position": [
        100,
        -140
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d63720a5-9785-45d1-a8ba-a9c961031095",
      "name": "毎日実行して新規リードを処理",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -560,
        60
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "e5804c37-2a8d-4574-852a-f885c6941e31",
      "name": "アイスブレーカー未作成のコールドリードを検索",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -340,
        60
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://airtable.com/appPSvSKdA6075xJC",
          "cachedResultName": "Testing n8n"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://airtable.com/appPSvSKdA6075xJC/tbl1KgkRF2EEMc2Fq",
          "cachedResultName": "cold leads"
        },
        "options": {},
        "operation": "search",
        "filterByFormula": "{Ice breaker} = ''"
      },
      "credentials": {
        "airtableTokenApi": {
          "id": "H8PVkBgUPCcUhhRC",
          "name": "Airtable Personal Access Token account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "839fd20b-5a5d-4419-85b0-9b82223c8b95",
      "name": "各リードをループ処理",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -120,
        60
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "78b197e2-6028-49a0-9100-5cc44838a9cd",
      "name": "リクエスト前に待機",
      "type": "n8n-nodes-base.wait",
      "position": [
        100,
        60
      ],
      "webhookId": "d6b29fad-724c-49ad-93ed-6ebfe17d3a4c",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "de96d330-006b-4410-8b75-83c3b9658045",
      "name": "Dumpling AIでリードのウェブサイトをスクレイピング",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        320,
        60
      ],
      "parameters": {
        "url": "https://app.dumplingai.com/api/v1/scrape",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"url\": \"{{ $json.Website }}\"\n}\n",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "RLFzAcGRepr5eXZB",
          "name": "Dumpling AI-n8n"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "5d5675b6-4245-4562-a9d2-7cf54fe20b75",
      "name": "アイスブレーカー、サマリー、メールを生成 (GPT-4o)",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        540,
        60
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "chatgpt-4o-latest",
          "cachedResultName": "CHATGPT-4O-LATEST"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "=You are a smart assistant helping write personalized outreach. Below is content scraped from a lead’s website, along with the lead’s name.\n\nUsing this, please generate the following:\n\nIcebreaker: A short, friendly opening line that shows we took time to look at their business.\n\nEmail Body: A short cold outreach email that introduces what we do and how we can help, referencing their business or needs where relevant.\n\nWebsite Summary: A short summary (2 or 3 lines) of what their website is about, written in plain English.\n\nPlease return your response in this JSON format:\n\n{\n  \"icebreaker\": \"string\",\n  \"email_body\": \"string\",\n  \"website_summary\": \"string\"\n}"
            },
            {
              "content": "=Lead Name: {{ $('Search Cold Leads Without Icebreaker').item.json.Name }}\nScraped Website Content:{{ $json.content }}"
            }
          ]
        },
        "jsonOutput": true
      },
      "credentials": {
        "openAiApi": {
          "id": "dd8NvMC6rvx8RITo",
          "name": "OpenAi account 2"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "05a2b673-8e2a-41cf-9a01-eb19b2e584ea",
      "name": "AIの出力結果をAirtableに保存",
      "type": "n8n-nodes-base.airtable",
      "position": [
        960,
        60
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://airtable.com/appPSvSKdA6075xJC",
          "cachedResultName": "Testing n8n"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "https://airtable.com/appPSvSKdA6075xJC/tbl1KgkRF2EEMc2Fq",
          "cachedResultName": "cold leads"
        },
        "columns": {
          "value": {
            "id": "={{ $('Search Cold Leads Without Icebreaker').item.json.id }}",
            "Name": "={{ $('Search Cold Leads Without Icebreaker').item.json.Name }}",
            "Phone": "={{ $('Search Cold Leads Without Icebreaker').item.json.Phone }}",
            "Website": "={{ $('Search Cold Leads Without Icebreaker').item.json.Website }}",
            "Email body": "={{ $json.message.content.email_body }}",
            "Ice breaker": "={{ $json.message.content.icebreaker }}",
            "website summary": "={{ $json.message.content.website_summary }}"
          },
          "schema": [
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "id",
              "defaultMatch": true
            },
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Website",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Ice breaker",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Ice breaker",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "website summary",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "website summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email body",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Email body",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "id"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update"
      },
      "credentials": {
        "airtableTokenApi": {
          "id": "H8PVkBgUPCcUhhRC",
          "name": "Airtable Personal Access Token account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "cd8dac4b-6575-45fc-95fd-3052b244b0a2",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        -260
      ],
      "parameters": {
        "width": 810,
        "height": 480,
        "content": "### 🔄 Automated Cold Email Writing from Lead Websites\n\nThis workflow runs on a schedule and pulls new cold leads from Airtable that have no \"Ice breaker\" yet. For each lead, it waits briefly to prevent API overuse, then sends the lead’s website URL to Dumpling AI's scraping endpoint.\n\nThe scraped content is passed to GPT-4o to generate:\n- A personalized icebreaker\n- A website summary\n- A tailored cold email body\n\nFinally, all generated results are saved back into Airtable for each lead record.\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "710a2065-24ec-4681-aaa4-43028ec8acee",
  "connections": {
    "839fd20b-5a5d-4419-85b0-9b82223c8b95": {
      "main": [
        [
          {
            "node": "40c158ab-6e9c-4296-873c-c879714b65a6",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "78b197e2-6028-49a0-9100-5cc44838a9cd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "78b197e2-6028-49a0-9100-5cc44838a9cd": {
      "main": [
        [
          {
            "node": "de96d330-006b-4410-8b75-83c3b9658045",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d63720a5-9785-45d1-a8ba-a9c961031095": {
      "main": [
        [
          {
            "node": "e5804c37-2a8d-4574-852a-f885c6941e31",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "05a2b673-8e2a-41cf-9a01-eb19b2e584ea": {
      "main": [
        [
          {
            "node": "839fd20b-5a5d-4419-85b0-9b82223c8b95",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "de96d330-006b-4410-8b75-83c3b9658045": {
      "main": [
        [
          {
            "node": "5d5675b6-4245-4562-a9d2-7cf54fe20b75",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e5804c37-2a8d-4574-852a-f885c6941e31": {
      "main": [
        [
          {
            "node": "839fd20b-5a5d-4419-85b0-9b82223c8b95",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5d5675b6-4245-4562-a9d2-7cf54fe20b75": {
      "main": [
        [
          {
            "node": "05a2b673-8e2a-41cf-9a01-eb19b2e584ea",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
よくある質問

このワークフローの使い方は?

上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。

このワークフローはどんな場面に適していますか?

中級 - 人工知能, マーケティング

有料ですか?

このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。

ワークフロー情報
難易度
中級
ノード数9
カテゴリー2
ノードタイプ8
難易度説明

経験者向け、6-15ノードの中程度の複雑さのワークフロー

外部リンク
n8n.ioで表示

このワークフローを共有

カテゴリー

カテゴリー: 34