Log Québec Law 25 confidentiality incidents with forms, Data Tables and email
Ready for 3.0What this workflow does
This workflow has 25 nodes and runs when someone submits an n8n form (“Record a confidentiality incident”) (plus 3 other triggers). It uses only n8n's built-in nodes.
How it runs
Trigger: When someone submits an n8n form (“Record a confidentiality incident”) (plus 3 other triggers).
- Build register entry (Code): runs custom JavaScript code
- Create register table if missing (update) (Data table): create (table)
- Settings (Edit Fields (Set)): sets 3 fields: privacy_officer_email, from_email, assess_within_days
- Create register table if missing (export) (Data table): create (table)
- Create register table if missing (Data table): create (table)
- Show why nothing was saved (n8n Form): shows the next form page
- Find the incident (Data table): get (row)
- Create register table if missing (reminder) (Data table): create (table)
- Get all incidents (export) (Data table): get (row)
- Keep register columns only (Code): runs custom JavaScript code
…plus 11 more steps. See the full node list below.
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Code
n8n-nodes-base.code - Data table
n8n-nodes-base.dataTable - n8n Form
n8n-nodes-base.form - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Send Email
n8n-nodes-base.emailSend - Manual Trigger
n8n-nodes-base.manualTrigger - Convert to File
n8n-nodes-base.convertToFile
From the author
Quick overview This workflow captures Québec Law 25 confidentiality incidents via n8n Forms, stores them in an n8n Data Table register, sends daily email reminders for incidents needing action, and supports manual export of the register to an Excel file. How…