n8n Incident Postmortems: OpenAI Draft, Sheets Log & Discord Alerts

Turn incident reports into structured postmortems—log actions in Google Sheets and alert your team in real time

This n8n workflow collects incident submissions from an n8n form, generates an OpenAI (DeepSeek)–drafted postmortem in JSON, saves the results to Google Sheets, and notifies stakeholders via Gmail, Discord alerts, and Telegram monthly summaries.

What this workflow does

• Receives an incident report from an n8n hosted form.
• Normalizes and validates inputs (creates an incident ID and timestamp, and checks required fields like title, summary, and severity).
• Handles incomplete reports by posting a Discord alert and emailing the reporter to resubmit with missing details via Gmail.
• Generates a structured postmortem draft using OpenAI (DeepSeek), producing a JSON output with overview, timeline, root cause classification, impact, SLA hours, and action items.
• Logs postmortems and action items to Google Sheets: appends the draft to a “Postmortems” sheet and extracts action items into an “ActionItems” tracker.
• Notifies stakeholders by emailing the full draft to the reporter and posting a digest to Discord—escalating high/critical incidents with on-call alert messaging including SLA hours.
• Weekly run: tracks overdue work by reading open action items from Google Sheets and sending email + Discord overdue alerts (or an all-clear message if none are open).
• Monthly run: summarizes RCA trends by reading this month’s postmortems and sending a RCA trend summary via Telegram.

Use cases

• SaaS teams standardizing incident postmortems and action items across services.
• Automation engineers improving incident response workflows with SLA-aware alerts.
• Operational reporting: monthly RCA summaries for leadership visibility.

Technical details

• n8n nodes: if, set, code, gmail, discord, telegram.
• AI drafting: OpenAI (DeepSeek) generates the JSON postmortem structure.
• Persistence & tracking: Google Sheets (“Postmortems” and “ActionItems”).