Webhook Risk Assessment with Claude + Google Sheets | n8n

Instant Webhook-Based Risk Assessments with Claude + Google Sheets (n8n)

Send a scenario to this n8n workflow via a POST webhook and get back a structured, five-part risk assessment generated by Anthropic Claude—then automatically log the results (including a Markdown report) to Google Sheets for audit-ready tracking.

What this workflow does

This workflow is designed to turn incoming information system descriptions into a consistent security and risk report:

• Receives a webhook request (POST) containing system_name, industry, and a scenario description.
• Validates access using an optional shared secret via the x-api-key header, and rejects scenarios that are shorter than a configured minimum length.
• Generates a five-part assessment with Anthropic Claude, producing risk ratings for confidentiality, integrity, availability, compliance, and operational risk, along with an overall rating, an executive summary, and assumptions.
• Enforces structured JSON output where each risk dimension is constrained to Critical / High / Medium / Low, including a description, mitigation, and a framework/regulation reference.
• Returns results to the caller as a combined JSON response and a formatted Markdown report.
• Logs to Google Sheets by appending assessment details to the Assessments tab.

Use cases

• Security teams running lightweight risk assessments from internal tools through a webhook.
• SaaS operators capturing scenario-based assessments for ongoing governance and review.
• Automation engineers standardizing risk reporting workflows with Claude and Google Sheets.

Technical details

• Webhook (POST endpoint receiving system_name, industry, scenario)
• Conditional logic (e.g., if), set and code steps for validation and JSON/Markdown assembly
• Anthropic Claude for risk assessment output
• Google Sheets node to append to an Assessments tab (fields include Timestamp, Overall Rating, dimension ratings, Executive Summary, Scenario, and Report)
• Includes a workflow sticky note for guidance

Optimize your n8n automation with this webhook-driven Webhooks Risk Assessment with Claude + Google Sheets solution—consistent outputs, structured JSON enforcement, and automated spreadsheet logging.