Collect and escalate security patrol reports with gpt-6-luna, Google Sheets, and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 22 nodes and runs when someone submits an n8n form (“Security patrol report”) (plus 2 other triggers). Along the way it connects Gmail, OpenAI Chat Model and Google Sheets.
How it runs
Trigger: When someone submits an n8n form (“Security patrol report”) (plus 2 other triggers).
- Normalize Report (Edit Fields (Set)): sets 11 fields: officer_name, officer_email, site…
- Read Yesterday Logs (Google Sheets): uses Google Sheets
- Read Month Logs (Google Sheets): uses Google Sheets
- Validate Report (If): checks a condition and branches into true / false
- Build DAR Digest (Code): runs custom JavaScript code
- Collate Month Stats (Code): runs custom JavaScript code
- Classify Report (AI Agent): runs an AI agent, with model: Classify Model
- Email Officer Rejection (Gmail): uses Gmail
- Email Daily DAR (Gmail): uses Gmail
- Draft Monthly Review (AI Agent): runs an AI agent, with model: Monthly Review Model
…plus 7 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Patrol reports that reach the right person before the shift ends. This workflow takes guard reports from an n8n Form, has gpt-6-luna grade the severity and write a summary a supervisor can read in ten seconds, logs every report to Google Sheets, and emails…