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.
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
The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet
Google Sheets, Google Drive, HTTP Request
🔥 March Sale – n8n Community Members Get ideoGener8r for Just $27! (Reg. $47) Use Coupon Code: (Valid until 3/31/2025 for n8n community members)
HTTP Request, Google Drive, Google Sheets
📄 Documentation: Notion Guide
Google Sheets, Google Drive, HTTP Request +2