Google Maps에서 Airtable 잠재 고객 추출, Impressum에서 연락처 추출하는 GPT
고급
이것은AI Summarization, Multimodal AI분야의자동화 워크플로우로, 31개의 노드를 포함합니다.주로 If, Set, Html, Wait, Filter 등의 노드를 사용하며. Google Maps에서 잠재 고객을 Airtable로 추출, Impressum에서 연락처 추출을 위해 GPT 사용
사전 요구사항
- •Airtable API Key
- •대상 API의 인증 정보가 필요할 수 있음
- •OpenAI API Key
사용된 노드 (31)
워크플로우 미리보기
노드 연결 관계를 시각적으로 표시하며, 확대/축소 및 이동을 지원합니다
워크플로우 내보내기
다음 JSON 구성을 복사하여 n8n에 가져오면 이 워크플로우를 사용할 수 있습니다
{
"meta": {
"instanceId": "b3c78d9213cdc0a8018a578d1543ef08ec7366e4d3b4299a1927d55abcb8586c",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "493c4059-eae8-4991-b515-621e54fcb7d1",
"name": "분할 출력",
"type": "n8n-nodes-base.splitOut",
"position": [
-448,
1232
],
"parameters": {
"options": {},
"fieldToSplitOut": "results"
},
"typeVersion": 1
},
{
"id": "ccbf8771-0911-458a-a4bc-b14526302f7f",
"name": "search Place",
"type": "n8n-nodes-base.httpRequest",
"position": [
-672,
1232
],
"parameters": {
"url": "https://maps.googleapis.com/maps/api/place/textsearch/json",
"options": {
"pagination": {
"pagination": {
"parameters": {
"parameters": [
{
"name": "pagetoken",
"value": "={{$response.body.next_page_token}}"
}
]
},
"maxRequests": 1,
"requestInterval": 20,
"limitPagesFetched": true
}
}
},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth",
"queryParameters": {
"parameters": [
{
"name": "query",
"value": "={{ $json.Suchbegriff }}"
},
{
"name": "pagetoken"
}
]
}
},
"credentials": {
"httpQueryAuth": {
"id": "VMmECAyj9TvECleR",
"name": "Query Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "2cb16f2f-2457-4f94-9a35-65c912ebc209",
"name": "Place Details",
"type": "n8n-nodes-base.httpRequest",
"position": [
-224,
1232
],
"parameters": {
"url": "https://maps.googleapis.com/maps/api/place/details/json",
"options": {
"pagination": {
"pagination": {
"parameters": {
"parameters": [
{
"name": "next_page_token",
"value": "={{ $ifEmpty($response.body.next_page_token,\"\") }}"
}
]
},
"maxRequests": 1,
"requestInterval": 2,
"limitPagesFetched": true
}
}
},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth",
"queryParameters": {
"parameters": [
{
"name": "place_id",
"value": "={{ $json.place_id }}"
}
]
}
},
"credentials": {
"httpQueryAuth": {
"id": "VMmECAyj9TvECleR",
"name": "Query Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "50d042a7-4fb4-46b7-a9b9-8eaea097329a",
"name": "OpenAI 채팅 모델",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1424,
880
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "Eycxhgo48HYdb8Jb",
"name": "Sul Mapsscraper"
}
},
"typeVersion": 1.2
},
{
"id": "92a80d2e-d867-4ac7-98c0-f0e1710ddd05",
"name": "Edit Fields1",
"type": "n8n-nodes-base.set",
"position": [
1616,
368
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "917545a0-b987-40b6-ba7c-eb9428ab64c3",
"name": "Entscheidername",
"type": "string",
"value": "={{ $json.output.Entscheidername.split(',')[0] }}"
},
{
"id": "5d76f892-186e-4510-987d-598382d7eca5",
"name": "Entscheiderposition",
"type": "string",
"value": "={{ $ifEmpty($json.output.Entscheidername.split(',')[1],\"\") }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "97056b0f-bdea-43b8-9305-5b5d010ae6df",
"name": "항목 반복1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1120,
752
],
"parameters": {
"options": {},
"batchSize": 5
},
"typeVersion": 3
},
{
"id": "6f57f165-aec6-4e49-835e-2c22f7dd5726",
"name": "대기",
"type": "n8n-nodes-base.wait",
"position": [
1696,
864
],
"webhookId": "d5f6e76a-cdca-4633-ac6f-373e5f6ee44e",
"parameters": {
"amount": 20
},
"typeVersion": 1.1
},
{
"id": "1d2b0c45-a627-48aa-9c2a-c1a32ef838f9",
"name": "HTML",
"type": "n8n-nodes-base.html",
"position": [
1152,
1216
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "mainContent",
"cssSelector": "body",
"skipSelectors": "img, wp,nav, header, footer, aside, script, style, .sidebar, .ads, .ad, .advertisement, .breadcrumb, .cookies, .newsletter, .popup, .modal"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "cd11b2d4-04c3-4767-b376-a9dfec33c2ad",
"name": "항목 반복3",
"type": "n8n-nodes-base.splitInBatches",
"position": [
672,
1376
],
"parameters": {
"options": {},
"batchSize": 5
},
"typeVersion": 3
},
{
"id": "1deac6fc-1b84-4018-b500-cdecf5f38d7e",
"name": "대기2",
"type": "n8n-nodes-base.wait",
"position": [
1408,
1376
],
"webhookId": "08940f1f-8b2e-4ff0-b238-d7090c26e3b9",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "34ab2c6a-8b45-4288-8f8c-fff2964eea96",
"name": "When Executed by Another Workflow",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-1568,
1232
],
"parameters": {
"workflowInputs": {
"values": [
{
"name": "Stadt,Land"
},
{
"name": "Suchbegriff"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "5ed54e52-29ea-4646-ade7-491334e529a9",
"name": "클릭 시 ‘Execute workflow’",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1504,
1792
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3f5572ed-9935-4a5b-a4dd-593597dfd881",
"name": "Execute Workflow",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
-496,
1856
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "list",
"value": "SLqoXTIjAZ8JXMs7",
"cachedResultName": "Maps Scraper"
},
"workflowInputs": {
"value": {
"Stadt,Land": "={{ $('Airtable2').item.json.Stadt }}, {{ $('Airtable2').item.json.Land }}",
"Suchbegriff": "Seo Agentur"
},
"schema": [
{
"id": "Stadt,Land",
"type": "string",
"display": true,
"required": false,
"displayName": "Stadt,Land",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Suchbegriff",
"type": "string",
"display": true,
"required": false,
"displayName": "Suchbegriff",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": true,
"convertFieldsToString": true
}
},
"executeOnce": false,
"typeVersion": 1.2,
"alwaysOutputData": true
},
{
"id": "456fce84-9f8b-4300-a097-3a1bf507fbdd",
"name": "Airtable1",
"type": "n8n-nodes-base.airtable",
"position": [
-288,
1856
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appjgzxHXkhxrtlfm",
"cachedResultUrl": "https://airtable.com/appjgzxHXkhxrtlfm",
"cachedResultName": "Mapsscraper"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblTE2107lXjXarJz",
"cachedResultUrl": "https://airtable.com/appjgzxHXkhxrtlfm/tblTE2107lXjXarJz",
"cachedResultName": "Städte"
},
"columns": {
"value": {
"id": "={{ $('Airtable2').item.json.id }}",
"Auswählen": "Check"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Stadt",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Stadt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Land",
"type": "options",
"display": true,
"options": [
{
"name": "Deutschland",
"value": "Deutschland"
},
{
"name": "Österreich",
"value": "Österreich"
},
{
"name": "Schweiz",
"value": "Schweiz"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Land",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Auswählen",
"type": "options",
"display": true,
"options": [
{
"name": "Check",
"value": "Check"
},
{
"name": "no Check",
"value": "no Check"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Auswählen",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "upsert"
},
"credentials": {
"airtableTokenApi": {
"id": "HEHppsGbPM3Hiq6L",
"name": "s.said@aufcopilot.de linkedIN"
}
},
"executeOnce": true,
"typeVersion": 2.1
},
{
"id": "f78dbd0d-3cdc-411e-800d-893f59ac5232",
"name": "Airtable2",
"type": "n8n-nodes-base.airtable",
"position": [
-1168,
1744
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appjgzxHXkhxrtlfm",
"cachedResultUrl": "https://airtable.com/appjgzxHXkhxrtlfm",
"cachedResultName": "Mapsscraper"
},
"limit": 25,
"table": {
"__rl": true,
"mode": "list",
"value": "tblTE2107lXjXarJz",
"cachedResultUrl": "https://airtable.com/appjgzxHXkhxrtlfm/tblTE2107lXjXarJz",
"cachedResultName": "Städte"
},
"options": {},
"operation": "search",
"returnAll": false
},
"credentials": {
"airtableTokenApi": {
"id": "HEHppsGbPM3Hiq6L",
"name": "s.said@aufcopilot.de linkedIN"
}
},
"typeVersion": 2.1
},
{
"id": "5d906fab-24af-4812-85e4-0c3a2a77b2ad",
"name": "항목 반복2",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-720,
1744
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "45d43303-380f-40ad-bd52-f776a6754c67",
"name": "필터5",
"type": "n8n-nodes-base.filter",
"position": [
-944,
1744
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "9894907d-cf03-45c8-833b-ed9d1c128783",
"operator": {
"type": "string",
"operation": "notEquals"
},
"leftValue": "={{ $json['Auswählen'] }}",
"rightValue": "Check"
},
{
"id": "087cdb6a-94b7-458f-87db-d8ca65cf4271",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Land }}",
"rightValue": "Deutschland"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "f4c8f3d6-8275-4eda-a111-2030e7a80aff",
"name": "메모",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1632,
1584
],
"parameters": {
"width": 1664,
"height": 544,
"content": "## Init Scraper for Each City\n\n* In Airtable, there is a list of cities used as search terms for Google Maps. The scraper processes them one by one to collect all businesses in each major city within a given country.\nDuring initialization, the scraper takes the city name as a parameter. Once a city is fully processed, it marks that city as “completed” in another column. This way, if the process is interrupted, it can resume with the next unchecked city."
},
"typeVersion": 1
},
{
"id": "63e40c33-b599-4d06-80dd-597e9db324d0",
"name": "already scraped",
"type": "n8n-nodes-base.airtable",
"position": [
-1344,
1232
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appjgzxHXkhxrtlfm",
"cachedResultUrl": "https://airtable.com/appjgzxHXkhxrtlfm",
"cachedResultName": "Mapsscraper"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblZDRAqzW1JKHzzU",
"cachedResultUrl": "https://airtable.com/appjgzxHXkhxrtlfm/tblZDRAqzW1JKHzzU",
"cachedResultName": "Mapsscraper"
},
"options": {},
"operation": "search"
},
"credentials": {
"airtableTokenApi": {
"id": "HEHppsGbPM3Hiq6L",
"name": "s.said@aufcopilot.de linkedIN"
}
},
"typeVersion": 2.1
},
{
"id": "d4a854f8-76e7-4e0a-b44f-01437907bbfc",
"name": "Array all Companies scraped",
"type": "n8n-nodes-base.summarize",
"position": [
-1120,
1232
],
"parameters": {
"options": {},
"fieldsToSummarize": {
"values": [
{
"field": "Firmenname",
"aggregation": "concatenate"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "785e14cf-b227-4a1b-bda1-b318dcd2d505",
"name": "Searchword",
"type": "n8n-nodes-base.set",
"position": [
-896,
1232
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c96ec75d-7aab-484f-8b30-87e25fd33b55",
"name": "Suchbegriff",
"type": "string",
"value": "={{ $('When Executed by Another Workflow').item.json.Suchbegriff }} {{ $('When Executed by Another Workflow').item.json['Stadt,Land'] }}"
}
]
}
},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "5c6a8971-0c32-445d-ae7b-4866ea402c31",
"name": "Places already scraped",
"type": "n8n-nodes-base.if",
"position": [
-32,
1248
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "c6849881-5ead-415c-9df2-82844dc75144",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $('Array all Companies scraped').item.json.concatenated_Firmenname }}",
"rightValue": "={{ $('Place Details').item.json.result.name }}"
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.2
},
{
"id": "0bd81c3b-ec89-4ae7-8819-ed554af15ffc",
"name": "Get Impressum-URL",
"type": "n8n-nodes-base.set",
"onError": "continueErrorOutput",
"position": [
400,
1392
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "af78fa47-9cb8-49a6-8a45-e96860b1a025",
"name": "result.website",
"type": "string",
"value": "={{ $json.result.website.extractUrl().extractDomain() }}/impressum"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "8330fdc2-6325-4280-b696-a83c7168c847",
"name": "Get Impressum HTML",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
896,
1296
],
"parameters": {
"url": "=https://{{ $json.result.website }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "8e8e048c-86d4-44c4-a19e-903613b9ce42",
"name": "Successfully scraped Impressumpages?",
"type": "n8n-nodes-base.filter",
"position": [
896,
752
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c683a504-52b6-47fc-b42e-0ced16f25e45",
"operator": {
"type": "object",
"operation": "notExists",
"singleValue": true
},
"leftValue": "={{ $json.error }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "2f413fb2-18bc-41cb-8a60-36fef41706d4",
"name": "Relevant Infos from Impressum",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
1344,
656
],
"parameters": {
"text": "={{ $json.mainContent }}",
"options": {
"systemPromptTemplate": "Please extract the following information from the given HTML document:\n\nAn executive and their position (if available). Combine the person’s name and position into a single text format, e.g., \"Name, Position\". If no position or name is provided, leave name or position empty.\n\nThe phone number of the selected executive (if available).\n\nEmail address.\n\nIf no person (with a real name), position, or phone number is available, set the corresponding value to null"
},
"attributes": {
"attributes": [
{
"name": "Entscheidername",
"required": true,
"description": "Eine Führungskraft und deren Position (falls vorhanden). Kombiniere Personen Name und Position in einem einzigen Textformat wie: \"Name, Position\". Wenn keine Position oder personenname angegeben ist, lasse namen oder position leer"
},
{
"name": "Telefonnummer",
"description": "Die Telefonnummer der ausgewählten Führungskraft (falls vorhanden)."
},
{
"name": "Emailadresse",
"required": true,
"description": "idealerweise die emailadresse der Führungskraft, ansonsten irgendeine nur gültige Email adressen mit @"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "61e6159d-80cd-4e30-81a0-c705a4fb1134",
"name": "메모1",
"type": "n8n-nodes-base.stickyNote",
"position": [
336,
1136
],
"parameters": {
"color": 3,
"width": 1296,
"height": 496,
"content": "Get Impressum-Pages and scrape trough them\n"
},
"typeVersion": 1
},
{
"id": "faffe186-8d22-4510-a833-63afdb044ac6",
"name": "메모2",
"type": "n8n-nodes-base.stickyNote",
"position": [
816,
576
],
"parameters": {
"color": 3,
"width": 1056,
"height": 496,
"content": "## Extract Relevant Information from Impressum HTML\n\nDecision Maker, Email, Telephone Number"
},
"typeVersion": 1
},
{
"id": "fe69bf9f-9825-46c3-970a-a79bccca9c08",
"name": "이메일 not Empty",
"type": "n8n-nodes-base.filter",
"position": [
1408,
368
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7bde4471-5c96-4f96-b830-af67cc60ad60",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.output.Emailadresse }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "c5ecdfbc-7e5f-499e-8688-304b61828f73",
"name": "메모3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1392,
1072
],
"parameters": {
"color": 3,
"width": 1616,
"height": 400,
"content": "Check if the company has already been scraped → search for places using the search term → fetch detailed information via morePlaceDetails."
},
"typeVersion": 1
},
{
"id": "1f1ccdb0-24e1-430a-8aec-802acc6c680a",
"name": "Write in DB",
"type": "n8n-nodes-base.airtable",
"position": [
1840,
368
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appjgzxHXkhxrtlfm",
"cachedResultUrl": "https://airtable.com/appjgzxHXkhxrtlfm",
"cachedResultName": "Mapsscraper"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblZDRAqzW1JKHzzU",
"cachedResultUrl": "https://airtable.com/appjgzxHXkhxrtlfm/tblZDRAqzW1JKHzzU",
"cachedResultName": "Mapsscraper"
},
"columns": {
"value": {
"Email": "={{ $('Relevant Infos from Impressum').item.json.output.Emailadresse }}",
"Website": "={{ $('Place Details').item.json.result.website }}",
"Standort": "={{ $('Place Details').item.json.result.formatted_address }}",
"Firmenname": "={{ $('Place Details').item.json.result.name }}",
"Suchbegriff": "={{ $('Searchword').item.json.Suchbegriff }}",
"Telefonnummer": "={{ $('Place Details').item.json.result.international_phone_number }}",
"Entscheidername": "={{ $json.Entscheidername }}",
"Entscheiderposition": "={{ $json.Entscheiderposition }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Firmenname",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Firmenname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Telefonnummer",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Telefonnummer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Entscheidername",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Entscheidername",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Entscheiderposition",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Entscheiderposition",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Standort",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Standort",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Summary",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Lead Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Suchbegriff",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Suchbegriff",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Linkedin",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Websitewissen vekorisiert",
"type": "options",
"display": true,
"options": [
{
"name": "Ja",
"value": "Ja"
},
{
"name": "Nein",
"value": "Nein"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Websitewissen vekorisiert",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Firmenname"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "upsert"
},
"credentials": {
"airtableTokenApi": {
"id": "HEHppsGbPM3Hiq6L",
"name": "s.said@aufcopilot.de linkedIN"
}
},
"typeVersion": 2.1
}
],
"pinData": {
"When Executed by Another Workflow": [
{
"Stadt,Land": "Frauenfeld, Schweiz",
"Suchbegriff": "Seo Agentur"
}
]
},
"connections": {
"1d2b0c45-a627-48aa-9c2a-c1a32ef838f9": {
"main": [
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Wait2": {
"main": [
[
{
"node": "Loop Over Items3",
"type": "main",
"index": 0
}
]
]
},
"Filter5": {
"main": [
[
{
"node": "Loop Over Items2",
"type": "main",
"index": 0
}
]
]
},
"456fce84-9f8b-4300-a097-3a1bf507fbdd": {
"main": [
[
{
"node": "Loop Over Items2",
"type": "main",
"index": 0
}
]
]
},
"f78dbd0d-3cdc-411e-800d-893f59ac5232": {
"main": [
[
{
"node": "Filter5",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "2cb16f2f-2457-4f94-9a35-65c912ebc209",
"type": "main",
"index": 0
}
]
]
},
"785e14cf-b227-4a1b-bda1-b318dcd2d505": {
"main": [
[
{
"node": "ccbf8771-0911-458a-a4bc-b14526302f7f",
"type": "main",
"index": 0
}
]
]
},
"1f1ccdb0-24e1-430a-8aec-802acc6c680a": {
"main": [
[]
]
},
"92a80d2e-d867-4ac7-98c0-f0e1710ddd05": {
"main": [
[
{
"node": "1f1ccdb0-24e1-430a-8aec-802acc6c680a",
"type": "main",
"index": 0
}
]
]
},
"ccbf8771-0911-458a-a4bc-b14526302f7f": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"2cb16f2f-2457-4f94-9a35-65c912ebc209": {
"main": [
[
{
"node": "5c6a8971-0c32-445d-ae7b-4866ea402c31",
"type": "main",
"index": 0
}
]
]
},
"Email not Empty": {
"main": [
[
{
"node": "92a80d2e-d867-4ac7-98c0-f0e1710ddd05",
"type": "main",
"index": 0
}
]
]
},
"63e40c33-b599-4d06-80dd-597e9db324d0": {
"main": [
[
{
"node": "d4a854f8-76e7-4e0a-b44f-01437907bbfc",
"type": "main",
"index": 0
}
]
]
},
"3f5572ed-9935-4a5b-a4dd-593597dfd881": {
"main": [
[
{
"node": "456fce84-9f8b-4300-a097-3a1bf507fbdd",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[
{
"node": "Email not Empty",
"type": "main",
"index": 0
}
],
[
{
"node": "2f413fb2-18bc-41cb-8a60-36fef41706d4",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items2": {
"main": [
[],
[
{
"node": "3f5572ed-9935-4a5b-a4dd-593597dfd881",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items3": {
"main": [
[
{
"node": "8e8e048c-86d4-44c4-a19e-903613b9ce42",
"type": "main",
"index": 0
}
],
[
{
"node": "8330fdc2-6325-4280-b696-a83c7168c847",
"type": "main",
"index": 0
}
]
]
},
"0bd81c3b-ec89-4ae7-8819-ed554af15ffc": {
"main": [
[
{
"node": "Loop Over Items3",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "2f413fb2-18bc-41cb-8a60-36fef41706d4",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"8330fdc2-6325-4280-b696-a83c7168c847": {
"main": [
[
{
"node": "1d2b0c45-a627-48aa-9c2a-c1a32ef838f9",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
},
"5c6a8971-0c32-445d-ae7b-4866ea402c31": {
"main": [
[
{
"node": "0bd81c3b-ec89-4ae7-8819-ed554af15ffc",
"type": "main",
"index": 0
}
]
]
},
"d4a854f8-76e7-4e0a-b44f-01437907bbfc": {
"main": [
[
{
"node": "785e14cf-b227-4a1b-bda1-b318dcd2d505",
"type": "main",
"index": 0
}
]
]
},
"2f413fb2-18bc-41cb-8a60-36fef41706d4": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"34ab2c6a-8b45-4288-8f8c-fff2964eea96": {
"main": [
[
{
"node": "63e40c33-b599-4d06-80dd-597e9db324d0",
"type": "main",
"index": 0
}
]
]
},
"8e8e048c-86d4-44c4-a19e-903613b9ce42": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "f78dbd0d-3cdc-411e-800d-893f59ac5232",
"type": "main",
"index": 0
}
]
]
}
}
}자주 묻는 질문
이 워크플로우를 어떻게 사용하나요?
위의 JSON 구성 코드를 복사하여 n8n 인스턴스에서 새 워크플로우를 생성하고 "JSON에서 가져오기"를 선택한 후, 구성을 붙여넣고 필요에 따라 인증 설정을 수정하세요.
이 워크플로우는 어떤 시나리오에 적합한가요?
고급 - AI 요약, 멀티모달 AI
유료인가요?
이 워크플로우는 완전히 무료이며 직접 가져와 사용할 수 있습니다. 다만, 워크플로우에서 사용하는 타사 서비스(예: OpenAI API)는 사용자 직접 비용을 지불해야 할 수 있습니다.
관련 워크플로우 추천
시각화 참조 라이브러리에서 n8n 노드를 탐색
可视化 참조 라이브러리에서 n8n 노드를 탐색
If
Ftp
Set
+
If
Ftp
Set
113 노드I versus AI
기타
WordPress 블로그 자동화 프로페셔널 에디션(심층 연구) v2.1 마켓
GPT-4o, Perplexity AI 및 다국어 지원을 사용한 SEO 최적화 블로그 생성 자동화
If
Set
Xml
+
If
Set
Xml
125 노드Daniel Ng
콘텐츠 제작
GitHub 동기화 대시보드 - V2
提交 기록과 롤백 기능을 갖춘 GitHub 워크플로우 버전 관리 대시보드
If
N8n
Set
+
If
N8n
Set
94 노드Eduard
데브옵스
API 아키텍처 추출기
API 아키텍처 추출기
If
Set
Code
+
If
Set
Code
88 노드Polina Medvedieva
엔지니어링
YNAB 자동 예산
GPT-5-Mini로 YNAB 거래 자동 분류 및 Discord 알림 전송
If
Set
Merge
+
If
Set
Merge
29 노드spencer owen
AI 요약
GPT-4와 Airtable을 사용한 작업 기록 및 백업 워크플로 자동화
GPT-4와 Airtable로 워크플로우 자동 기록 및 백업
If
N8n
Set
+
If
N8n
Set
38 노드Guillaume Duvernay
AI 요약
워크플로우 정보
난이도
고급
노드 수31
카테고리2
노드 유형16
저자
Sulieman Said
@sulieman-said👋 Hi, I’m Sulieman – Founder of aufCopilot.de . I build custom n8n workflows, automations & AI integrations to help businesses save time and scale smarter. I share templates, answer questions and love exploring creative use cases – from lead generation to data workflows and AI-powered automations. 🚀 Always happy to connect, learn and contribute to the community.
외부 링크
n8n.io에서 보기 →
이 워크플로우 공유