Detect and score refund risk with Webhook, OpenAI and Google Sheets

About

How it works This workflow automatically evaluates refund and chargeback risk for incoming e-commerce orders. Orders are received via a webhook, processed individually, and checked to avoid duplicate analysis. Each transaction is normalized and sent to OpenAI for structured risk scoring and classification. Results are logged for auditing, alerts are triggered for high-risk cases, and processed orders are marked to prevent reprocessing. Step-by-step Step 1 – Ingest incoming orders** Webh