Audit Visual SOP JSON & Generate HTML Quality Reports in n8n

Audit Visual SOP JSON and instantly generate an HTML quality report inside n8n

This workflow audits structured visual SOP JSON you submit (via an n8n Form or a manual sample), validates timing and evidence metadata, and generates a downloadable HTML report that clearly flags issues and assigns a status: blocked, needs_review, or checks_passed.

What this workflow does

• Starts from a Form submission or a manual run using either a test/example SOP JSON or JSON pasted into an n8n Form field.
• Parses and validates input, including enforcement of input size limits. If the document is invalid, it returns a structured input error.
• Audits SOP metadata by checking schema version, title, video duration, step count, step IDs, step instructions, evidence excerpts, and screenshot metadata (timestamp, filename, optional hash, caption).
• Validates step timing and evidence ordering, including timestamp ordering and overlap.
• Evaluates review metadata (pending/approved/rejected) and computes an overall status based on the number of errors and warnings.
• Renders an escaped HTML quality report with metrics, an issues table, and limitations notes.
• Outputs a downloadable file (returned on the form completion page for Form runs, or exposed for download in manual runs via the binary output).

Use cases

• QA teams validating that visual SOPs contain correct step IDs, instructions, and evidence metadata.
• SaaS operators ensuring uploaded SOP JSON follows the expected schema and timing rules.
• Automation engineers generating consistent compliance-style reports for every revision of an SOP.

Technical details

• Nodes/logic used: if, code, form, no op, sticky note, form trigger.
• Designed for SOP JSON that includes fields such as schema_version, title, video.duration_seconds, and steps with step timing and evidence (e.g., screenshot timestamp/filename/hash/caption).