automation-workflows

web-applications

Project Overview

Managing a structured law enforcement unit requires immaculate record-keeping and instant communication. Designed perfectly for high-stakes organizational and legal scenarios—such as those found within complex San Andreas Multiplayer (SAMP) communities—this self-hosted n8n infrastructure acts as an automated dispatch and HR backend. By linking Google Sheets databases directly to active Discord servers via webhooks, these workflows eliminate manual data entry and keep faction command updated in real time.

Live Attendance & Shift Tracking

The SAMP PD Attendance & Payroll Workflow handles the logistical nightmare of tracking officer hours. Utilizing a Google Sheets trigger set to poll every minute, the system listens for new entries in the departmental attendance logs. It normalizes the data and evaluates whether the entry is a "Time-In" or "Time-Out." Depending on the shift status, n8n constructs a formatted webhook and pushes a live attendance feed directly to a designated Discord channel, providing high command with an immediate view of active, on-duty personnel.

Automated Arrest Report Ingestion

To maintain a strict chain of custody and instant situational awareness, the LVPNP Arrest Report Workflow digitizes the booking process. When an officer files a new arrest report, the n8n pipeline immediately ingests the data. To prevent system spam or double-entries during high-stress scenarios, the workflow utilizes a custom code node to claim a static "Send Lock," effectively deduplicating the submissions.

Once cleared, the workflow formats the arrest details—such as the suspect's information, charges, and processing officer—and broadcasts an official embed to the internal Discord records channel. This ensures that the entire faction has immediate, searchable access to the latest arrests without needing to manually cross-reference external spreadsheets.

Project Overview

Managing a structured law enforcement unit requires immaculate record-keeping and instant communication. Designed perfectly for high-stakes organizational and legal scenarios—such as those found within complex San Andreas Multiplayer (SAMP) communities—this self-hosted n8n infrastructure acts as an automated dispatch and HR backend. By linking Google Sheets databases directly to active Discord servers via webhooks, these workflows eliminate manual data entry and keep faction command updated in real time.

Live Attendance & Shift Tracking

The SAMP PD Attendance & Payroll Workflow handles the logistical nightmare of tracking officer hours. Utilizing a Google Sheets trigger set to poll every minute, the system listens for new entries in the departmental attendance logs. It normalizes the data and evaluates whether the entry is a "Time-In" or "Time-Out." Depending on the shift status, n8n constructs a formatted webhook and pushes a live attendance feed directly to a designated Discord channel, providing high command with an immediate view of active, on-duty personnel.

Automated Arrest Report Ingestion

To maintain a strict chain of custody and instant situational awareness, the LVPNP Arrest Report Workflow digitizes the booking process. When an officer files a new arrest report, the n8n pipeline immediately ingests the data. To prevent system spam or double-entries during high-stress scenarios, the workflow utilizes a custom code node to claim a static "Send Lock," effectively deduplicating the submissions.

Once cleared, the workflow formats the arrest details—such as the suspect's information, charges, and processing officer—and broadcasts an official embed to the internal Discord records channel. This ensures that the entire faction has immediate, searchable access to the latest arrests without needing to manually cross-reference external spreadsheets.

A dual-workflow n8n automation architecture built to handle the rigorous administrative overhead of digital law enforcement departments.

Self-Hosted n8n Automation: Law Enforcement Operations Ecosystem

Introduction & Architectural Overview

Modern AI applications require more than just an API connection to a language model; they demand state management, precise intent routing, and dependable memory. Memorae is a production-ready, event-driven personal study assistant built on n8n that orchestrates complex task branches based on user intents sent via Telegram.

Instead of routing every single input through an expensive LLM context window, the system uses a custom JavaScript-based Intent Router as a first-line triage layer. This seamlessly separates workflow tracks into standard conversational AI, a localized note-saving ingestion vector pipeline, and a dynamic natural language scheduling agent.

Core Architectural Components

Intelligent Traffic Triage & Intent Routing:
Incoming messages are instantly filtered to block bots and non-text formats. A centralized JavaScript engine dynamically evaluates textual regular expressions and command sequences (e.g., remember that..., remind me to...). It assigns a clean intent payload (chat, note, reminder, or clarify) before forwarding execution to specialized n8n Switch nodes.

The Legal RAG Pipeline (Knowledge Injection):
For conversational queries, the workflow activates a Legal RAG Agent backed by an Azure OpenAI chat model (gpt-oss-120b). It leverages a Qdrant Vector Store database (personal_vault) linked with text-embedding-3-small embeddings. If a user asks to recall custom data, the agent dynamically utilizes its tools to retrieve grounded information.

