Garri This workflow corresponds to n8n.io template #7189 — we link there as the canonical source.
This workflow follows the Agent → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "Tq8FAps9IX5ag1BD",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "AI-Powered Domain & IP Security Check Automation",
"tags": [],
"nodes": [
{
"id": "e56cde7e-8e27-42f4-a6ca-c71656d0fb45",
"name": "Request an domain rescan",
"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": {
"name": "<your credential>"
}
},
"typeVersion": 4.2,
"extendsCredential": "virusTotalApi"
},
{
"id": "35430b97-bc78-45f8-9c49-a995c6316fd9",
"name": "Get a domain report",
"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": {
"name": "<your credential>"
}
},
"typeVersion": 4.2,
"extendsCredential": "virusTotalApi"
},
{
"id": "17ac21c8-89fe-481c-8d62-80b8713e934c",
"name": "Get a URL / file analysis",
"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": {
"name": "<your credential>"
}
},
"typeVersion": 4.2,
"extendsCredential": "virusTotalApi"
},
{
"id": "94dc3b70-4724-4500-b2de-4e4c5215fde3",
"name": "Domain-IP resolutions",
"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": {
"name": "<your credential>"
}
},
"typeVersion": 4.2,
"extendsCredential": "virusTotalApi"
},
{
"id": "642fc9c6-67ac-4faa-9464-461c30a619b9",
"name": "Resolution",
"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": {
"name": "<your credential>"
}
},
"typeVersion": 4.2,
"extendsCredential": "virusTotalApi"
},
{
"id": "76fea07e-e57a-43fe-9a12-a30d7f487e8a",
"name": "Code",
"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 Checking Domain Found Or Not Found",
"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": "Malicious Hostname",
"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": "check 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": "check 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": "check 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": {
"name": "<your credential>"
}
},
"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 Request",
"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": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "953db863-79ab-41a8-aabe-ebb8684cf5a8",
"name": "check 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": "check 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": "check 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": "Malicious 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": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "69bb71fe-c017-4c11-b12a-beeedd0a9d3f",
"name": "Simple Memory",
"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": "Safe",
"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": "check 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": "check 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": "check 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 Chat Model2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
1640,
200
],
"parameters": {
"options": {}
},
"credentials": {
"openRouterApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "454659f6-12b8-41c0-9fce-1f460c0d8873",
"name": "Simple Memory2",
"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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "4791fa0a-0435-4125-9a2e-a820e67305ea",
"name": "Schedule Trigger1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1220,
420
],
"parameters": {
"rule": {
"interval": [
{
"field": "seconds"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "32fb7c32-85b0-4dfb-bc53-468265e84ed3",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1320,
360
],
"parameters": {
"width": 520,
"height": 220,
"content": "## Trigger"
},
"typeVersion": 1
},
{
"id": "8e4535db-1bf9-4a1c-b687-503c2679369b",
"name": "Sticky Note1",
"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": "Sticky Note2",
"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": "Sticky Note3",
"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": "Sticky Note4",
"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": "Sticky Note5",
"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 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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"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": {
"name": "<your credential>"
}
},
"typeVersion": 4.6
},
{
"id": "13e1257c-473d-4d48-b758-4f8c083cbf97",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
720
],
"parameters": {
"width": 900,
"height": 260,
"content": "## Update Status False"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "4e87b79f-bdd4-497f-9d4a-0287cd334452",
"connections": {
"Code": {
"main": [
[
{
"node": "Malicious Hostname",
"type": "main",
"index": 0
},
{
"node": "Malicious IP",
"type": "main",
"index": 0
},
{
"node": "Safe",
"type": "main",
"index": 0
}
]
]
},
"Safe": {
"main": [
[
{
"node": "check SPF2",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"AI Agent1": {
"main": [
[
{
"node": "Google Sheets6",
"type": "main",
"index": 0
}
]
]
},
"AI Agent2": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"check SPF": {
"main": [
[
{
"node": "check DMARC",
"type": "main",
"index": 0
}
]
]
},
"Resolution": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"check DKIM": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"check SPF1": {
"main": [
[
{
"node": "check DMARC1",
"type": "main",
"index": 0
}
]
]
},
"check SPF2": {
"main": [
[
{
"node": "check DMARC2",
"type": "main",
"index": 0
}
]
]
},
"check DKIM1": {
"main": [
[
{
"node": "AI Agent1",
"type": "main",
"index": 0
}
]
]
},
"check DKIM2": {
"main": [
[
{
"node": "AI Agent2",
"type": "main",
"index": 0
}
]
]
},
"check DMARC": {
"main": [
[
{
"node": "check DKIM",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "check SPF1",
"type": "main",
"index": 0
}
]
]
},
"Malicious IP": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"check DMARC1": {
"main": [
[
{
"node": "check DKIM1",
"type": "main",
"index": 0
}
]
]
},
"check DMARC2": {
"main": [
[
{
"node": "check DKIM2",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Simple Memory": {
"ai_memory": [
[
{
"node": "AI Agent1",
"type": "ai_memory",
"index": 0
}
]
]
},
"Google Sheets1":
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApihttpHeaderAuthopenRouterApivirusTotalApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Description
Source: https://n8n.io/workflows/7189/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow is for beauty salons who want consistent, high‑quality social media content without writing every post manually. It also suits agencies and automation builders who manage multiple beauty
Telegram, Google Sheets Trigger, Agent +26
This n8n workflow turns a script and character/setting description from Google Sheets into a complete stitched UGC-style video ad, fully automated from intake to final delivery.
Google Sheets, HTTP Request, OpenRouter Chat +7
This workflow automates the creation, rendering, approval, and posting of TikTok-style POV (Point of View) videos to Instagram, with cross-posting to Facebook and YouTube. It eliminates manual video p
OpenAI Chat, Output Parser Item List, HTTP Request +10
This workflow was born out of a very real problem.
Output Parser Structured, OpenAI Chat, Memory Buffer Window +11
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Output Parser Structured, Telegram, N8N Nodes Tesseractjs +14