{"product_id":"n8n-sub-workflow-redact-personal-data-via-data-tables-discord","title":"n8n Sub-Workflow: Redact Personal Data via Data Tables \u0026 Discord","description":"\u003ch3\u003eRedact personal data automatically—without breaking your n8n workflows\u003c\/h3\u003e\n\u003cp\u003eThis n8n sub-workflow scans incoming payloads for common personal data (like email addresses, IBANs, payment cards, phone numbers, and IPv4s), redacts what it detects using policy rules stored in n8n Data Tables, and returns both the redacted result and a clear detection report. It also writes an audit trail to a \u003cstrong\u003eredaction_log\u003c\/strong\u003e table and can notify via Discord.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAccepts calls from other workflows\u003c\/strong\u003e via an \u003cem\u003eExecute Workflow Trigger\u003c\/em\u003e, optionally receiving \u003ccode\u003epayload\u003c\/code\u003e and \u003ccode\u003erequested_by\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads redaction settings from\u003c\/strong\u003e the \u003cstrong\u003eredaction_policy\u003c\/strong\u003e Data Table and attaches the active policy to each incoming item.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScans all strings in the payload\u003c\/strong\u003e and detects:\n    \u003cul\u003e\n      \u003cli\u003eEmail addresses\u003c\/li\u003e\n      \u003cli\u003eIBANs (validated with \u003cstrong\u003emod-97\u003c\/strong\u003e)\u003c\/li\u003e\n      \u003cli\u003ePayment cards (validated with \u003cstrong\u003eLuhn\u003c\/strong\u003e)\u003c\/li\u003e\n      \u003cli\u003ePhone numbers\u003c\/li\u003e\n      \u003cli\u003eIPv4 addresses\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRedacts using the configured mode\u003c\/strong\u003e (mask, pseudonymise, or remove) and never exposes original sensitive values in reports.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a redaction report\u003c\/strong\u003e including counts per detector and lists any “unclassified” candidates (e.g., long digit runs or possible names) without altering them.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites an audit entry\u003c\/strong\u003e to the \u003cstrong\u003eredaction_log\u003c\/strong\u003e Data Table, capturing counts, mode, requester, and payload size.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns\u003c\/strong\u003e the redacted payload and report back to the calling workflow.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProtecting customer data when relaying events to internal tools or dashboards.\u003c\/li\u003e\n  \u003cli\u003eSanitizing logs before storing them in databases or sending them to third parties.\u003c\/li\u003e\n  \u003cli\u003eImplementing consistent GDPR\/PII-style redaction across multiple n8n workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes used: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ediscord\u003c\/strong\u003e, \u003cstrong\u003edata table\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eRelies on \u003cstrong\u003en8n Data Tables\u003c\/strong\u003e: \u003ccode\u003eredaction_policy\u003c\/code\u003e and \u003ccode\u003eredaction_log\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003eSupports a setup\/self-test path: \u003cstrong\u003e“Set Up And Self Test (run once)”\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eIncludes optional \u003cstrong\u003eDiscord\u003c\/strong\u003e self-test notification\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46008758239411,"sku":"N8N-19499","price":41.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/1E8O2W8d8WxLMT3sF6yK4_Maw89IRe.png?v=1789204165","url":"https:\/\/buyflowscripts.com\/products\/n8n-sub-workflow-redact-personal-data-via-data-tables-discord","provider":"N8N Commerce","version":"1.0","type":"link"}