{"product_id":"n8n-workflow-inventory-personal-data-in-data-tables","title":"n8n Workflow: Inventory Personal Data in Data Tables","description":"\u003ch3\u003eInventory personal data in your n8n Data Tables—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans all (non-excluded) \u003cstrong\u003en8n Data Tables\u003c\/strong\u003e to inventory personal data, identifies sensitive columns using regex patterns and Groq-assisted classification, and logs the results into dedicated Data Tables. If any \u003cstrong\u003especial-category data\u003c\/strong\u003e (health, biometric, belief, criminal) is detected, it also sends an alert to \u003cstrong\u003eDiscord\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand\u003c\/strong\u003e or on a schedule every \u003cstrong\u003eMonday at 07:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eLoads scan settings and detection patterns from the \u003cstrong\u003en8n Data Table pattern store\u003c\/strong\u003e, then enumerates all Data Tables on the instance while skipping excluded table names.\u003c\/li\u003e\n  \u003cli\u003eFor each table, \u003cstrong\u003esamples a few rows\u003c\/strong\u003e and classifies each column using \u003cstrong\u003ename and value regexes\u003c\/strong\u003e while masking sampled values into non-sensitive “shapes.”\u003c\/li\u003e\n  \u003cli\u003eSends only \u003cstrong\u003ecolumn names and masked shapes\u003c\/strong\u003e for ambiguous candidates to \u003cstrong\u003eGroq\u003c\/strong\u003e, which proposes the table purpose and additional personal-data columns.\u003c\/li\u003e\n  \u003cli\u003eStores a run summary in \u003cstrong\u003epdi_runs\u003c\/strong\u003e and upserts one inventory record per detected column into \u003cstrong\u003epdi_inventory\u003c\/strong\u003e (including category, sensitivity, confidence, source, evidence, and sample shape).\u003c\/li\u003e\n  \u003cli\u003ePosts a \u003cstrong\u003eDiscord webhook alert\u003c\/strong\u003e when special-category columns are found.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAudit a SaaS automation environment by cataloging personal-data fields across multiple n8n Data Tables.\u003c\/li\u003e\n  \u003cli\u003eHelp operators prepare for privacy reviews by producing a structured inventory (confidence + evidence + masked shape).\u003c\/li\u003e\n  \u003cli\u003eContinuously reduce risk as tables change by running the scan weekly and flagging special-category data.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq integration\u003c\/strong\u003e: requires a Groq API credential for the Groq chat model node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDiscord integration\u003c\/strong\u003e: uses a Discord webhook credential to post special-category alerts.\u003c\/li\u003e\n  \u003cli\u003eUses nodes including \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, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIncludes a setup step: “\u003cstrong\u003eSet Up Tables\u003c\/strong\u003e” to initialize the required Data Tables.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45967527313587,"sku":"N8N-19268","price":14.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/lRRh6XkTCmapBdeT3Q5iU_LZefC1Ev.png?v=1788685612","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-inventory-personal-data-in-data-tables","provider":"N8N Commerce","version":"1.0","type":"link"}