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驱动的域名与IP安全检查自动化",
"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 Agent",
"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 Chat Model",
"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": "Simple Memory1",
"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": "检查SPF1",
"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": "检查DMARC1",
"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": "检查DKIM1",
"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 Agent1",
"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 Chat Model1",
"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": "检查SPF2",
"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": "检查DMARC2",
"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": "检查DKIM2",
"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 Agent2",
"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 Sheets",
"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 Sheets1",
"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 Sheets2",
"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 Sheets3",
"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 Sheets4",
"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 Sheets5",
"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 Sheets6",
"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 Sheets7",
"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 Sheets8",
"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": "## 触发器"
},
"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": "## 检查域名"
},
"typeVersion": 1
},
{
"id": "0d34dc17-4b3f-4d63-a48b-e233ee517d3e",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
320
],
"parameters": {
"width": 2340,
"height": 340,
"content": "## 恶意IP扫描"
},
"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": "## 恶意主机名扫描"
},
"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": "## 安全扫描"
},
"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": "## 过滤器"
},
"typeVersion": 1
},
{
"id": "fbd9230e-d021-4b7f-a964-8dec0b07b28c",
"name": "Google Sheets10",
"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 Sheets9",
"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 Sheets11",
"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 Sheets12",
"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": "## 更新状态为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 + 销售分析生成
使用 GPT-4o Vision 和 Claude 3.5 + 销售分析生成 Shopify 产品描述
If
Set
Code
+
If
Set
Code
43 节点Kumar Shivam
内容创作
AI驱动的食品订单处理系统
AI驱动的食品订单处理系统，集成Facebook Messenger、Google表格和日历
If
Code
Webhook
+
If
Code
Webhook
26 节点Hans Wilhelm Radam
客户培育
基于 YouTube 视频的自主博客发布
使用 ChatGPT、Sheets、Apify、Pexels 和 WordPress 从 YouTube 视频自主发布博客
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
内容创作
1. 播放列表详情设置机器人副本
使用 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 查看 →
分享此工作流