Localized Natural Language Reminder Engine:
When handling scheduling, a dedicated Reminder AI Agent extracts entities (task, when_text) into structured JSON. A robust JavaScript scheduling block parses time phrases like "tomorrow at 3pm" or "in 2 hours", actively normalizing relative timestamps explicitly to the Asia/Manila (PHT) timezone. Reminders are saved into workflow static data, and an independent cron-like trigger polls every 60 seconds to fire due events.

Inversion-Resistant HTML Processing & Error Handling:
Because Telegram relies strictly on safe HTML tags over standard Markdown, the workflow features automated string parsing to escape unauthorized characters dynamically. Additionally, a dedicated global Error Trigger branch acts as a circuit breaker, trapping script runtime failures and alerting the administrator via direct system logs.

The Technical Stack

Orchestration Engine: n8n (Advanced Workflow/Execution Model)

LLM & Embedding Layers: LangChain Integration, Azure OpenAI (gpt-oss-120b), text-embedding-3-small

Vector Database: Qdrant (Collection: personal_vault)

Interface Gateway: Telegram Bot API

Runtime Utilities: Node.js / JavaScript (Intl API, Timezone wall-clock transformations)

Key Engineering Takeaways

Reduced Token Overhead: By utilizing a code-based router ahead of the LangChain agents, trivial actions like saving text snippets completely bypass expensive LLM token usage.

Reliable Time Calculations: Solved the common serverless issue of native UTC system clocks by utilizing strict Intl.DateTimeFormat array reduction, maintaining clock accuracy across relative multi-day offsets.

Message Stream Chunking: Implemented a recursive script that splits LLM answers longer than 4,000 characters along natural sentence breaks (\n\n) to conform directly to strict chat platform maximum payload boundaries.

Introduction & Architectural Overview

Modern AI applications require more than just an API connection to a language model; they demand state management, precise intent routing, and dependable memory. Memorae is a production-ready, event-driven personal study assistant built on n8n that orchestrates complex task branches based on user intents sent via Telegram.

Instead of routing every single input through an expensive LLM context window, the system uses a custom JavaScript-based Intent Router as a first-line triage layer. This seamlessly separates workflow tracks into standard conversational AI, a localized note-saving ingestion vector pipeline, and a dynamic natural language scheduling agent.

Core Architectural Components

Intelligent Traffic Triage & Intent Routing:
Incoming messages are instantly filtered to block bots and non-text formats. A centralized JavaScript engine dynamically evaluates textual regular expressions and command sequences (e.g., remember that..., remind me to...). It assigns a clean intent payload (chat, note, reminder, or clarify) before forwarding execution to specialized n8n Switch nodes.

The Legal RAG Pipeline (Knowledge Injection):
For conversational queries, the workflow activates a Legal RAG Agent backed by an Azure OpenAI chat model (gpt-oss-120b). It leverages a Qdrant Vector Store database (personal_vault) linked with text-embedding-3-small embeddings. If a user asks to recall custom data, the agent dynamically utilizes its tools to retrieve grounded information.

Localized Natural Language Reminder Engine:
When handling scheduling, a dedicated Reminder AI Agent extracts entities (task, when_text) into structured JSON. A robust JavaScript scheduling block parses time phrases like "tomorrow at 3pm" or "in 2 hours", actively normalizing relative timestamps explicitly to the Asia/Manila (PHT) timezone. Reminders are saved into workflow static data, and an independent cron-like trigger polls every 60 seconds to fire due events.

Inversion-Resistant HTML Processing & Error Handling:
Because Telegram relies strictly on safe HTML tags over standard Markdown, the workflow features automated string parsing to escape unauthorized characters dynamically. Additionally, a dedicated global Error Trigger branch acts as a circuit breaker, trapping script runtime failures and alerting the administrator via direct system logs.

The Technical Stack

Orchestration Engine: n8n (Advanced Workflow/Execution Model)

LLM & Embedding Layers: LangChain Integration, Azure OpenAI (gpt-oss-120b), text-embedding-3-small

Vector Database: Qdrant (Collection: personal_vault)

Interface Gateway: Telegram Bot API

Runtime Utilities: Node.js / JavaScript (Intl API, Timezone wall-clock transformations)

Key Engineering Takeaways

Reduced Token Overhead: By utilizing a code-based router ahead of the LangChain agents, trivial actions like saving text snippets completely bypass expensive LLM token usage.

