웹 요약
이것은Lead Generation, Multimodal AI분야의자동화 워크플로우로, 12개의 노드를 포함합니다.주로 Set, Wait, GoogleSheets, ManualTrigger, SplitInBatches 등의 노드를 사용하며. GPT-4o와 Google Sheets를 사용하여 웹사이트 URL에서 AI 판매 대화 생성
- •Google Sheets API 인증 정보
- •OpenAI API Key
{
"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)는 사용자 직접 비용을 지불해야 할 수 있습니다.
관련 워크플로우 추천
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.
이 워크플로우 공유