{"product_id":"security-patrol-report-automation-with-gpt-6-luna-sheets-gmail","title":"Security Patrol Report Automation with GPT-6-Luna, Sheets \u0026 Gmail","description":"\u003ch3\u003eSecurity Patrol Reports Automatically Graded, Logged \u0026amp; Escalated in Minutes\u003c\/h3\u003e\n\u003cp\u003eTurn patrol and incident submissions into supervisor-ready updates automatically. This n8n workflow collects security reports via an n8n Form, uses \u003cstrong\u003egpt-6-luna\u003c\/strong\u003e to classify severity and generate a ten-second summary, logs every report to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and instantly emails the \u003cstrong\u003eops supervisor\u003c\/strong\u003e (and the \u003cstrong\u003esite client\u003c\/strong\u003e) when an incident is urgent—plus delivers a 06:00 daily digest and a monthly AI review.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives patrol logs\/incidents\u003c\/strong\u003e from an \u003cstrong\u003en8n Form\u003c\/strong\u003e and normalizes key fields (officer, site, shift, report type, event time).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a unique report ID\u003c\/strong\u003e in the format \u003cem\u003eSEC-yyyyMMdd-###\u003c\/em\u003e and records a submission timestamp.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required inputs\u003c\/strong\u003e (officer name, officer email, site\/client, and description). If anything is missing, the report is \u003cem\u003enot saved\u003c\/em\u003e and the officer receives an email listing what was missing and the values submitted.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGrades severity with gpt-6-luna\u003c\/strong\u003e (classified as urgent, normal, or informational) and writes a clear summary a supervisor can read in about ten seconds.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs every report to Google Sheets\u003c\/strong\u003e for complete records and traceability.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates urgent incidents by email\u003c\/strong\u003e to the ops supervisor and the site client the moment the report is marked urgent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns scheduled reporting\u003c\/strong\u003e: a \u003cstrong\u003edaily 06:00\u003c\/strong\u003e digest for the last 24 hours and a \u003cstrong\u003emonthly AI review\u003c\/strong\u003e summarizing the last 30 days.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEnsure late-night incident reports reach the right people before the shift ends.\u003c\/li\u003e\n  \u003cli\u003eStandardize patrol reporting by enforcing required fields and consistent severity grading.\u003c\/li\u003e\n  \u003cli\u003eGive supervisors a fast, readable incident view without manual triage.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow category:\u003c\/strong\u003e n8n automation workflow\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/stack mentioned:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, \u003cstrong\u003eForm Trigger\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI:\u003c\/strong\u003e \u003cstrong\u003egpt-6-luna\u003c\/strong\u003e for severity classification and supervisor summary\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStorage:\u003c\/strong\u003e Google Sheets logging of every report\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eLast updated: October 2026.\u003c\/em\u003e\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192881631411,"sku":"N8N-20438","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/i_34JOxfxJFgYf2R0Uir5_GXVE07Xu.png?v=1791538363","url":"https:\/\/buyflowscripts.com\/products\/security-patrol-report-automation-with-gpt-6-luna-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}