Reliable Time Calculations: Solved the common serverless issue of native UTC system clocks by utilizing strict Intl.DateTimeFormat array reduction, maintaining clock accuracy across relative multi-day offsets.

Message Stream Chunking: Implemented a recursive script that splits LLM answers longer than 4,000 characters along natural sentence breaks (\n\n) to conform directly to strict chat platform maximum payload boundaries.

A robust, autonomous Telegram assistant built in n8n featuring dynamic intent routing, a localized scheduling engine for natural language reminders, and a Legal RAG (Retrieval-Augmented Generation) pipeline integrated with a Qdrant vector store.

Automated Personal Assistant & Study Companion

GOV.SYS (also called eGovLS) is a progressive web application that serves as the complete digital back-office for the San Andreas state government in a GTA roleplay server. It replaces manual paperwork and fragmented tools with a unified, browser-based portal where both citizens and government administrators can interact with the full lifecycle of government services, from submitting permit applications to tracking multi-stage budget approvals to generating official PDF documents.

The system is built as a pure frontend single-page application with no custom backend server. All business logic executes in the browser, communicating directly with Backend-as-a-Service platforms: Appwrite for authentication, database, and hosting; n8n for workflow automation; and Cloudinary for file storage.

Roleplay communities rely on manual, out-of-game tools (Google Forms, Discord bots, shared spreadsheets) to simulate government administration. This creates several problems:

Fragmented workflows: Citizens submit applications in one place, administrators review in another, documents are generated by hand, and notifications require manual Discord pings.
No audit trail: There is no reliable record of who approved what, when budgets were allocated, or why a document was issued.
Slow turnaround: Manual PDF creation, email delivery, and paper-based approval chains take hours or days, breaking immersion in a real-time roleplay environment.

No role-based access: Everyone sees everything, or nothing at all. There is no granular control over who can view, approve, or edit government records.
Zero transparency: Citizens have no visibility into how taxpayer money is spent or what documents are on file.

GOV.SYS solves these problems by providing a purpose-built, immersive government portal with:

End-to-end intake pipeline: Multi-step forms that persist drafts in sessionStorage, accept file uploads to Cloudinary, and trigger automated document generation via n8n upon approval.
Full financial lifecycle: OBR (Obligation Request) submissions with real-time MBO (Monthly Budget Obligation) cap validation, an 8-stage approval pipeline, disbursement voucher generation, and public budget transparency dashboards.

Document factory: Client-side PDF generation via jsPDF for official documents (OBRs, DVs, MBO reports, payroll ledgers, citizen-issued documents) with a consistent government aesthetic.
Role-based access control: 10 Appwrite teams mapped to every route, component, and admin feature, ensuring high-command users see exactly what they need.

Public transparency: Public finance dashboards with MBO summaries and funding source breakdowns, searchable employee rosters, and a gazette for publishing government news with threaded comments.

Key Features

Citizen-Facing
City Hall Dashboard: Roleplay-immersive landing page with faction cards, government statistics, gazette previews, and attendance quick-check.
Intake Forms: 8 application types (Faction Application, Business Permit, Citizen ID, City Clearance, Gun License, Police Clearance, Medical Clearance, NBI Clearance) with conditional fields, file uploads, and sessionStorage draft recovery.
My Forms Portal: Track submission status, view issued documents with expiry tracking, and renew expired documents.
Government Gazette: News articles with categories, tags, featured posts, content blocks, and Disqus-powered comments.
Legal Document Library: Browse and download official government documents.
Public Finance Transparency: Budget breakdowns with MBO summaries, funding source allocations, and interactive bar charts.
Obligation Requests: Submit OBR forms with real-time validation against remaining budget caps.
Attendance Portal: Duty check-in/check-out with photo proof, GPS location, and optional QR scan.
Faction Onboarding: Standalone recruitment application flow for prospective employees.
Public Rosters: Searchable directory of all government faction employees.

Admin (Role-Protected)
Admin Dashboard: 7-day trend graph, submission statistics, and quick-action toolbar.
Form Queue: Review, approve, or reject intake submissions; approval triggers n8n document generation workflow.
Settings Manager: Configure factions, ranks, business lines, and salary grades.
Gazette Post Editor: Full CRUD for publishing government news articles.
Legal Document Manager: Upload, organize, and publish downloadable government documents.
Document Factory: Generate, track, renew, and revoke citizen-issued documents as PDFs.
Payroll System: Salary grade management, employee profiles, duty roster views, pay period management, and payroll ledger generation.
Faction Roster: Add, remove, promote, or demote members with full audit trail.
Onboarding Queue: Approve or deny faction recruitment requests.
Audit Logs: Filterable, infinite-scroll system-wide activity log.
Finance Queue: 8-stage OBR approval pipeline (Pending, Approved, Accounting, Treasury, Disbursed, Reimbursed, plus Denied and Revision Required).
MBO Configuration: Monthly Budget Obligation setup with per-funding-source caps.
Allocation Ledger: Track budget utilization across all funding sources.
Disbursement Panel: Issue Disbursement Vouchers against approved OBRs.

