Évaluation automatisée des contrôles PCI

Avancé

Ceci est unSecOps, AI Summarizationworkflow d'automatisation du domainecontenant 19 nœuds.Utilise principalement des nœuds comme If, Set, Code, Merge, Filter. Utiliser Google Sheets pour automatiser l'évaluation du contrôle PCI DSS et le suivi de la conformité

Prérequis
  • Informations d'identification Google Sheets API
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "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": "Lors du clic sur 'Exécuter le workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -320,
        120
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c971eaf5-e60e-4b8b-9435-2fb4d672a971",
      "name": "Réponses_PCI_Client",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        0,
        220
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "2df78789-a56d-460f-8000-9c695fd08067",
      "name": "Fusionner",
      "type": "n8n-nodes-base.merge",
      "position": [
        660,
        120
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "3ac86d72-1172-431f-9ac9-a0423bb530c8",
      "name": "contrôles",
      "type": "n8n-nodes-base.code",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "d75dd12c-fd95-47bd-ac78-55caea2b45b1",
      "name": "Normaliser l'ID Client",
      "type": "n8n-nodes-base.set",
      "position": [
        180,
        220
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "4354b8ff-a259-46e2-812b-7b113fb29dcf",
      "name": "Renommer l'ID Officiel",
      "type": "n8n-nodes-base.set",
      "position": [
        380,
        0
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "2bb57423-8d88-4d13-a0f4-4199aa13775d",
      "name": "Renommer l'ID Client",
      "type": "n8n-nodes-base.set",
      "position": [
        380,
        220
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "deb343b2-bba1-45f9-9c88-29e0d34a780f",
      "name": "Normaliser l'ID de contrôle (contrôles)",
      "type": "n8n-nodes-base.set",
      "position": [
        180,
        0
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "31908eb4-7335-489d-8546-2648d79e082e",
      "name": "Modifier les champs",
      "type": "n8n-nodes-base.set",
      "position": [
        900,
        120
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "e412d4e9-d0ac-4841-ac0d-abd2eddbd143",
      "name": "Filtrer",
      "type": "n8n-nodes-base.filter",
      "position": [
        1120,
        120
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "21142a4f-b2e8-4035-a8a5-dfd7676a0904",
      "name": "Si",
      "type": "n8n-nodes-base.if",
      "position": [
        1360,
        120
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "f9943119-94a6-4929-880b-7ad5c3391e9d",
      "name": "Modifier les champs1",
      "type": "n8n-nodes-base.set",
      "position": [
        1660,
        40
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "b1ddb48f-843b-43f5-bdf6-7e76ae9c522b",
      "name": "Modifier les champs2",
      "type": "n8n-nodes-base.set",
      "position": [
        1660,
        260
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "ce1915b9-d68a-4239-8043-6b812d85b3ad",
      "name": "Fusionner1",
      "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": "Grouper par Client",
      "type": "n8n-nodes-base.code",
      "position": [
        2380,
        140
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "51c05cbf-e8c9-4dc6-b721-07794f6716e0",
      "name": "Nombre de statuts correspondants par client",
      "type": "n8n-nodes-base.code",
      "position": [
        2560,
        140
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "81ecd957-d2b6-43ff-a258-a231f65f4ab6",
      "name": "Note adhésive",
      "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
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Avancé - Opérations de sécurité, Résumé IA

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds19
Catégorie2
Types de nœuds8
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Auteur
Adnan Tariq

Adnan Tariq

@adnantariq

Founder of CYBERPULSE AI — helping security teams and SMEs eliminate repetitive tasks through modular n8n automations. I build workflows for vulnerability triage, compliance reporting, threat intel, and Red/Blue/GRC ops. Book a session if you'd like custom automation for your use case. https://linkedin.com/in/adnan-tariq-4b2a1a47

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34