Ecommerce Risk & Inventory Automation with Claude, Postgres & Slack

Automate e-commerce risk and inventory actions with Claude—plus full audit trails in Postgres and Slack updates

This n8n workflow automatically receives e-commerce order-risk and inventory/pricing events, gathers supporting evidence from your commerce APIs, asks Anthropic Claude to recommend an action with a confidence score, and then optionally auto-executes low-risk decisions—while logging every step to Postgres and notifying the right Slack channel.

What this workflow does

• Ingests events via webhook: accepts a POST webhook event (or a manual test event) and applies shared configuration such as API base URL, lookback window, thresholds, and Slack channel IDs.
• Normalizes and classifies the payload: determines whether the incoming data is an order-risk event or an inventory/pricing event, then routes to the appropriate evidence-gathering path.
• Fetches evidence from commerce APIs:
  • For order risk: retrieves relevant context such as orders and customer/fraud signals.
  • For inventory/pricing: retrieves inventory/pricing history and market data.
• Requests a decision from Claude: sends the event plus evidence to Anthropic Claude and parses the returned JSON decision (recommended action, confidence, risk level, reasoning, Slack message, and an execution payload).
• Auto-executes when safe: if confidence meets the threshold and risk is not high, the workflow calls your commerce API to execute; otherwise it skips execution.
• Audits and alerts: writes a full audit record (event, evidence snapshot, decision, execution status) to Postgres and posts to Slack using either an escalation or low-noise log channel.

Use cases

• Auto-handle suspicious orders: recommend cancellation/hold actions based on fraud signals and confidence.
• Prevent pricing mistakes: recommend inventory or pricing adjustments using inventory/pricing history and market data.
• Reduce operational overhead: route decisions to Slack and maintain a complete Postgres audit trail for compliance and review.

Technical details

• n8n workflow logic: uses nodes including if, set, code, merge, slack, and switch.
• Integrations: webhook ingestion, Anthropic Claude decisioning, commerce API evidence + optional execution, Postgres audit logging, and Slack notifications.