Log ecommerce orders, send Slack alerts, and store data in Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 15 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets, Slack and Gmail.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Format Order Data (Edit Fields (Set)): sets 6 fields: order_id, customer, email…
- Alert Ops on Workflow Failure (Slack): uses Slack
- Validate Order Data (If): checks a condition and branches into true / false
- Upsert Order to Sheet (Google Sheets): append or update
- Log Invalid Order (Edit Fields (Set)): sets 2 fields: status, reason
- Classify Order Tier (Switch): routes items into 3 branches
- Respond Invalid Order (Respond to Webhook): sends the response back to the webhook caller
- Notify Risk Review Channel (Slack): uses Slack
- Notify VIP Channel (Slack): uses Slack
- Notify Orders Channel (Slack): uses Slack
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch - Slack
n8n-nodes-base.slack - Merge
n8n-nodes-base.merge - Gmail
n8n-nodes-base.gmail - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick Overview This workflow receives ecommerce orders via a webhook, formats key order fields, appends each order to Google Sheets, and posts a Slack notification to different channels based on whether the order total exceeds 200. How it works 1. Receives a…