AI-Powered Domain & IP Security Check Automation

Experte

Dies ist ein SecOps, Multimodal AI-Bereich Automatisierungsworkflow mit 50 Nodes. Hauptsächlich werden If, Code, HttpRequest, GoogleSheets, Agent und andere Nodes verwendet.

Voraussetzungen
  • Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • Google Sheets API-Anmeldedaten
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in 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": "Domain-Rescan anfordern",
      "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": "Domain-Bericht abrufen",
      "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-/Dateianalyse abrufen",
      "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": "Domain-IP-Auflösungen",
      "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": "Auflösung",
      "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": "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": "KI-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 Prüfung Domain Gefunden Oder Nicht Gefunden",
      "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": "Bösartiger 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": "SPF prüfen",
      "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 prüfen",
      "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 prüfen",
      "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 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": {
          "id": "xK7zjTkwyUFnsMnV",
          "name": "AbuseIP"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "953db863-79ab-41a8-aabe-ebb8684cf5a8",
      "name": "SPF prüfen1",
      "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 prüfen1",
      "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 prüfen1",
      "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": "Bösartige 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": "KI-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": "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": "Sicher",
      "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 prüfen2",
      "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 prüfen2",
      "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 prüfen2",
      "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": "KI-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": {
          "id": "TVcfTotfslzS3LcN",
          "name": "OpenRouter account"
        }
      },
      "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": {
          "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": "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": {
          "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": "Sticky Note6",
      "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
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Experte - Sicherheitsbetrieb, Multimodales KI

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes50
Kategorie2
Node-Typen9
Schwierigkeitsbeschreibung

Für fortgeschrittene Benutzer, komplexe Workflows mit 16+ Nodes

Autor
Garri

Garri

@garri

Security 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.

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34