Google MapsからAirtableへのリード取得、GPTでImpressumから連絡先情報を抽出
上級
これはAI Summarization, Multimodal AI分野の自動化ワークフローで、31個のノードを含みます。主にIf, Set, Html, Wait, Filterなどのノードを使用。 Google MapsからリードをAirtableにスクレイピングし、GPTでImpressumから連絡先情報を抽出
前提条件
- •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": "場所を検索",
"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": "場所の詳細",
"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": "フィールドを編集1",
"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": "別ワークフローで実行時",
"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": "「ワークフローを実行」クリック時",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1504,
1792
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3f5572ed-9935-4a5b-a4dd-593597dfd881",
"name": "ワークフローを実行",
"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": "既にスクレイピング済み",
"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": "スクレイピング済み全企業の配列",
"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": "検索ワード",
"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": "既にスクレイピング済みの場所",
"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": "インプレスム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": "インプレスム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": "インプレスムページのスクレイピング成功？",
"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": "インプレスムからの関連情報",
"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": "メールが空でない",
"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": "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": "1deac6fc-1b84-4018-b500-cdecf5f38d7e",
"type": "main",
"index": 0
}
]
]
},
"6f57f165-aec6-4e49-835e-2c22f7dd5726": {
"main": [
[
{
"node": "97056b0f-bdea-43b8-9305-5b5d010ae6df",
"type": "main",
"index": 0
}
]
]
},
"1deac6fc-1b84-4018-b500-cdecf5f38d7e": {
"main": [
[
{
"node": "cd11b2d4-04c3-4767-b376-a9dfec33c2ad",
"type": "main",
"index": 0
}
]
]
},
"45d43303-380f-40ad-bd52-f776a6754c67": {
"main": [
[
{
"node": "5d906fab-24af-4812-85e4-0c3a2a77b2ad",
"type": "main",
"index": 0
}
]
]
},
"456fce84-9f8b-4300-a097-3a1bf507fbdd": {
"main": [
[
{
"node": "5d906fab-24af-4812-85e4-0c3a2a77b2ad",
"type": "main",
"index": 0
}
]
]
},
"f78dbd0d-3cdc-411e-800d-893f59ac5232": {
"main": [
[
{
"node": "45d43303-380f-40ad-bd52-f776a6754c67",
"type": "main",
"index": 0
}
]
]
},
"493c4059-eae8-4991-b515-621e54fcb7d1": {
"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": "493c4059-eae8-4991-b515-621e54fcb7d1",
"type": "main",
"index": 0
}
]
]
},
"2cb16f2f-2457-4f94-9a35-65c912ebc209": {
"main": [
[
{
"node": "5c6a8971-0c32-445d-ae7b-4866ea402c31",
"type": "main",
"index": 0
}
]
]
},
"fe69bf9f-9825-46c3-970a-a79bccca9c08": {
"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
}
]
]
},
"97056b0f-bdea-43b8-9305-5b5d010ae6df": {
"main": [
[
{
"node": "fe69bf9f-9825-46c3-970a-a79bccca9c08",
"type": "main",
"index": 0
}
],
[
{
"node": "2f413fb2-18bc-41cb-8a60-36fef41706d4",
"type": "main",
"index": 0
}
]
]
},
"5d906fab-24af-4812-85e4-0c3a2a77b2ad": {
"main": [
[],
[
{
"node": "3f5572ed-9935-4a5b-a4dd-593597dfd881",
"type": "main",
"index": 0
}
]
]
},
"cd11b2d4-04c3-4767-b376-a9dfec33c2ad": {
"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": "cd11b2d4-04c3-4767-b376-a9dfec33c2ad",
"type": "main",
"index": 0
}
]
]
},
"50d042a7-4fb4-46b7-a9b9-8eaea097329a": {
"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": "1deac6fc-1b84-4018-b500-cdecf5f38d7e",
"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": "6f57f165-aec6-4e49-835e-2c22f7dd5726",
"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": "97056b0f-bdea-43b8-9305-5b5d010ae6df",
"type": "main",
"index": 0
}
]
]
},
"5ed54e52-29ea-4646-ade7-491334e529a9": {
"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
DevOps
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で表示 →
このワークフローを共有