Automatisierte PCI-Compliance-Bewertung

Name: Automatisierte PCI-Compliance-Bewertung
Rating: 4.5 (10 reviews)
Author: Adnan Tariq

Experte

Dies ist ein SecOps, AI Summarization-Bereich Automatisierungsworkflow mit 19 Nodes. Hauptsächlich werden If, Set, Code, Merge, Filter und andere Nodes verwendet. Automatisierung der PCI DSS-Kontrollbewertung und Compliance-Verfolgung mit Google Sheets

Voraussetzungen

•Google Sheets API-Anmeldedaten

Verwendete Nodes (19)

Kategorie

Sicherheitsbetrieb

KI-Zusammenfassung

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

Bei Klick auf 'Workflow ausführen'

Client_PCI_Responses

Zusammenführen

controls

Client-ID normalisieren

Offizielle ID umbenennen

Client-ID umbenennen

Steuerungs-ID normalisieren (controls)

Felder bearbeiten

Filtern

Wenn

Felder bearbeiten1

Felder bearbeiten2

Zusammenführen1

Code

Google Sheets

Nach Client gruppieren

Statusanzahl pro Client abgleichen

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "id": "ftH5uN0C12ktrAmA",
  "meta": {
    "instanceId": "6feff41aadeb8409737e26476f9d0a45f95eec6a9c16afff8ef87a662455b6df"
  },
  "name": "Automated PCI Control Evaluation",
  "tags": [
    {
      "id": "4m3yfV7OSc6yJuDw",
      "name": "PCI_Match_Status_Tracker",
      "createdAt": "2025-08-07T00:41:58.364Z",
      "updatedAt": "2025-08-07T00:41:58.364Z"
    }
  ],
  "nodes": [
    {
      "id": "bd48c9b2-e059-4864-a79a-35d526f892ec",
      "name": "Bei Klick auf 'Workflow ausführen'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -320,
        120
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c971eaf5-e60e-4b8b-9435-2fb4d672a971",
      "name": "Client_PCI_Responses",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        0,
        220
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "2df78789-a56d-460f-8000-9c695fd08067",
      "name": "Zusammenführen",
      "type": "n8n-nodes-base.merge",
      "position": [
        660,
        120
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "3ac86d72-1172-431f-9ac9-a0423bb530c8",
      "name": "controls",
      "type": "n8n-nodes-base.code",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "d75dd12c-fd95-47bd-ac78-55caea2b45b1",
      "name": "Client-ID normalisieren",
      "type": "n8n-nodes-base.set",
      "position": [
        180,
        220
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "4354b8ff-a259-46e2-812b-7b113fb29dcf",
      "name": "Offizielle ID umbenennen",
      "type": "n8n-nodes-base.set",
      "position": [
        380,
        0
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "2bb57423-8d88-4d13-a0f4-4199aa13775d",
      "name": "Client-ID umbenennen",
      "type": "n8n-nodes-base.set",
      "position": [
        380,
        220
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "deb343b2-bba1-45f9-9c88-29e0d34a780f",
      "name": "Steuerungs-ID normalisieren (controls)",
      "type": "n8n-nodes-base.set",
      "position": [
        180,
        0
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "31908eb4-7335-489d-8546-2648d79e082e",
      "name": "Felder bearbeiten",
      "type": "n8n-nodes-base.set",
      "position": [
        900,
        120
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "e412d4e9-d0ac-4841-ac0d-abd2eddbd143",
      "name": "Filtern",
      "type": "n8n-nodes-base.filter",
      "position": [
        1120,
        120
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "21142a4f-b2e8-4035-a8a5-dfd7676a0904",
      "name": "Wenn",
      "type": "n8n-nodes-base.if",
      "position": [
        1360,
        120
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "f9943119-94a6-4929-880b-7ad5c3391e9d",
      "name": "Felder bearbeiten1",
      "type": "n8n-nodes-base.set",
      "position": [
        1660,
        40
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "b1ddb48f-843b-43f5-bdf6-7e76ae9c522b",
      "name": "Felder bearbeiten2",
      "type": "n8n-nodes-base.set",
      "position": [
        1660,
        260
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "ce1915b9-d68a-4239-8043-6b812d85b3ad",
      "name": "Zusammenführen1",
      "type": "n8n-nodes-base.merge",
      "position": [
        1960,
        140
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "c27bbd0b-b008-4151-94c0-41d5a5ec57c1",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        2180,
        140
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "78ee0bb7-0707-42ef-93c0-23af232ed5ef",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2760,
        140
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "0916ba4d-45e4-485e-b8e5-7bbab2b9eb9a",
      "name": "Nach Client gruppieren",
      "type": "n8n-nodes-base.code",
      "position": [
        2380,
        140
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "51c05cbf-e8c9-4dc6-b721-07794f6716e0",
      "name": "Statusanzahl pro Client abgleichen",
      "type": "n8n-nodes-base.code",
      "position": [
        2560,
        140
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "81ecd957-d2b6-43ff-a258-a231f65f4ab6",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        520,
        500
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "e128a0ef-dde7-4510-ab27-025420089d73",
  "connections": {
    "21142a4f-b2e8-4035-a8a5-dfd7676a0904": {
      "main": [
        [
          {
            "node": "f9943119-94a6-4929-880b-7ad5c3391e9d",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "b1ddb48f-843b-43f5-bdf6-7e76ae9c522b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c27bbd0b-b008-4151-94c0-41d5a5ec57c1": {
      "main": [
        [
          {
            "node": "0916ba4d-45e4-485e-b8e5-7bbab2b9eb9a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2df78789-a56d-460f-8000-9c695fd08067": {
      "main": [
        [
          {
            "node": "31908eb4-7335-489d-8546-2648d79e082e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e412d4e9-d0ac-4841-ac0d-abd2eddbd143": {
      "main": [
        [
          {
            "node": "21142a4f-b2e8-4035-a8a5-dfd7676a0904",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ce1915b9-d68a-4239-8043-6b812d85b3ad": {
      "main": [
        [
          {
            "node": "c27bbd0b-b008-4151-94c0-41d5a5ec57c1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3ac86d72-1172-431f-9ac9-a0423bb530c8": {
      "main": [
        [
          {
            "node": "deb343b2-bba1-45f9-9c88-29e0d34a780f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "31908eb4-7335-489d-8546-2648d79e082e": {
      "main": [
        [
          {
            "node": "e412d4e9-d0ac-4841-ac0d-abd2eddbd143",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f9943119-94a6-4929-880b-7ad5c3391e9d": {
      "main": [
        [
          {
            "node": "ce1915b9-d68a-4239-8043-6b812d85b3ad",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b1ddb48f-843b-43f5-bdf6-7e76ae9c522b": {
      "main": [
        [
          {
            "node": "ce1915b9-d68a-4239-8043-6b812d85b3ad",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "0916ba4d-45e4-485e-b8e5-7bbab2b9eb9a": {
      "main": [
        [
          {
            "node": "51c05cbf-e8c9-4dc6-b721-07794f6716e0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2bb57423-8d88-4d13-a0f4-4199aa13775d": {
      "main": [
        [
          {
            "node": "2df78789-a56d-460f-8000-9c695fd08067",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "4354b8ff-a259-46e2-812b-7b113fb29dcf": {
      "main": [
        [
          {
            "node": "2df78789-a56d-460f-8000-9c695fd08067",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d75dd12c-fd95-47bd-ac78-55caea2b45b1": {
      "main": [
        [
          {
            "node": "2bb57423-8d88-4d13-a0f4-4199aa13775d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c971eaf5-e60e-4b8b-9435-2fb4d672a971": {
      "main": [
        [
          {
            "node": "d75dd12c-fd95-47bd-ac78-55caea2b45b1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "51c05cbf-e8c9-4dc6-b721-07794f6716e0": {
      "main": [
        [
          {
            "node": "78ee0bb7-0707-42ef-93c0-23af232ed5ef",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "deb343b2-bba1-45f9-9c88-29e0d34a780f": {
      "main": [
        [
          {
            "node": "4354b8ff-a259-46e2-812b-7b113fb29dcf",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bd48c9b2-e059-4864-a79a-35d526f892ec": {
      "main": [
        [
          {
            "node": "c971eaf5-e60e-4b8b-9435-2fb4d672a971",
            "type": "main",
            "index": 0
          },
          {
            "node": "3ac86d72-1172-431f-9ac9-a0423bb530c8",
            "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, KI-Zusammenfassung

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.