A custom, self-hosted n8n automation infrastructure built to entirely digitize and streamline the issuance of police clearances. This project integrates Google Sheets, Discord webhooks, and dynamic n8n web forms to create a seamless, end-to-end approval pipeline for law enforcement personnel.
Project Overview Manual data entry and disjointed communication often slow down bureaucratic processes. To solve this, I deployed a self-hosted instance of n8n, a powerful node-based workflow automation tool, to act as the backend engine for a digital Police Clearance system. By connecting various APIs and webhooks, this project transforms a static application process into a highly responsive, automated pipeline.
The Ingestion Pipeline The lifecycle of a clearance request begins with the Police Clearance Generator workflow. Utilizing a Google Sheets Trigger, the system polls the primary database for new form responses every minute. Once a new row is detected, the workflow normalizes the applicant's data and runs a deduplication check to prevent spam or accidental double-submissions. If the application is unique, it routes the payload to the next stage of the pipeline.
Interactive Discord Routing To keep law enforcement officers within their primary communication tools, the pipeline utilizes Discord as an interactive triage hub. The n8n workflow constructs and pushes a rich embed directly to a secure Discord channel. This alert contains the critical details of the applicant and features interactive Action Buttons, allowing officers to immediately initiate the review process without needing to log into a separate dashboard.
Officer Review & Final Processing Clicking the action buttons in Discord seamlessly redirects the reviewing officer to a dynamic n8n Web Form customized for Police Clearance review. The form automatically pre-fills the applicant's First Name and Surname based on the ingested parameters. Here, the officer inputs their official findings (e.g., "NO DEROGATORY RECORD ON FILE") and selects the final action (Approve or Deny). Once submitted, the Approval Workflow takes over. It assesses the form's payload, checks for static idempotency, and utilizes a branching logic node to determine the outcome. It then fires off the final webhooks—either generating a failure/denial alert or issuing the official approval notice back to the designated Discord channels.
A dual-workflow n8n automation architecture built to handle the rigorous administrative overhead of digital law enforcement departments. This setup tracks live officer attendance, structures payroll data, and instantly pipelines arrest reports into active dispatch channels.
Read More