Financial Pipeline
The system implements a complete 8-stage budget obligation and disbursement pipeline on par with real-world government financial systems:

Funding Sources: Personnel Services (PS), MOOE, Capital Outlay (CO), SPA, General Fund
OBR Statuses: PENDING_OBR, APPROVED, OBO_ACCOUNTING, ACCOUNTING_APPROVED, TREASURY_PENDING, DISBURSED, REIMBURSED
Generated Documents: OBR PDF, Disbursement Voucher PDF, MBO Report PDF, all rendered client-side via jsPDF with government-styled letterhead, double-border frames, signature blocks, and E-Commerce Act footer.

Technology Stack

Frontend Framework: React 19, Vite 8
Styling: TailwindCSS 4
Routing: react-router-dom 7
Backend: Appwrite (Auth, Database, Hosting)
Automation: n8n (PDF generation, Discord notifications, team management)
File Storage: Cloudinary (uploads and transformations)
PDF Generation: jsPDF 4
Comments: Disqus
Testing: Vitest and jsdom
PWA: Service worker, manifest, install prompt

Architecture

The system follows a serverless, client-heavy architecture:

Browser (React SPA)
  - Appwrite SDK -> Appwrite Cloud API (auth, database, teams)
  - Cloudinary SDK -> Cloudinary (file uploads and transformations)
  - n8n Webhooks -> n8n on Render (documents, notifications, teams)
  - Disqus SDK -> Disqus (gazette comments)

Demo Link: https://sanandreas.appwrite.network/

GOV.SYS (also called eGovLS) is a progressive web application that serves as the complete digital back-office for the San Andreas state government in a GTA roleplay server. It replaces manual paperwork and fragmented tools with a unified, browser-based portal where both citizens and government administrators can interact with the full lifecycle of government services, from submitting permit applications to tracking multi-stage budget approvals to generating official PDF documents.

The system is built as a pure frontend single-page application with no custom backend server. All business logic executes in the browser, communicating directly with Backend-as-a-Service platforms: Appwrite for authentication, database, and hosting; n8n for workflow automation; and Cloudinary for file storage.

Roleplay communities rely on manual, out-of-game tools (Google Forms, Discord bots, shared spreadsheets) to simulate government administration. This creates several problems:

Fragmented workflows: Citizens submit applications in one place, administrators review in another, documents are generated by hand, and notifications require manual Discord pings.
No audit trail: There is no reliable record of who approved what, when budgets were allocated, or why a document was issued.
Slow turnaround: Manual PDF creation, email delivery, and paper-based approval chains take hours or days, breaking immersion in a real-time roleplay environment.

No role-based access: Everyone sees everything, or nothing at all. There is no granular control over who can view, approve, or edit government records.
Zero transparency: Citizens have no visibility into how taxpayer money is spent or what documents are on file.

GOV.SYS solves these problems by providing a purpose-built, immersive government portal with:

End-to-end intake pipeline: Multi-step forms that persist drafts in sessionStorage, accept file uploads to Cloudinary, and trigger automated document generation via n8n upon approval.
Full financial lifecycle: OBR (Obligation Request) submissions with real-time MBO (Monthly Budget Obligation) cap validation, an 8-stage approval pipeline, disbursement voucher generation, and public budget transparency dashboards.

Document factory: Client-side PDF generation via jsPDF for official documents (OBRs, DVs, MBO reports, payroll ledgers, citizen-issued documents) with a consistent government aesthetic.
Role-based access control: 10 Appwrite teams mapped to every route, component, and admin feature, ensuring high-command users see exactly what they need.

Public transparency: Public finance dashboards with MBO summaries and funding source breakdowns, searchable employee rosters, and a gazette for publishing government news with threaded comments.

Key Features

