Automate Incident Reports with Supabase & Gemini Workflow

Automate Incident Reports with Supabase & Gemini Workflow

The future of incident response is here with the seamless integration of Supabase, GitHub, and Google Gemini in our innovative n8n workflow. Empower your incident management process with this sophisticated solution that gathers, analyzes, and reports incidents with unprecedented precision.

What this workflow does

• Effortlessly ingests incident and playbook content from GitHub into Supabase, complete with pgvector embeddings via Google Gemini.
• Upon receiving a webhook-triggered incident payload, it decrypts the provided OpenRouter API key for further LLM (Language Model) processes.
• Establishes a unique tracking row in Supabase and configures necessary values for effective incident retrieval and report generation.
• Extracts historical incident data from Supabase utilizing Google Gemini embeddings to identify helpful patterns.
• Selects and retrieves the most pertinent playbook from Supabase, with a built-in backup when no precise match is identified.
• Leverages Tavily Search alongside OpenRouter-powered intelligence agents for rigorous external threat intelligence and phased mitigation advice.
• Compiles data from these information channels to produce a comprehensive JSON output and an extensive 11-section Markdown incident report.
• Ensures all report fields are validated and, if satisfactory, updates the Supabase test incident record with the structured output and Markdown document.

Use cases

• For security teams in SaaS companies streamlining incident response procedures with accurate and swift incident reporting.
• Automation engineers looking to integrate playbook data and threat intelligence into existing workflows without manual oversight.
• n8n users managing incident response across platforms, benefiting from enriched data retrieval and seamless report synthesis.

Technical details

• Integrations: GitHub, Supabase, Google Gemini, Tavily Search, OpenRouter.
• Nodes used: if, set, code, no op, wait, merge.