n8n Audit Risk Workflow: GPT-4o + Gmail Alerts + Google Sheets

Automatically audit workflow events, detect compliance risk with GPT-4o, and alert you via Gmail

This n8n Audit Risk Workflow receives workflow audit events through a webhook, uses OpenAI GPT-4o to assess compliance risk, logs every result to Google Sheets, and sends a detailed Gmail alert only when risk is classified as HIGH.

What this workflow does

• Receives audit events via an HTTP webhook (HTTP POST).
• Normalizes and enriches the payload by standardizing fields such as workflow name, action, user, status, and event metadata—then generates timestamps and an audit ID.
• Validates required fields; if an event is incomplete, it’s routed to a separate `invalid-audit` log in Google Sheets.
• Builds an audit summary plus a structured compliance prompt and submits it to OpenAI (GPT-4o) for risk analysis.
• Parses the model output to extract a Risk Level of LOW, MEDIUM, or HIGH.
• Sends Gmail alerts for HIGH risk with the full audit details and the AI analysis.
• Appends an audit trail record to Google Sheets, including the risk level and GPT response.

Use cases

• Monitor internal automation/workflow changes and flag potential compliance issues before they scale.
• Provide SaaS operators an at-a-glance audit log in Google Sheets with targeted Gmail notifications for urgent risk.
• Route malformed or incomplete audit events into a dedicated sheet for faster troubleshooting.

Technical details

• Webhook: Receives audit event payloads (HTTP POST).
• Nodes: if, set, webhook, gmail, google sheets, and a sticky note for workflow guidance.
• AI analysis: OpenAI GPT-4o to classify compliance risk.
• Google Sheets logging: Main audit trail + an invalid event log tab.

Optimized for n8n users, automation engineers, and SaaS operators who need automated audit risk detection, transparent record-keeping, and proactive alerting.