Citizen-Facing
City Hall Dashboard: Roleplay-immersive landing page with faction cards, government statistics, gazette previews, and attendance quick-check.
Intake Forms: 8 application types (Faction Application, Business Permit, Citizen ID, City Clearance, Gun License, Police Clearance, Medical Clearance, NBI Clearance) with conditional fields, file uploads, and sessionStorage draft recovery.
My Forms Portal: Track submission status, view issued documents with expiry tracking, and renew expired documents.
Government Gazette: News articles with categories, tags, featured posts, content blocks, and Disqus-powered comments.
Legal Document Library: Browse and download official government documents.
Public Finance Transparency: Budget breakdowns with MBO summaries, funding source allocations, and interactive bar charts.
Obligation Requests: Submit OBR forms with real-time validation against remaining budget caps.
Attendance Portal: Duty check-in/check-out with photo proof, GPS location, and optional QR scan.
Faction Onboarding: Standalone recruitment application flow for prospective employees.
Public Rosters: Searchable directory of all government faction employees.

Admin (Role-Protected)
Admin Dashboard: 7-day trend graph, submission statistics, and quick-action toolbar.
Form Queue: Review, approve, or reject intake submissions; approval triggers n8n document generation workflow.
Settings Manager: Configure factions, ranks, business lines, and salary grades.
Gazette Post Editor: Full CRUD for publishing government news articles.
Legal Document Manager: Upload, organize, and publish downloadable government documents.
Document Factory: Generate, track, renew, and revoke citizen-issued documents as PDFs.
Payroll System: Salary grade management, employee profiles, duty roster views, pay period management, and payroll ledger generation.
Faction Roster: Add, remove, promote, or demote members with full audit trail.
Onboarding Queue: Approve or deny faction recruitment requests.
Audit Logs: Filterable, infinite-scroll system-wide activity log.
Finance Queue: 8-stage OBR approval pipeline (Pending, Approved, Accounting, Treasury, Disbursed, Reimbursed, plus Denied and Revision Required).
MBO Configuration: Monthly Budget Obligation setup with per-funding-source caps.
Allocation Ledger: Track budget utilization across all funding sources.
Disbursement Panel: Issue Disbursement Vouchers against approved OBRs.

Financial Pipeline
The system implements a complete 8-stage budget obligation and disbursement pipeline on par with real-world government financial systems:

Funding Sources: Personnel Services (PS), MOOE, Capital Outlay (CO), SPA, General Fund
OBR Statuses: PENDING_OBR, APPROVED, OBO_ACCOUNTING, ACCOUNTING_APPROVED, TREASURY_PENDING, DISBURSED, REIMBURSED
Generated Documents: OBR PDF, Disbursement Voucher PDF, MBO Report PDF, all rendered client-side via jsPDF with government-styled letterhead, double-border frames, signature blocks, and E-Commerce Act footer.

Technology Stack

Frontend Framework: React 19, Vite 8
Styling: TailwindCSS 4
Routing: react-router-dom 7
Backend: Appwrite (Auth, Database, Hosting)
Automation: n8n (PDF generation, Discord notifications, team management)
File Storage: Cloudinary (uploads and transformations)
PDF Generation: jsPDF 4
Comments: Disqus
Testing: Vitest and jsdom
PWA: Service worker, manifest, install prompt

Architecture

The system follows a serverless, client-heavy architecture:

Browser (React SPA)
  - Appwrite SDK -> Appwrite Cloud API (auth, database, teams)
  - Cloudinary SDK -> Cloudinary (file uploads and transformations)
  - n8n Webhooks -> n8n on Render (documents, notifications, teams)
  - Disqus SDK -> Disqus (gazette comments)

Demo Link: https://sanandreas.appwrite.network/

A comprehensive digital governance platform built for a GTA roleplay server community, handling citizen intake services, financial pipelines, personnel management, public transparency, and automated document generation through a serverless architecture powered by Appwrite, n8n, and Cloudinary.

San Andreas Government Management System (eGovLS | GOV.SYS))

Project Overview
FileSnaps was built to solve a common digital friction point: sharing sensitive files quickly without leaving a permanent digital footprint or forcing users to create an account. It provides a seamless "burn after reading" or time-restricted file-sharing experience, ensuring that temporary files remain truly temporary.

Key Features

Zero-Account Sharing: Users can drag, drop, and share instantly without onboarding friction.

Robust Security Architecture: Files are encrypted at rest. Passwords are never stored in plain text; instead, they are hashed using SHA-256 with a unique per-file salt.

Granular Expiration Controls: Support for flexible lifespans ranging from "1 download / Burn after reading" to 7-day long-term storage.

Automatic Lifespan Management: Expired files and their metadata are permanently deleted, ensuring zero-maintenance storage optimization.

