ウェブサイト要約
中級
これはLead Generation, Multimodal AI分野の自動化ワークフローで、12個のノードを含みます。主にSet, Wait, GoogleSheets, ManualTrigger, SplitInBatchesなどのノードを使用。 GPT-4o と Google Sheets を使って Web URL から AI セールススピーチ生成
前提条件
- •Google Sheets API認証情報
- •OpenAI API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "4CnUOZExvXMQTGEB",
"meta": {
"instanceId": "159ec2e1d690fe685084d28de8ca73848642bf563457a19b94cfc00f23a0d9a9",
"templateCredsSetupCompleted": true
},
"name": "Website Summary",
"tags": [],
"nodes": [
{
"id": "6791eccd-206f-46db-b2a0-fd22eddcbaab",
"name": "手動トリガー",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-992,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "de262216-3632-44fa-8095-51b2890a2bff",
"name": "出力フォーマット（フィールド編集）",
"type": "n8n-nodes-base.set",
"position": [
272,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "message",
"name": "Personalized Message",
"type": "string",
"value": "={{ $json.message.content }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "13509a29-9641-4cb7-a100-322dbcf18efc",
"name": "2秒待機",
"type": "n8n-nodes-base.wait",
"position": [
512,
-16
],
"webhookId": "53b8c837-5c7a-4b3b-af33-708f7dacda47",
"parameters": {
"unit": "seconds",
"amount": 2
},
"typeVersion": 1
},
{
"id": "14b1b895-6a33-4f82-8222-5375bbafbe89",
"name": "完了",
"type": "n8n-nodes-base.noOp",
"position": [
-400,
128
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0aba365a-c78e-4746-b486-3d82247f3bde",
"name": "メッセージのパーソナライズ",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-96,
-80
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "chatgpt-4o-latest",
"cachedResultName": "CHATGPT-4O-LATEST"
},
"options": {},
"messages": {
"values": [
{
"content": "=You analyze an organization’s website content here: {{ $json.data.markdown }}\n\nand produce concise, credible sales intelligence for pitching AI services.\n\nRequirements:\n- Be specific and grounded in the supplied content (title, meta, H1s, text snippet). Do not invent facts.\n- No buzzwords (avoid: leverage, synergies, cutting-edge, game-changing, etc.).\n- Tone: consultative, earnest, respectful; no hype; no exclamation points.\n- If a contact name is provided, greet or reference them by first name in the pitch once, naturally.\n- If content is thin, infer cautiously from title/meta/H1s and acknowledge limits.\n\nOutput format (plain text, exactly this structure):\nContext:\n• 2–4 bullets on what they do, who they serve, and any pain/initiative AI could help with (explicit, concrete).\nPitch:\nOne paragraph (70–110 words) proposing how AI/automation could help them, referencing 1–2 specifics from the site, ending with a single next-step question. "
}
]
}
},
"credentials": {
"openAiApi": {
"id": "qiPWoGhtEMQi7AWs",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "f8c9563f-4095-43d6-af90-31ed79b2e57e",
"name": "パーソナライズ済みメッセージでシート更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
704,
176
],
"parameters": {
"columns": {
"value": {
"Personalized Message": "={{ $('Shape output (Edit Fields)').item.json['Personalized Message'] }}"
},
"schema": [
{
"id": "Website",
"type": "string",
"display": true,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Personalized Message",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Personalized Message",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Personalized Message"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04/edit?usp=drivesdk",
"cachedResultName": "Websites"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "sUuiWu6oknUOYMCR",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "5dd11818-b2ec-4d17-b3af-7c3640f10b4d",
"name": "シートからウェブサイトURLを取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
-784,
-80
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/16jci4CjnZdp32-ZWt2WjmspX9-xNtU5vEKzjVauZn04/edit?usp=drivesdk",
"cachedResultName": "Websites"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "sUuiWu6oknUOYMCR",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.7
},
{
"id": "a491869d-1446-40bf-b997-db77a5898534",
"name": "URLループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-512,
-80
],
"parameters": {
"options": {},
"batchSize": 1
},
"typeVersion": 2
},
{
"id": "d0ee57fd-c057-4cfb-af2f-91d6fbb0fc74",
"name": "ウェブサイトスクレイピングとコンテンツ取得",
"type": "@mendable/n8n-nodes-firecrawl.firecrawl",
"position": [
-288,
-80
],
"parameters": {
"url": "={{ $json.Website }}",
"operation": "scrape",
"scrapeOptions": {
"options": {
"formats": [
"markdown",
"screenshot"
],
"headers": {}
}
},
"requestOptions": {}
},
"credentials": {
"firecrawlApi": {
"id": "6t52jAuk3BVEroC5",
"name": "Firecrawl account"
}
},
"typeVersion": 1
},
{
"id": "b8aed690-0f39-4886-a80a-4ad918a5c835",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-896,
-400
],
"parameters": {
"width": 352,
"height": 304,
"content": "Upon being triggered, this first step is going to fetch all URLs from your spreadsheet. Each URL should be in a new row.\n\nSpreadsheet setup:\n- column 1 = website\n- column 2 = personalized message\n\nPre-requisites:\n- Create your spreadsheet in your Google Drive with the appropriate columns\n- Add your Google credentials to n8n: "
},
"typeVersion": 1
},
{
"id": "3c22c785-ac6c-4ec7-aa13-8d6e65474bfa",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
-416
],
"parameters": {
"color": 4,
"width": 352,
"height": 304,
"content": "This is where the meat of things happens. The automation will loop over each website, using Firecrawl to perform the scrape. It will pass that content into your LLM (chatGPT in this case) to perform the personalization. Adjust the prompt as needed for your organization's context and what will be helpful for your personalized outreach\n\nPre-requisites:\n- Firecrawl account and API key\n- OpenAI credentials\n"
},
"typeVersion": 1
},
{
"id": "59b808d0-d10f-4c96-9215-6da972cdb09c",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
384
],
"parameters": {
"color": 5,
"width": 272,
"height": 80,
"content": "Your message will get mapped to the appropriate column in the spreadsheet"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "7a55ee84-18ab-4a3b-a18b-49c4aeff424e",
"connections": {
"13509a29-9641-4cb7-a100-322dbcf18efc": {
"main": [
[
{
"node": "f8c9563f-4095-43d6-af90-31ed79b2e57e",
"type": "main",
"index": 0
}
]
]
},
"a491869d-1446-40bf-b997-db77a5898534": {
"main": [
[
{
"node": "d0ee57fd-c057-4cfb-af2f-91d6fbb0fc74",
"type": "main",
"index": 0
}
],
[
{
"node": "14b1b895-6a33-4f82-8222-5375bbafbe89",
"type": "main",
"index": 0
}
]
]
},
"6791eccd-206f-46db-b2a0-fd22eddcbaab": {
"main": [
[
{
"node": "5dd11818-b2ec-4d17-b3af-7c3640f10b4d",
"type": "main",
"index": 0
}
]
]
},
"0aba365a-c78e-4746-b486-3d82247f3bde": {
"main": [
[
{
"node": "de262216-3632-44fa-8095-51b2890a2bff",
"type": "main",
"index": 0
}
]
]
},
"de262216-3632-44fa-8095-51b2890a2bff": {
"main": [
[
{
"node": "13509a29-9641-4cb7-a100-322dbcf18efc",
"type": "main",
"index": 0
}
]
]
},
"5dd11818-b2ec-4d17-b3af-7c3640f10b4d": {
"main": [
[
{
"node": "a491869d-1446-40bf-b997-db77a5898534",
"type": "main",
"index": 0
}
]
]
},
"d0ee57fd-c057-4cfb-af2f-91d6fbb0fc74": {
"main": [
[
{
"node": "0aba365a-c78e-4746-b486-3d82247f3bde",
"type": "main",
"index": 0
}
]
]
},
"f8c9563f-4095-43d6-af90-31ed79b2e57e": {
"main": [
[
{
"node": "a491869d-1446-40bf-b997-db77a5898534",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - リード獲得, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
JotFormの送信をGoogleスheetsに自動化
JotFormの送信をGoogleスプレッドシートに自動化する
Code
Wait
Http Request
+
Code
Wait
Http Request
12 ノードmoosa
リード獲得
カスタムカールドメールアイスブレイカージェネレーター
ApolloリードスクレイピングとGPT-4.1を使ってパーソナライズされた冷メールを自動化
Set
Code
Slack
+
Set
Code
Slack
24 ノードRichard Besier
リード獲得
AIリードミニングエージェント
Apify、AI、Gmail を使用した自動リード生成とアウトバウンド送信
If
Set
Wait
+
If
Set
Wait
20 ノードRakin Jakaria
リード獲得
Google SheetsとGPTを使ってWebサイトデータからAI駆動のパーソナライズされたアプローチ文を作成する
Google Sheets そして GPT を使ってウェブサイトデータから AI 駆動のパーソナライズされたアイスブレイクトピックを作成
Wait
Limit
Markdown
+
Wait
Limit
Markdown
15 ノードAbdul Mir
リード獲得
GPT-4 Mini、Apify、LinkedInを使用した個別化な冷水Salesの伝言開き文生成
GPT-4 Mini、Apify、LinkedIn を使用してパーソナライズされたコールド メール オープナーを生成する
Set
Filter
Aggregate
+
Set
Filter
Aggregate
16 ノードErfan Mostafiz
リード獲得
テンプレートHP - コンテンツスケジュール
GPT-4、Apify、Google Sheetsを使ってInstagramコンテンツの自動スケジュール生成
Set
Code
Wait
+
Set
Code
Wait
24 ノードkeisha kalra
コンテンツ作成
ワークフロー情報
難易度
中級
ノード数12
カテゴリー2
ノードタイプ9
作成者
Zach @BrightWayAI
@ajentaI’m Zach, founder of BrightWay and long-time product leader turned AI builder. I’ve led product teams at high-growth companies and now focus on helping mission-driven organizations automate repetitive tasks with n8n and AI. I believe in making automation accessible, starting small, and solving real-world problems with simple, smart systems.
外部リンク
n8n.ioで表示 →
このワークフローを共有