Order processing with Google Sheets and Slack: inventory checks and alerts
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Slack.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Check Order (Function): runs custom JavaScript (legacy Function node)
- Request Info (Function): runs custom JavaScript (legacy Function node)
- Item and quantity (Function): runs custom JavaScript (legacy Function node)
- Get Inventories (Google Sheets): lookup
- Mapping data (Merge): merges the data from its input branches
- enough stock? (If): checks a condition and branches into true / false
- Create Invoice (Function): runs custom JavaScript (legacy Function node)
- Slack: uses Slack
- Slack: uses Slack
- create data logs (Stock shortage) (Function): runs custom JavaScript (legacy Function node)
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Check Order, Request Info, Item and quantity…: replace with Code node, mode 'Run Once for All Items'.
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Check Order, Request Info, Item and quantity, Create Invoice, create data logs (success), create data logs (Stock shortage) | Code node, mode 'Run Once for All Items' |
Nodes used (6)
- Webhook
n8n-nodes-base.webhook - Function
n8n-nodes-base.function - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack
From the author
Overview A cornerstone of your Order Management System, this workflow ensures seamless inventory control through fully automated stock checks, leading to a direct reduction in operational costs. It provides real-time alerts to the responsible personnel,…