The Technical Challenge & Solution
The core challenge of the project was balancing absolute user privacy with server-side efficiency. By implementing end-to-end encryption principles and automated data pruning, FileSnaps eliminates the data-hoarding tendencies of traditional cloud storage. The frontend leverages an intuitive, single-page interface with real-time state feedback, letting users manage uploads dynamically directly from their browser session history.

FileSnaps is a secure, ephemeral file-sharing platform designed to eliminate the friction of sending sensitive data. Built with an emphasis on privacy and speed, the application allows users to upload files up to 100 MB, apply custom expiration timers, and protect payloads with strong, hashed passwords—all without requiring an account or sign-up.

From a technical standpoint, security and automated maintenance were the top priorities. Files are encrypted at rest, and access passwords are securely processed using SHA-256 hashing alongside a per-file salt. To keep the background operations seamless and zero-maintenance, the system automatically purges expired files permanently based on user-selected schedules (ranging from a single download to a 7-day limit), ensuring optimal storage health without manual intervention.

DEMO LINK: filesnaps.rodneydelacruz.space

Project Overview
FileSnaps was built to solve a common digital friction point: sharing sensitive files quickly without leaving a permanent digital footprint or forcing users to create an account. It provides a seamless "burn after reading" or time-restricted file-sharing experience, ensuring that temporary files remain truly temporary.

Key Features

Zero-Account Sharing: Users can drag, drop, and share instantly without onboarding friction.

Robust Security Architecture: Files are encrypted at rest. Passwords are never stored in plain text; instead, they are hashed using SHA-256 with a unique per-file salt.

Granular Expiration Controls: Support for flexible lifespans ranging from "1 download / Burn after reading" to 7-day long-term storage.

Automatic Lifespan Management: Expired files and their metadata are permanently deleted, ensuring zero-maintenance storage optimization.

The Technical Challenge & Solution
The core challenge of the project was balancing absolute user privacy with server-side efficiency. By implementing end-to-end encryption principles and automated data pruning, FileSnaps eliminates the data-hoarding tendencies of traditional cloud storage. The frontend leverages an intuitive, single-page interface with real-time state feedback, letting users manage uploads dynamically directly from their browser session history.

FileSnaps is a secure, ephemeral file-sharing platform designed to eliminate the friction of sending sensitive data. Built with an emphasis on privacy and speed, the application allows users to upload files up to 100 MB, apply custom expiration timers, and protect payloads with strong, hashed passwords—all without requiring an account or sign-up.

From a technical standpoint, security and automated maintenance were the top priorities. Files are encrypted at rest, and access passwords are securely processed using SHA-256 hashing alongside a per-file salt. To keep the background operations seamless and zero-maintenance, the system automatically purges expired files permanently based on user-selected schedules (ranging from a single download to a 7-day limit), ensuring optimal storage health without manual intervention.

DEMO LINK: filesnaps.rodneydelacruz.space

An end-to-end encrypted, zero-maintenance file sharing platform featuring auto-deletion, custom expiration rules, and zero account requirements.

FileSnaps — Secure, Ephemeral File Sharing

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.

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 custom, self-hosted n8n automation infrastructure built to entirely digitize and streamline the issuance of police clearances.

Self-Hosted n8n Automation: Integrated Police Clearance Pipeline

Project Overview

Coming from a humanities background, I’ve always been fascinated by how local communities organize. I noticed the massive administrative friction barangays face handling paperwork, so I built CiviCore to digitize community governance. CiviCore serves as an Enterprise Resource Planning (ERP) solution scaled perfectly for community governance. Built to handle everything from granular resident registries to strict financial pipelines, the platform centralizes day-to-day operations into one secure, highly trackable digital workspace.

Executive Dashboard & Real-Time Analytics

The Dashboard acts as the central nervous system for community administrators. Offering real-time telemetry, it displays crucial top-line metrics such as total active residents, household counts, and monthly certificate issuance rates. The dynamic Activity Trend chart visualizes the ebb and flow of daily operations—tracking incidents, procurements, and appointments—giving local leaders an immediate, data-driven snapshot of community engagement and operational load.

Resident Registry & Demographics

At the heart of any community system is its populace. The Residents Registry provides a clean, easily searchable database of all community members. Administrators can track vital demographic data down to specific zones and block addresses. To maintain accurate census records, the system tracks the dynamic status of residents (e.g., Active, Moved, or Deceased), ensuring that resource allocation and community services are based on up-to-date population metrics.

Unified Finance Workflows

