Security Patrol Report Automation with GPT-6-Luna, Sheets & Gmail

Security Patrol Reports Automatically Graded, Logged & Escalated in Minutes

Turn patrol and incident submissions into supervisor-ready updates automatically. This n8n workflow collects security reports via an n8n Form, uses gpt-6-luna to classify severity and generate a ten-second summary, logs every report to Google Sheets, and instantly emails the ops supervisor (and the site client) when an incident is urgent—plus delivers a 06:00 daily digest and a monthly AI review.

What this workflow does

• Receives patrol logs/incidents from an n8n Form and normalizes key fields (officer, site, shift, report type, event time).
• Creates a unique report ID in the format SEC-yyyyMMdd-### and records a submission timestamp.
• Validates required inputs (officer name, officer email, site/client, and description). If anything is missing, the report is not saved and the officer receives an email listing what was missing and the values submitted.
• Grades severity with gpt-6-luna (classified as urgent, normal, or informational) and writes a clear summary a supervisor can read in about ten seconds.
• Logs every report to Google Sheets for complete records and traceability.
• Escalates urgent incidents by email to the ops supervisor and the site client the moment the report is marked urgent.
• Runs scheduled reporting: a daily 06:00 digest for the last 24 hours and a monthly AI review summarizing the last 30 days.

Use cases

• Ensure late-night incident reports reach the right people before the shift ends.
• Standardize patrol reporting by enforcing required fields and consistent severity grading.
• Give supervisors a fast, readable incident view without manual triage.

Technical details

• Workflow category: n8n automation workflow
• Nodes/stack mentioned: if, set, code, Gmail, sticky note, Form Trigger
• AI: gpt-6-luna for severity classification and supervisor summary
• Storage: Google Sheets logging of every report

Last updated: October 2026.