Adnan Tariq This workflow corresponds to n8n.io template #7077 — we link there as the canonical source.
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": "ftH5uN0C12ktrAmA",
"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": "When clicking \u2018Execute workflow\u2019",
"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": "Merge",
"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": "Normalize Client ID",
"type": "n8n-nodes-base.set",
"position": [
180,
220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "4354b8ff-a259-46e2-812b-7b113fb29dcf",
"name": "Rename Official ID",
"type": "n8n-nodes-base.set",
"position": [
380,
0
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2bb57423-8d88-4d13-a0f4-4199aa13775d",
"name": "Rename Client ID",
"type": "n8n-nodes-base.set",
"position": [
380,
220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "deb343b2-bba1-45f9-9c88-29e0d34a780f",
"name": "Normalize Control ID (controls)",
"type": "n8n-nodes-base.set",
"position": [
180,
0
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "31908eb4-7335-489d-8546-2648d79e082e",
"name": "Edit Fields",
"type": "n8n-nodes-base.set",
"position": [
900,
120
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "e412d4e9-d0ac-4841-ac0d-abd2eddbd143",
"name": "Filter",
"type": "n8n-nodes-base.filter",
"position": [
1120,
120
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "21142a4f-b2e8-4035-a8a5-dfd7676a0904",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
1360,
120
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f9943119-94a6-4929-880b-7ad5c3391e9d",
"name": "Edit Fields1",
"type": "n8n-nodes-base.set",
"position": [
1660,
40
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "b1ddb48f-843b-43f5-bdf6-7e76ae9c522b",
"name": "Edit Fields2",
"type": "n8n-nodes-base.set",
"position": [
1660,
260
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "ce1915b9-d68a-4239-8043-6b812d85b3ad",
"name": "Merge1",
"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": "Group By Client",
"type": "n8n-nodes-base.code",
"position": [
2380,
140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "51c05cbf-e8c9-4dc6-b721-07794f6716e0",
"name": "Match Status Count Per Client",
"type": "n8n-nodes-base.code",
"position": [
2560,
140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "81ecd957-d2b6-43ff-a258-a231f65f4ab6",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
500
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "e128a0ef-dde7-4510-ab27-025420089d73",
"connections": {
"If": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
],
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Group By Client",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Filter": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Merge1": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"controls": {
"main": [
[
{
"node": "Normalize Control ID (controls)",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields2": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 1
}
]
]
},
"Group By Client": {
"main": [
[
{
"node": "Match Status Count Per Client",
"type": "main",
"index": 0
}
]
]
},
"Rename Client ID": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Rename Official ID": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Normalize Client ID": {
"main": [
[
{
"node": "Rename Client ID",
"type": "main",
"index": 0
}
]
]
},
"Client_PCI_Responses": {
"main": [
[
{
"node": "Normalize Client ID",
"type": "main",
"index": 0
}
]
]
},
"Match Status Count Per Client": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Normalize Control ID (controls)": {
"main": [
[
{
"node": "Rename Official ID",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Client_PCI_Responses",
"type": "main",
"index": 0
},
{
"node": "controls",
"type": "main",
"index": 0
}
]
]
}
}
}
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/7077/ — 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.
TrackCollect_deeper. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 80 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +1
This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.
HTTP Request, Gmail, Twilio +3
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +3
Product Ad Machine. Uses googleDrive, googleSheets, httpRequest, @ffmpeg-micro/n8n-nodes-ffmpeg-micro. Event-driven trigger; 60 nodes.
Google Drive, Google Sheets, HTTP Request +2
Basic AI SEO KW Research n8n DataForSEO Gumroad 030125. Uses googleSheets, googleDrive, httpRequest. Event-driven trigger; 56 nodes.
Google Sheets, Google Drive, HTTP Request