Handling public or association funds requires absolute precision and fail-safes. The Finance Operations module introduces a unified workflow that tracks the entire financial lifecycle: from Budgeting and Procurement to Obligations and Disbursements. The system includes built-in compliance alerts—for instance, automatically pausing financial workflows if a Monthly Budget Ordinance (MBO) is not approved—ensuring strict adherence to financial regulations and preventing unauthorized spending.

Resource & Inventory Management

For disaster preparedness and daily maintenance, the Resources module provides a highly visual inventory tracking system. Administrators can monitor essential physical assets—ranging from first aid supplies and disaster relief goods to office materials. Each item card displays current "On Hand" quantities against predefined "Reorder" thresholds, ensuring the community never runs out of critical supplies during emergencies.

Uncompromising Accountability: Audit Logs

In systems handling sensitive citizen data and community funds, accountability is paramount. The Audit Logs module provides an immutable, easily filterable history of every action taken within the platform. Whether an admin creates a new resident profile, an encoder updates an assistance ticket, or a treasurer archives a financial record, CiviCore logs the exact time, actor, and entity involved. This transparency deters misuse and provides a clear trail for operational audits.

DEMO LINK: https://civicore.appwrite.network/

Project Overview

Coming from a humanities background, I’ve always been fascinated by how local communities organize. I noticed the massive administrative friction barangays face handling paperwork, so I built CiviCore to digitize community governance. CiviCore serves as an Enterprise Resource Planning (ERP) solution scaled perfectly for community governance. Built to handle everything from granular resident registries to strict financial pipelines, the platform centralizes day-to-day operations into one secure, highly trackable digital workspace.

Executive Dashboard & Real-Time Analytics

The Dashboard acts as the central nervous system for community administrators. Offering real-time telemetry, it displays crucial top-line metrics such as total active residents, household counts, and monthly certificate issuance rates. The dynamic Activity Trend chart visualizes the ebb and flow of daily operations—tracking incidents, procurements, and appointments—giving local leaders an immediate, data-driven snapshot of community engagement and operational load.

Resident Registry & Demographics

At the heart of any community system is its populace. The Residents Registry provides a clean, easily searchable database of all community members. Administrators can track vital demographic data down to specific zones and block addresses. To maintain accurate census records, the system tracks the dynamic status of residents (e.g., Active, Moved, or Deceased), ensuring that resource allocation and community services are based on up-to-date population metrics.

Unified Finance Workflows

Handling public or association funds requires absolute precision and fail-safes. The Finance Operations module introduces a unified workflow that tracks the entire financial lifecycle: from Budgeting and Procurement to Obligations and Disbursements. The system includes built-in compliance alerts—for instance, automatically pausing financial workflows if a Monthly Budget Ordinance (MBO) is not approved—ensuring strict adherence to financial regulations and preventing unauthorized spending.

Resource & Inventory Management

For disaster preparedness and daily maintenance, the Resources module provides a highly visual inventory tracking system. Administrators can monitor essential physical assets—ranging from first aid supplies and disaster relief goods to office materials. Each item card displays current "On Hand" quantities against predefined "Reorder" thresholds, ensuring the community never runs out of critical supplies during emergencies.

Uncompromising Accountability: Audit Logs

In systems handling sensitive citizen data and community funds, accountability is paramount. The Audit Logs module provides an immutable, easily filterable history of every action taken within the platform. Whether an admin creates a new resident profile, an encoder updates an assistance ticket, or a treasurer archives a financial record, CiviCore logs the exact time, actor, and entity involved. This transparency deters misuse and provides a clear trail for operational audits.

DEMO LINK: https://civicore.appwrite.network/

An enterprise-grade community operations platform explicitly designed for the complexities of hyper-local governance.

CiviCore: Community Operations Platform

Project Overview

The City Hall PWA is a robust, full-stack government portal designed to handle the complex bureaucratic, financial, and organizational workflows of a digital municipality. Hosted as a Progressive Web App, it provides a seamless, app-like experience across devices. The platform bridges the gap between public-facing citizen services and secure, back-office administrative operations, perfectly tailored for sophisticated administrative ecosystems and high-stakes faction management.

Citizen Hub & Document Management

The Citizen Hub serves as the central self-service dashboard for residents. It provides a live, telemetry-style view of a citizen's interactions with the city, including application statuses and 7-day activity metrics. Through the My Docs interface, users can seamlessly track the validity of their Digital Citizen IDs, manage approved business permits, and monitor recurring business tax dues. The interface is clean, prioritizing quick actions so users can resolve pending requirements without friction.

The Government Gazette

