This workflow corresponds to n8n.io template #6511 — we link there as the canonical source.
This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.
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": "Pk4Ou8ITce0vjJHj",
"name": "\ud83d\udd34 RedOps Module 6 - Auto_Report",
"tags": [
{
"id": "uNqHAlvBtMsP4gFd",
"name": "Pro",
"createdAt": "2025-07-07T09:34:20.437Z",
"updatedAt": "2025-07-07T09:34:20.437Z"
}
],
"nodes": [
{
"id": "89a7108d-7f35-427b-9e0a-b188fdd22a06",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "dfe20b6f-cf49-4c46-b597-a5903510ab6b",
"name": "\ud83d\udd52 Trigger AutoReport",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1840,
40
],
"parameters": {},
"typeVersion": 1
},
{
"id": "059c0784-4981-480d-977e-314f6c27ee03",
"name": "\ud83d\udcc4 Read Trap Log Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1620,
40
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "5187baa9-a247-4dea-96b7-e7d49b62c246",
"name": "\ud83d\udcca Format Report Data",
"type": "n8n-nodes-base.code",
"position": [
-1400,
40
],
"parameters": {},
"typeVersion": 2
},
{
"id": "053fb8f2-5e90-458c-9cd1-59cb96e27572",
"name": "\ud83d\udcd1 Build HTML Report Summary",
"type": "n8n-nodes-base.code",
"position": [
-1180,
40
],
"parameters": {},
"typeVersion": 2
},
{
"id": "aec2f987-c61a-459e-82ee-b439af67b9bb",
"name": "\ud83d\udce7 Send Summary Email",
"type": "n8n-nodes-base.gmail",
"position": [
-960,
40
],
"parameters": {},
"typeVersion": 2.1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "fb18e6b4-0a37-453b-a24d-e36437e2b41c",
"connections": {
"\ud83d\udcca Format Report Data": {
"main": [
[
{
"node": "\ud83d\udcd1 Build HTML Report Summary",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udd52 Trigger AutoReport": {
"main": [
[
{
"node": "\ud83d\udcc4 Read Trap Log Sheet",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udcc4 Read Trap Log Sheet": {
"main": [
[
{
"node": "\ud83d\udcca Format Report Data",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udcd1 Build HTML Report Summary": {
"main": [
[
{
"node": "\ud83d\udce7 Send Summary Email",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Automatically compiles a daily HTML report of all RedOps simulations (Modules 1–5), summarizing offensive activity, response logs, and module effectiveness. Designed for GRC teams, Red/Purple teams, and internal auditors — no manual formatting required.
Source: https://n8n.io/workflows/6511/ — 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.
Loan eligibility workflow. Uses formTrigger, googleSheets, gmail. Event-driven trigger; 53 nodes.
Splitout Code. Uses manualTrigger, httpRequest, stickyNote, splitOut. Event-driven trigger; 46 nodes.
Automate CSV imports into HubSpot without the mess. Powered by n8n. Supercharged by Pollup AI.
AICARE Email Blast System. Uses googleDrive, httpRequest, googleSheets, gmail. Event-driven trigger; 39 nodes.
Telegram Code. Uses stickyNote, telegramTrigger, telegram, googleDrive. Event-driven trigger; 37 nodes.