n8n Workflow: Process Stripe Orders with Gmail & Slack Alerts

Automatically process incoming Stripe-like orders and notify customers and teams via Gmail + Slack

This n8n workflow receives order requests from a Lovable app webhook, validates and deduplicates them in Google Sheets, simulates a Stripe payment intent, then either sends a Gmail receipt on success or posts a Slack alert on failure—while logging every event and error back to Sheets.

What this workflow does

• Receives webhook order data: Accepts a POST request containing email, amount, currency, and order ID.
• Validates and deduplicates: Checks required fields and formats, creates an idempotency key, then searches Google Sheets to avoid duplicate processing. Writes an initial “processing” record plus an audit log entry.
• Simulates payment processing: Uses an HTTP request (via httpbin) to represent a demo Stripe payment-intent call, then decides success vs failure based on the HTTP response and a failure-simulation flag.
• Retries on failure: If payment fails, it retries up to three times with a 10-second wait, logging each retry to Google Sheets.
• Success path: Updates status to completed, logs success, sends a Gmail receipt to the customer, and returns a 200 JSON response.
• Failure path: Updates status to failed, logs the failure, posts a Slack alert, and returns a 502 JSON response.

Use cases

• SaaS operators validating an order pipeline before wiring real Stripe payment logic.
• Automation engineers needing webhook-to-ops visibility: receipts for customers and immediate Slack notifications for failures.
• Teams that want durable state tracking (orders, logs, errors) directly in Google Sheets for troubleshooting and auditing.

Technical details

• n8n nodes: Webhook, if, set, code, Gmail, Slack.
• Data storage: Google Sheets (orders, logs, and errors tabs with columns matching the workflow mappings).
• Payment simulation: HTTP call to httpbin to mimic a Stripe payment-intent step.
• Reliability: Idempotency key + duplicate check + retry counter with timed waits.