Transparency and public communication are handled through the Government Gazette. This public-facing module acts as the official newsroom for the city, distributing executive orders, service announcements, and press releases. The UI allows citizens to easily search and filter through official publications, such as Department of Trade and Industry (DTI) business registration fee updates, ensuring the public remains informed on the latest municipal directives.

Application Processing & City Registry

Behind the scenes, the Admin Console equips city workers with powerful tools to process requests. The Applications module provides an organized queue for incoming Business Registrations, Citizen ID Requests, and Faction Applications, complete with quick-action approval and rejection workflows. Once approved, citizen data routes directly into the City Registry, a comprehensive, easily searchable database maintaining the active status and identification numbers of all registered individuals and entities within the ecosystem.

Finance & Payroll Operations

The platform boasts a highly sophisticated economic engine under the Finance Operations module. The overview dashboard provides real-time public finance snapshots, tracking metrics like Request Trends, Budget Source Mixes (ranging from Personnel Services to Capital Outlay), and overall economy health indexes. Furthermore, the Pay Period Dashboard automates faction payrolls, generating accurate pay stubs while calculating gross payrolls, tracking unpaid exposures, and managing tax withholdings for city employees.

Security, Role Scopes, & Route Locks

To maintain structural integrity across various government branches, the application utilizes strict access management. The Role Scopes Panel allows administrators to define dynamic permissions for different operational units (such as faction heads, LSPD, and secretaries), dictating their read/write access to specific modules like finance and applications. Additionally, the Route Locks system provides master client-side control over the platform, allowing admins to instantly toggle access to specific citizen services, applications (like Gun Licenses), and public pages, or enforce global theme overrides to ensure system-wide compliance.

DEMO LINK: https://lsgov-portal.appwrite.network/

Project Overview

The City Hall PWA is a robust, full-stack government portal designed to handle the complex bureaucratic, financial, and organizational workflows of a digital municipality. Hosted as a Progressive Web App, it provides a seamless, app-like experience across devices. The platform bridges the gap between public-facing citizen services and secure, back-office administrative operations, perfectly tailored for sophisticated administrative ecosystems and high-stakes faction management.

Citizen Hub & Document Management

The Citizen Hub serves as the central self-service dashboard for residents. It provides a live, telemetry-style view of a citizen's interactions with the city, including application statuses and 7-day activity metrics. Through the My Docs interface, users can seamlessly track the validity of their Digital Citizen IDs, manage approved business permits, and monitor recurring business tax dues. The interface is clean, prioritizing quick actions so users can resolve pending requirements without friction.

The Government Gazette

Transparency and public communication are handled through the Government Gazette. This public-facing module acts as the official newsroom for the city, distributing executive orders, service announcements, and press releases. The UI allows citizens to easily search and filter through official publications, such as Department of Trade and Industry (DTI) business registration fee updates, ensuring the public remains informed on the latest municipal directives.

Application Processing & City Registry

Behind the scenes, the Admin Console equips city workers with powerful tools to process requests. The Applications module provides an organized queue for incoming Business Registrations, Citizen ID Requests, and Faction Applications, complete with quick-action approval and rejection workflows. Once approved, citizen data routes directly into the City Registry, a comprehensive, easily searchable database maintaining the active status and identification numbers of all registered individuals and entities within the ecosystem.

Finance & Payroll Operations

The platform boasts a highly sophisticated economic engine under the Finance Operations module. The overview dashboard provides real-time public finance snapshots, tracking metrics like Request Trends, Budget Source Mixes (ranging from Personnel Services to Capital Outlay), and overall economy health indexes. Furthermore, the Pay Period Dashboard automates faction payrolls, generating accurate pay stubs while calculating gross payrolls, tracking unpaid exposures, and managing tax withholdings for city employees.

Security, Role Scopes, & Route Locks

To maintain structural integrity across various government branches, the application utilizes strict access management. The Role Scopes Panel allows administrators to define dynamic permissions for different operational units (such as faction heads, LSPD, and secretaries), dictating their read/write access to specific modules like finance and applications. Additionally, the Route Locks system provides master client-side control over the platform, allowing admins to instantly toggle access to specific citizen services, applications (like Gun Licenses), and public pages, or enforce global theme overrides to ensure system-wide compliance.

DEMO LINK: https://lsgov-portal.appwrite.network/

An end-to-end PWA designed to streamline municipal operations, featuring citizen self-service portals, advanced financial tracking, and granular role-based administrative controls.

Self-Hosted n8n Automation: Law Enforcement Operations Ecosystem

Related Posts

Automated Personal Assistant & Study Companion

Self-Hosted n8n Automation: Integrated Police Clearance Pipeline