AI驱动の域名与IP安全检查自動化
上級
これはSecOps, Multimodal AI分野の自動化ワークフローで、50個のノードを含みます。主にIf, Code, HttpRequest, GoogleSheets, Agentなどのノードを使用。 AI驱动の域名与IP安全检查自動化
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
使用ノード (50)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "Tq8FAps9IX5ag1BD",
"meta": {
"instanceId": "5f1d044fa23a5710e3ad8c8ced8193dff576e0e1920d0390510f41e9622a2d1c",
"templateCredsSetupCompleted": true
},
"name": "AI-Powered Domain & IP Security Check Automation",
"tags": [],
"nodes": [
{
"id": "e56cde7e-8e27-42f4-a6ca-c71656d0fb45",
"name": "ドメイン再スキャンをリクエスト",
"type": "n8n-nodes-base.httpRequest",
"position": [
-560,
420
],
"parameters": {
"": "",
"url": "=https://www.virustotal.com/api/v3/domains/{{ $json.data.id }}/analyse",
"method": "POST",
"options": {},
"sendBody": false,
"sendQuery": false,
"curlImport": "",
"infoMessage": "",
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"specifyHeaders": "keypair",
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
},
"httpVariantWarning": "",
"nodeCredentialType": "virusTotalApi",
"provideSslCertificates": false
},
"credentials": {
"virusTotalApi": {
"id": "tLdbDlsEsHs4Wbef",
"name": "VirusTotal account"
}
},
"typeVersion": 4.2,
"extendsCredential": "virusTotalApi"
},
{
"id": "35430b97-bc78-45f8-9c49-a995c6316fd9",
"name": "ドメインレポートを取得",
"type": "n8n-nodes-base.httpRequest",
"position": [
-780,
420
],
"parameters": {
"": "",
"url": "=https://www.virustotal.com/api/v3/domains/{{ $json.Domain }}",
"method": "GET",
"options": {},
"sendBody": false,
"sendQuery": false,
"curlImport": "",
"infoMessage": "",
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"specifyHeaders": "keypair",
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
},
"httpVariantWarning": "",
"nodeCredentialType": "virusTotalApi",
"provideSslCertificates": false
},
"credentials": {
"virusTotalApi": {
"id": "tLdbDlsEsHs4Wbef",
"name": "VirusTotal account"
}
},
"typeVersion": 4.2,
"extendsCredential": "virusTotalApi"
},
{
"id": "17ac21c8-89fe-481c-8d62-80b8713e934c",
"name": "URL/ファイル分析を取得",
"type": "n8n-nodes-base.httpRequest",
"position": [
-340,
420
],
"parameters": {
"": "",
"url": "=https://www.virustotal.com/api/v3/analyses/{{ $json.data.id }}",
"method": "GET",
"options": {},
"sendBody": false,
"sendQuery": false,
"curlImport": "",
"infoMessage": "",
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"specifyHeaders": "keypair",
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
},
"httpVariantWarning": "",
"nodeCredentialType": "virusTotalApi",
"provideSslCertificates": false
},
"credentials": {
"virusTotalApi": {
"id": "tLdbDlsEsHs4Wbef",
"name": "VirusTotal account"
}
},
"typeVersion": 4.2,
"extendsCredential": "virusTotalApi"
},
{
"id": "94dc3b70-4724-4500-b2de-4e4c5215fde3",
"name": "ドメイン-IP解決",
"type": "n8n-nodes-base.httpRequest",
"position": [
-120,
420
],
"parameters": {
"": "",
"url": "=https://www.virustotal.com/api/v3/domains/{{ $('Get a domain report').item.json.data.id }}/resolutions",
"method": "GET",
"options": {},
"sendBody": false,
"sendQuery": false,
"curlImport": "",
"infoMessage": "",
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"specifyHeaders": "keypair",
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
},
"httpVariantWarning": "",
"nodeCredentialType": "virusTotalApi",
"provideSslCertificates": false
},
"credentials": {
"virusTotalApi": {
"id": "tLdbDlsEsHs4Wbef",
"name": "VirusTotal account"
}
},
"typeVersion": 4.2,
"extendsCredential": "virusTotalApi"
},
{
"id": "642fc9c6-67ac-4faa-9464-461c30a619b9",
"name": "解決",
"type": "n8n-nodes-base.httpRequest",
"position": [
320,
420
],
"parameters": {
"": "",
"url": "=https://www.virustotal.com/api/v3/resolutions/{{ $json.data[0].id }}",
"method": "GET",
"options": {},
"sendBody": false,
"sendQuery": false,
"curlImport": "",
"infoMessage": "",
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"specifyHeaders": "keypair",
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
},
"httpVariantWarning": "",
"nodeCredentialType": "virusTotalApi",
"provideSslCertificates": false
},
"credentials": {
"virusTotalApi": {
"id": "tLdbDlsEsHs4Wbef",
"name": "VirusTotal account"
}
},
"typeVersion": 4.2,
"extendsCredential": "virusTotalApi"
},
{
"id": "76fea07e-e57a-43fe-9a12-a30d7f487e8a",
"name": "コード",
"type": "n8n-nodes-base.code",
"position": [
540,
420
],
"parameters": {
"jsCode": "const attr = $input.first().json.data.attributes;\n\nreturn [\n {\n json: {\n ip: attr.ip_address,\n hostname: attr.host_name,\n maliciousIP: attr.ip_address_last_analysis_stats.malicious,\n suspiciousIP: attr.ip_address_last_analysis_stats.suspicious,\n maliciousHostname: attr.host_name_last_analysis_stats.malicious,\n suspiciousHostname: attr.host_name_last_analysis_stats.suspicious,\n resolver: attr.resolver\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "0ee0ccc3-d9e5-42b1-90e1-bd7c6435d29d",
"name": "AIエージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1640,
720
],
"parameters": {
"text": "=Berikut adalah hasil analisis terhadap domain {{ $('Code').item.json.hostname }}:\n\n1. Alamat IP: {{ $('Code').item.json.ip }}\n - malicious score: {{ $('Code').item.json.maliciousIP }}\n - suspicious score: {{ $('Code').item.json.suspiciousIP }}\n\n2. Alamat Hostname: {{ $('Code').item.json.hostname }}\n - malicious score: {{ $('Code').item.json.maliciousHostname }}\n - suspicious score: {{ $('Code').item.json.suspiciousHostname }}\n\nTolong berikan penilaian terhadap potensi risiko domain ini berdasarkan informasi di atas.\nJika ada potensi penyalahgunaan atau phishing, berikan alasannya.\nJika domain tergolong aman, beri saran mitigasi atau catatan teknis tambahan.",
"options": {
"systemMessage": "=Kamu adalah seorang analis keamanan siber profesional. Tugasmu adalah mengevaluasi apakah suatu domain berpotensi digunakan untuk phishing, spam, atau penyalahgunaan email lainnya berdasarkan data reputasi IP dan status konfigurasi email (SPF, DKIM, DMARC).\n\nKemudian berikan hasil nya secara ringkas dalam 1 kalimat bahasa indonesia."
},
"promptType": "define"
},
"typeVersion": 2
},
{
"id": "67e663f9-c426-42e4-820c-ed9b14dc1f5a",
"name": "IF ドメイン発見/未発見チェック",
"type": "n8n-nodes-base.if",
"position": [
100,
420
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "77582575-fcd6-418b-a0da-4fad0acbd0c4",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.meta.count }}",
"rightValue": 0
}
]
}
},
"typeVersion": 2.2
},
{
"id": "5c68fccc-f84b-43f5-89cf-ec2bb164867f",
"name": "悪意あるホスト名",
"type": "n8n-nodes-base.if",
"position": [
760,
720
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "4967ee0d-83ef-4ade-9e75-6443f9796233",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.maliciousHostname }}",
"rightValue": 0
},
{
"id": "b2b2834e-e6f8-487d-a504-d12bbafd972e",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.suspiciousHostname }}",
"rightValue": 0
}
]
}
},
"typeVersion": 2.2
},
{
"id": "18432dc2-1696-464f-8f6f-e9545958bcf4",
"name": "SPFチェック",
"type": "n8n-nodes-base.httpRequest",
"position": [
980,
720
],
"parameters": {
"url": "=https://dns.google/resolve?name={{ $json.hostname }}&type=TXT",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "25144a23-eb3a-4dd8-b977-906a9f88cc02",
"name": "DMARCチェック",
"type": "n8n-nodes-base.httpRequest",
"position": [
1200,
720
],
"parameters": {
"url": "=https://dns.google/resolve?name=_dmarc.{{ $('Malicious Hostname').item.json.hostname }}&type=TXT",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "525aa21f-a75e-4f7c-8e95-4e558fa9d5ec",
"name": "DKIMチェック",
"type": "n8n-nodes-base.httpRequest",
"position": [
1420,
720
],
"parameters": {
"url": "=https://dns.google/resolve?name=selector1._domainkey{{ $('Malicious Hostname').item.json.hostname }}&type=TXT",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "728c40c0-75c8-417d-837f-44638bc3e5d5",
"name": "OpenRouterチャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
1620,
900
],
"parameters": {
"options": {}
},
"credentials": {
"openRouterApi": {
"id": "TVcfTotfslzS3LcN",
"name": "OpenRouter account"
}
},
"typeVersion": 1
},
{
"id": "32830e5e-d1f3-4a2a-88e0-c0c92e8ed0da",
"name": "シンプルメモリ1",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
1760,
900
],
"parameters": {
"sessionKey": "={{ $('Malicious Hostname').item.json.hostname }}",
"sessionIdType": "customKey"
},
"typeVersion": 1.3
},
{
"id": "1bec4cbb-844e-4bcc-a5dd-c2bfd7db3ea1",
"name": "HTTP リクエスト",
"type": "n8n-nodes-base.httpRequest",
"position": [
980,
420
],
"parameters": {
"url": "=https://api.abuseipdb.com/api/v2/check?ipAddress={{ $json.ip }}&maxAgeInDays=90&verbose",
"options": {},
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"headerParameters": {
"parameters": [
{
"name": "Accept",
"value": "application/json"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "xK7zjTkwyUFnsMnV",
"name": "AbuseIP"
}
},
"typeVersion": 4.2
},
{
"id": "953db863-79ab-41a8-aabe-ebb8684cf5a8",
"name": "SPFチェック1",
"type": "n8n-nodes-base.httpRequest",
"position": [
1200,
420
],
"parameters": {
"url": "=https://dns.google/resolve?name={{ $json.data.ipAddress }}&type=TXT",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "7dab5bd1-0cee-453b-9247-0bd51df200b9",
"name": "DMARCチェック1",
"type": "n8n-nodes-base.httpRequest",
"position": [
1420,
420
],
"parameters": {
"url": "=https://dns.google/resolve?name=_dmarc.{{ $('HTTP Request').item.json.data.ipAddress }}&type=TXT",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "a09ee981-7c3b-4552-a1bf-a1339b39ed02",
"name": "DKIMチェック1",
"type": "n8n-nodes-base.httpRequest",
"position": [
1718,
420
],
"parameters": {
"url": "=https://dns.google/resolve?name=selector1._domainkey{{ $('HTTP Request').item.json.data.ipAddress }}&type=TXT",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "45560976-d3ee-48f5-8cbf-6fa95f59afcb",
"name": "悪意あるIP",
"type": "n8n-nodes-base.if",
"position": [
760,
420
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "689836a9-dabb-4ca2-b404-e1d128b013c4",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.maliciousIP }}",
"rightValue": 0
},
{
"id": "03541f82-a83c-4ffc-8f90-5a9ea2c6ba6b",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.suspiciousIP }}",
"rightValue": 0
}
]
}
},
"typeVersion": 2.2
},
{
"id": "72ae7f5e-30de-4e67-8561-f1c770a5e1e5",
"name": "AIエージェント1",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2020,
320
],
"parameters": {
"text": "=Berikut adalah hasil analisis terhadap ip {{ $('HTTP Request').item.json.data.ipAddress }}:\n\n1. Alamat IP: {{ $('Code').item.json.ip }}\n - malicious score: {{ $('Code').item.json.maliciousIP }}\n - suspicious score: {{ $('Code').item.json.suspiciousIP }}\n\n2. Alamat Hostname: {{ $('Code').item.json.hostname }}\n - malicious score: {{ $('Code').item.json.maliciousHostname }}\n - suspicious score: {{ $('Code').item.json.suspiciousHostname }}\n\n3. Report AbuseIP: {{ $('HTTP Request').item.json.data.reports[0].reportedAt }}\n - comment: {{ $('HTTP Request').item.json.data.reports[0].comment }}\n \n\nTolong berikan penilaian terhadap potensi risiko domain ini berdasarkan informasi di atas.\nJika ada potensi penyalahgunaan atau phishing, berikan alasannya.\nJika domain tergolong aman, beri saran mitigasi atau catatan teknis tambahan.",
"options": {
"systemMessage": "Kamu adalah seorang analis keamanan siber profesional. Tugasmu adalah mengevaluasi apakah suatu domain berpotensi digunakan untuk phishing, spam, atau penyalahgunaan email lainnya berdasarkan data reputasi IP dan status konfigurasi email (SPF, DKIM, DMARC).\n\nKemudian berikan hasil nya secara ringkas dalam 1 kalimat bahasa indonesia."
},
"promptType": "define"
},
"typeVersion": 2
},
{
"id": "ed718b64-98c5-4aaf-b390-38289ca8a735",
"name": "OpenRouterチャットモデル1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
2040,
520
],
"parameters": {
"options": {}
},
"credentials": {
"openRouterApi": {
"id": "TVcfTotfslzS3LcN",
"name": "OpenRouter account"
}
},
"typeVersion": 1
},
{
"id": "69bb71fe-c017-4c11-b12a-beeedd0a9d3f",
"name": "シンプルメモリ",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
2180,
520
],
"parameters": {
"sessionKey": "={{ $('HTTP Request').item.json.data.ipAddress }}",
"sessionIdType": "customKey"
},
"typeVersion": 1.3
},
{
"id": "2c2d6743-2b9a-478e-892e-177da1a2156e",
"name": "安全",
"type": "n8n-nodes-base.if",
"position": [
760,
120
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6647aeaa-f8c6-4d2e-97fa-9b09a0bdafa9",
"operator": {
"type": "number",
"operation": "exists",
"singleValue": true
},
"leftValue": 0,
"rightValue": ""
},
{
"id": "e82919de-f42c-43a0-acb6-10ad00417138",
"operator": {
"type": "number",
"operation": "exists",
"singleValue": true
},
"leftValue": 0,
"rightValue": ""
},
{
"id": "c10ace98-dceb-46c9-8f43-3923f10413da",
"operator": {
"type": "number",
"operation": "exists",
"singleValue": true
},
"leftValue": 0,
"rightValue": ""
},
{
"id": "3a754658-977b-43bf-bbcf-3b41327901b7",
"operator": {
"type": "number",
"operation": "exists",
"singleValue": true
},
"leftValue": 0,
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b2bd2eb7-554d-4df2-8f32-279bfe669242",
"name": "SPFチェック2",
"type": "n8n-nodes-base.httpRequest",
"position": [
980,
120
],
"parameters": {
"url": "=https://dns.google/resolve?name={{ $json.hostname }}&type=TXT",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "da08a6a5-0880-44f6-aba1-95a93405aa25",
"name": "DMARCチェック2",
"type": "n8n-nodes-base.httpRequest",
"position": [
1200,
120
],
"parameters": {
"url": "=https://dns.google/resolve?name=_dmarc.{{ $('Safe').item.json.hostname }}&type=TXT",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "9bbd588d-dfd7-45d5-b797-79bebb670987",
"name": "DKIMチェック2",
"type": "n8n-nodes-base.httpRequest",
"position": [
1420,
120
],
"parameters": {
"url": "=https://dns.google/resolve?name=selector1._domainkey{{ $('Safe').item.json.hostname }}&type=TXT",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "608f625d-1a92-4e47-b07e-3c43a88966c5",
"name": "AIエージェント2",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1640,
20
],
"parameters": {
"text": "=Berikut adalah hasil analisis terhadap domain {{ $('Code').item.json.hostname }}:\n\n1. Alamat IP: {{ $('Code').item.json.ip }}\n - malicious score: {{ $('Code').item.json.maliciousIP }}\n - suspicious score: {{ $('Code').item.json.suspiciousIP }}\n\n2. Alamat Hostname: {{ $('Code').item.json.hostname }}\n - malicious score: {{ $('Code').item.json.maliciousHostname }}\n - suspicious score: {{ $('Code').item.json.suspiciousHostname }}\n\nTolong berikan penilaian terhadap potensi risiko domain ini berdasarkan informasi di atas.\nJika ada potensi penyalahgunaan atau phishing, berikan alasannya.\nJika domain tergolong aman, beri saran mitigasi atau catatan teknis tambahan.",
"options": {
"systemMessage": "Kamu adalah seorang analis keamanan siber profesional. Tugasmu adalah mengevaluasi apakah suatu domain berpotensi digunakan untuk phishing, spam, atau penyalahgunaan email lainnya berdasarkan data reputasi IP dan status konfigurasi email (SPF, DKIM, DMARC).\n\nKemudian berikan hasil nya secara ringkas dalam 1 kalimat bahasa indonesia."
},
"promptType": "define"
},
"typeVersion": 2
},
{
"id": "a10f3858-ca6e-4d59-8777-8623d91d7483",
"name": "OpenRouterチャットモデル2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
1640,
200
],
"parameters": {
"options": {}
},
"credentials": {
"openRouterApi": {
"id": "TVcfTotfslzS3LcN",
"name": "OpenRouter account"
}
},
"typeVersion": 1
},
{
"id": "454659f6-12b8-41c0-9fce-1f460c0d8873",
"name": "シンプルメモリ2",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
1780,
200
],
"parameters": {
"sessionKey": "={{ $('Safe').item.json.hostname }}",
"sessionIdType": "customKey"
},
"typeVersion": 1.3
},
{
"id": "a1864a19-f8c6-4e7e-9138-4dfdd236b721",
"name": "Google シート",
"type": "n8n-nodes-base.googleSheets",
"position": [
2094,
120
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "To do",
"lookupColumn": "Status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "171ccfa2-ab2c-4acd-91c5-8e2a270c7e0e",
"name": "Google シート1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2392,
120
],
"parameters": {
"columns": {
"value": {
"Status": "To do",
"Keterangan": "={{ $('AI Agent2').item.json.output }}"
},
"schema": [
{
"id": "No",
"type": "string",
"display": true,
"required": false,
"displayName": "No",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer",
"type": "string",
"display": true,
"required": false,
"displayName": "Customer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keterangan",
"type": "string",
"display": true,
"required": false,
"displayName": "Keterangan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Status"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "8a49881a-e6d9-425c-a47f-d27953ce3e7a",
"name": "Google シート2",
"type": "n8n-nodes-base.googleSheets",
"position": [
2612,
120
],
"parameters": {
"columns": {
"value": {
"Status": "Done",
"Keterangan": "={{ $json.Keterangan }}"
},
"schema": [
{
"id": "No",
"type": "string",
"display": true,
"required": false,
"displayName": "No",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer",
"type": "string",
"display": true,
"required": false,
"displayName": "Customer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keterangan",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keterangan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Keterangan"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "6da4c1a5-061c-4d77-ac09-d339d284275d",
"name": "Google シート3",
"type": "n8n-nodes-base.googleSheets",
"position": [
2094,
720
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "To do",
"lookupColumn": "Status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "fa15fa27-7254-4952-9a08-207fab278dfd",
"name": "Google シート4",
"type": "n8n-nodes-base.googleSheets",
"position": [
2340,
720
],
"parameters": {
"columns": {
"value": {
"Status": "To do",
"Keterangan": "={{ $('AI Agent2').item.json.output }}"
},
"schema": [
{
"id": "No",
"type": "string",
"display": true,
"required": false,
"displayName": "No",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer",
"type": "string",
"display": true,
"required": false,
"displayName": "Customer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keterangan",
"type": "string",
"display": true,
"required": false,
"displayName": "Keterangan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Status"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "ffd9cfc8-34f3-4276-8dbc-bbb4924f587b",
"name": "Google シート5",
"type": "n8n-nodes-base.googleSheets",
"position": [
2600,
720
],
"parameters": {
"columns": {
"value": {
"Status": "Done",
"Keterangan": "={{ $json.Keterangan }}"
},
"schema": [
{
"id": "No",
"type": "string",
"display": true,
"required": false,
"displayName": "No",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer",
"type": "string",
"display": true,
"required": false,
"displayName": "Customer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keterangan",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keterangan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Keterangan"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "a02c8a9d-bad5-405b-8279-d724e48db6b0",
"name": "Google シート6",
"type": "n8n-nodes-base.googleSheets",
"position": [
2392,
420
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "To do",
"lookupColumn": "Status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "f6da4aec-6b74-40da-ad11-96488f6fa1e7",
"name": "Google シート7",
"type": "n8n-nodes-base.googleSheets",
"position": [
2612,
420
],
"parameters": {
"columns": {
"value": {
"Status": "To do",
"Keterangan": "={{ $('AI Agent1').item.json.output }}"
},
"schema": [
{
"id": "No",
"type": "string",
"display": true,
"required": false,
"displayName": "No",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer",
"type": "string",
"display": true,
"required": false,
"displayName": "Customer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keterangan",
"type": "string",
"display": true,
"required": false,
"displayName": "Keterangan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Status"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "e3043a9b-4b8c-41f7-a0dd-8c92b3a1ed7b",
"name": "Google シート8",
"type": "n8n-nodes-base.googleSheets",
"position": [
2840,
420
],
"parameters": {
"columns": {
"value": {
"Status": "Done",
"Keterangan": "={{ $json.Keterangan }}"
},
"schema": [
{
"id": "No",
"type": "string",
"display": true,
"required": false,
"displayName": "No",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer",
"type": "string",
"display": true,
"required": false,
"displayName": "Customer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keterangan",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keterangan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Keterangan"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "4791fa0a-0435-4125-9a2e-a820e67305ea",
"name": "スケジュールトリガー1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1220,
420
],
"parameters": {
"rule": {
"interval": [
{
"field": "seconds"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "32fb7c32-85b0-4dfb-bc53-468265e84ed3",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1320,
360
],
"parameters": {
"width": 520,
"height": 220,
"content": "## Trigger"
},
"typeVersion": 1
},
{
"id": "8e4535db-1bf9-4a1c-b687-503c2679369b",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
360
],
"parameters": {
"color": 5,
"width": 800,
"height": 220,
"content": "## Checking domain"
},
"typeVersion": 1
},
{
"id": "0d34dc17-4b3f-4d63-a48b-e233ee517d3e",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
320
],
"parameters": {
"width": 2340,
"height": 340,
"content": "## Malicious IP Scan"
},
"typeVersion": 1
},
{
"id": "d11acf2b-a5b1-4406-af80-719bb81834fd",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
660
],
"parameters": {
"color": 3,
"width": 2160,
"height": 380,
"content": "## Malicious Hostname Scan"
},
"typeVersion": 1
},
{
"id": "23d798c2-d220-49ca-9ed6-be2a7764803a",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
-20
],
"parameters": {
"color": 5,
"width": 2200,
"height": 340,
"content": "## Safe Scan"
},
"typeVersion": 1
},
{
"id": "3875bfa9-c29e-49d2-919b-5c9fcb1e620d",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
360
],
"parameters": {
"color": 7,
"width": 700,
"height": 220,
"content": "## Filter"
},
"typeVersion": 1
},
{
"id": "fbd9230e-d021-4b7f-a964-8dec0b07b28c",
"name": "Google シート10",
"type": "n8n-nodes-base.googleSheets",
"position": [
-980,
420
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "To do",
"lookupColumn": "Status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "3f29ab18-ba93-4c63-9fd6-41095b641a14",
"name": "Google シート9",
"type": "n8n-nodes-base.googleSheets",
"position": [
-100,
800
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "To do",
"lookupColumn": "Status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "57c1f7f4-4a44-4c27-8aaf-81dcccef9940",
"name": "Google シート11",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
800
],
"parameters": {
"columns": {
"value": {
"Status": "={{ $json.Status }}",
"Keterangan": "={{ $json.Keterangan }}"
},
"schema": [
{
"id": "No",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "No",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer",
"type": "string",
"display": true,
"required": false,
"displayName": "Customer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keterangan",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keterangan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Status"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "9cfc50dc-5aed-46e6-b5f6-5f6d2fbe0a52",
"name": "Google シート12",
"type": "n8n-nodes-base.googleSheets",
"position": [
360,
800
],
"parameters": {
"columns": {
"value": {
"Status": "Done",
"Keterangan": "={{ $json.Keterangan }}"
},
"schema": [
{
"id": "No",
"type": "string",
"display": true,
"required": false,
"displayName": "No",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Domain",
"type": "string",
"display": true,
"required": false,
"displayName": "Domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Customer",
"type": "string",
"display": true,
"required": false,
"displayName": "Customer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Keterangan",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Keterangan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Keterangan"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/15q0yJ4rbMdFTLUrMb9UDtYjCK_sh23OQxE8VTv0k2Tc/edit?usp=drivesdk",
"cachedResultName": "Domain Customer"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "hiZFCP2vQ7V8canv",
"name": "garrynacov"
}
},
"typeVersion": 4.6
},
{
"id": "13e1257c-473d-4d48-b758-4f8c083cbf97",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
720
],
"parameters": {
"width": 900,
"height": 260,
"content": "## Update Status False"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "4e87b79f-bdd4-497f-9d4a-0287cd334452",
"connections": {
"76fea07e-e57a-43fe-9a12-a30d7f487e8a": {
"main": [
[
{
"node": "5c68fccc-f84b-43f5-89cf-ec2bb164867f",
"type": "main",
"index": 0
},
{
"node": "45560976-d3ee-48f5-8cbf-6fa95f59afcb",
"type": "main",
"index": 0
},
{
"node": "2c2d6743-2b9a-478e-892e-177da1a2156e",
"type": "main",
"index": 0
}
]
]
},
"2c2d6743-2b9a-478e-892e-177da1a2156e": {
"main": [
[
{
"node": "b2bd2eb7-554d-4df2-8f32-279bfe669242",
"type": "main",
"index": 0
}
]
]
},
"0ee0ccc3-d9e5-42b1-90e1-bd7c6435d29d": {
"main": [
[
{
"node": "6da4c1a5-061c-4d77-ac09-d339d284275d",
"type": "main",
"index": 0
}
]
]
},
"72ae7f5e-30de-4e67-8561-f1c770a5e1e5": {
"main": [
[
{
"node": "a02c8a9d-bad5-405b-8279-d724e48db6b0",
"type": "main",
"index": 0
}
]
]
},
"608f625d-1a92-4e47-b07e-3c43a88966c5": {
"main": [
[
{
"node": "a1864a19-f8c6-4e7e-9138-4dfdd236b721",
"type": "main",
"index": 0
}
]
]
},
"18432dc2-1696-464f-8f6f-e9545958bcf4": {
"main": [
[
{
"node": "25144a23-eb3a-4dd8-b977-906a9f88cc02",
"type": "main",
"index": 0
}
]
]
},
"642fc9c6-67ac-4faa-9464-461c30a619b9": {
"main": [
[
{
"node": "76fea07e-e57a-43fe-9a12-a30d7f487e8a",
"type": "main",
"index": 0
}
]
]
},
"525aa21f-a75e-4f7c-8e95-4e558fa9d5ec": {
"main": [
[
{
"node": "0ee0ccc3-d9e5-42b1-90e1-bd7c6435d29d",
"type": "main",
"index": 0
}
]
]
},
"953db863-79ab-41a8-aabe-ebb8684cf5a8": {
"main": [
[
{
"node": "7dab5bd1-0cee-453b-9247-0bd51df200b9",
"type": "main",
"index": 0
}
]
]
},
"b2bd2eb7-554d-4df2-8f32-279bfe669242": {
"main": [
[
{
"node": "da08a6a5-0880-44f6-aba1-95a93405aa25",
"type": "main",
"index": 0
}
]
]
},
"a09ee981-7c3b-4552-a1bf-a1339b39ed02": {
"main": [
[
{
"node": "72ae7f5e-30de-4e67-8561-f1c770a5e1e5",
"type": "main",
"index": 0
}
]
]
},
"9bbd588d-dfd7-45d5-b797-79bebb670987": {
"main": [
[
{
"node": "608f625d-1a92-4e47-b07e-3c43a88966c5",
"type": "main",
"index": 0
}
]
]
},
"25144a23-eb3a-4dd8-b977-906a9f88cc02": {
"main": [
[
{
"node": "525aa21f-a75e-4f7c-8e95-4e558fa9d5ec",
"type": "main",
"index": 0
}
]
]
},
"1bec4cbb-844e-4bcc-a5dd-c2bfd7db3ea1": {
"main": [
[
{
"node": "953db863-79ab-41a8-aabe-ebb8684cf5a8",
"type": "main",
"index": 0
}
]
]
},
"45560976-d3ee-48f5-8cbf-6fa95f59afcb": {
"main": [
[
{
"node": "1bec4cbb-844e-4bcc-a5dd-c2bfd7db3ea1",
"type": "main",
"index": 0
}
]
]
},
"7dab5bd1-0cee-453b-9247-0bd51df200b9": {
"main": [
[
{
"node": "a09ee981-7c3b-4552-a1bf-a1339b39ed02",
"type": "main",
"index": 0
}
]
]
},
"da08a6a5-0880-44f6-aba1-95a93405aa25": {
"main": [
[
{
"node": "9bbd588d-dfd7-45d5-b797-79bebb670987",
"type": "main",
"index": 0
}
]
]
},
"a1864a19-f8c6-4e7e-9138-4dfdd236b721": {
"main": [
[
{
"node": "171ccfa2-ab2c-4acd-91c5-8e2a270c7e0e",
"type": "main",
"index": 0
}
]
]
},
"69bb71fe-c017-4c11-b12a-beeedd0a9d3f": {
"ai_memory": [
[
{
"node": "72ae7f5e-30de-4e67-8561-f1c770a5e1e5",
"type": "ai_memory",
"index": 0
}
]
]
},
"171ccfa2-ab2c-4acd-91c5-8e2a270c7e0e": {
"main": [
[
{
"node": "8a49881a-e6d9-425c-a47f-d27953ce3e7a",
"type": "main",
"index": 0
}
]
]
},
"6da4c1a5-061c-4d77-ac09-d339d284275d": {
"main": [
[
{
"node": "fa15fa27-7254-4952-9a08-207fab278dfd",
"type": "main",
"index": 0
}
]
]
},
"fa15fa27-7254-4952-9a08-207fab278dfd": {
"main": [
[
{
"node": "ffd9cfc8-34f3-4276-8dbc-bbb4924f587b",
"type": "main",
"index": 0
}
]
]
},
"a02c8a9d-bad5-405b-8279-d724e48db6b0": {
"main": [
[
{
"node": "f6da4aec-6b74-40da-ad11-96488f6fa1e7",
"type": "main",
"index": 0
}
]
]
},
"f6da4aec-6b74-40da-ad11-96488f6fa1e7": {
"main": [
[
{
"node": "e3043a9b-4b8c-41f7-a0dd-8c92b3a1ed7b",
"type": "main",
"index": 0
}
]
]
},
"3f29ab18-ba93-4c63-9fd6-41095b641a14": {
"main": [
[
{
"node": "57c1f7f4-4a44-4c27-8aaf-81dcccef9940",
"type": "main",
"index": 0
}
]
]
},
"32830e5e-d1f3-4a2a-88e0-c0c92e8ed0da": {
"ai_memory": [
[
{
"node": "0ee0ccc3-d9e5-42b1-90e1-bd7c6435d29d",
"type": "ai_memory",
"index": 0
}
]
]
},
"454659f6-12b8-41c0-9fce-1f460c0d8873": {
"ai_memory": [
[
{
"node": "608f625d-1a92-4e47-b07e-3c43a88966c5",
"type": "ai_memory",
"index": 0
}
]
]
},
"fbd9230e-d021-4b7f-a964-8dec0b07b28c": {
"main": [
[
{
"node": "35430b97-bc78-45f8-9c49-a995c6316fd9",
"type": "main",
"index": 0
}
]
]
},
"57c1f7f4-4a44-4c27-8aaf-81dcccef9940": {
"main": [
[
{
"node": "9cfc50dc-5aed-46e6-b5f6-5f6d2fbe0a52",
"type": "main",
"index": 0
}
]
]
},
"4791fa0a-0435-4125-9a2e-a820e67305ea": {
"main": [
[
{
"node": "fbd9230e-d021-4b7f-a964-8dec0b07b28c",
"type": "main",
"index": 0
}
]
]
},
"5c68fccc-f84b-43f5-89cf-ec2bb164867f": {
"main": [
[
{
"node": "18432dc2-1696-464f-8f6f-e9545958bcf4",
"type": "main",
"index": 0
}
],
[]
]
},
"35430b97-bc78-45f8-9c49-a995c6316fd9": {
"main": [
[
{
"node": "e56cde7e-8e27-42f4-a6ca-c71656d0fb45",
"type": "main",
"index": 0
}
]
]
},
"94dc3b70-4724-4500-b2de-4e4c5215fde3": {
"main": [
[
{
"node": "67e663f9-c426-42e4-820c-ed9b14dc1f5a",
"type": "main",
"index": 0
}
]
]
},
"728c40c0-75c8-417d-837f-44638bc3e5d5": {
"ai_languageModel": [
[
{
"node": "0ee0ccc3-d9e5-42b1-90e1-bd7c6435d29d",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"ed718b64-98c5-4aaf-b390-38289ca8a735": {
"ai_languageModel": [
[
{
"node": "72ae7f5e-30de-4e67-8561-f1c770a5e1e5",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"a10f3858-ca6e-4d59-8777-8623d91d7483": {
"ai_languageModel": [
[
{
"node": "608f625d-1a92-4e47-b07e-3c43a88966c5",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"e56cde7e-8e27-42f4-a6ca-c71656d0fb45": {
"main": [
[
{
"node": "17ac21c8-89fe-481c-8d62-80b8713e934c",
"type": "main",
"index": 0
}
]
]
},
"17ac21c8-89fe-481c-8d62-80b8713e934c": {
"main": [
[
{
"node": "94dc3b70-4724-4500-b2de-4e4c5215fde3",
"type": "main",
"index": 0
}
]
]
},
"67e663f9-c426-42e4-820c-ed9b14dc1f5a": {
"main": [
[
{
"node": "642fc9c6-67ac-4faa-9464-461c30a619b9",
"type": "main",
"index": 0
}
],
[
{
"node": "3f29ab18-ba93-4c63-9fd6-41095b641a14",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - セキュリティ運用, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
GPT-4o Vision と Claude 3.5 + セールス分析で Shopify 製品説明文を生成
GPT-4o Vision と Claude 3.5 + 販売分析を使用して、Shopify製品の説明文を生成する
If
Set
Code
+
If
Set
Code
43 ノードKumar Shivam
コンテンツ作成
AI駆動の食品注文処理システム、Facebook Messenger、Googleスプレッドシート、カレンダーとの統合
AI駆動の食品注文処理システム、Facebook Messenger、Googleスプレッドシート、カレンダーとの統合
If
Code
Webhook
+
If
Code
Webhook
26 ノードHans Wilhelm Radam
リードナーチャリング
YouTube 動画に基づく自律ブログ公開
YouTube 動画から ChatGPT、Sheets、Apify、Pexels、WordPress を使用してブログの自主公開
If
Set
Code
+
If
Set
Code
80 ノードOriol Seguí
コンテンツ作成
バッチSEOコンテンツ生成とAI画像付きWebflowドラフト作成（テンプレート）
GPT、Gemini画像、Webflowデラフトで行う大量SEOコンテンツ生成
If
Set
Code
+
If
Set
Code
54 ノードDahiana
コンテンツ作成
AIとFreepikを使用してRedditのビジネス課題をウイルスのLinkedInコンテンツに変換
AIとFreepikを使用してRedditのビジネス課題をウイルスのなLinkedInコンテンツに変換
If
Set
Code
+
If
Set
Code
48 ノードDaniel Lianes
コンテンツ作成
再生リスト詳細設定ボットコピー
Suno、GPT-4、Runway、Creatomate を使って AI 生成の YouTube ミュージックプレイリストを作成
If
Set
Code
+
If
Set
Code
203 ノードJoseph
コンテンツ作成
ワークフロー情報
難易度
上級
ノード数50
カテゴリー2
ノードタイプ9
作成者
Garri
@garriSecurity Analyst with expertise in penetration testing, threat detection, and AI-driven automation. Experienced in securing systems, identifying vulnerabilities, and building proactive security solutions. Focused on leveraging technological innovation to create safe and efficient digital environments.
外部リンク
n8n.ioで表示 →
このワークフローを共有