Detect dead Shopify inventory and send Gmail + Slack CSV alerts
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs on a schedule (every day at 07:00) (plus 1 other trigger). Along the way it connects Shopify, Gmail and Slack.
How it runs
Trigger: On a schedule (every day at 07:00) (plus 1 other trigger).
- Set Detector Configuration (Edit Fields (Set)): sets 4 fields: daysWithoutSales, orderFetchDays, recipientMail…
- Post Error to Slack (Slack): uses Slack
- Fetch Shopify Orders (Shopify): get many
- Fetch Shopify Products (Shopify): get many (product)
- Merge: merges the data from its input branches
- Identify Dead Inventory (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Prepare CSV Report Data (Code): runs custom JavaScript code
- Create Dead Inventory CSV (Convert to File): converts data to a file
- Email Dead Inventory Report (Gmail): uses Gmail
…plus 1 more step. 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)
- Edit Fields (Set)
n8n-nodes-base.set - Shopify
n8n-nodes-base.shopify - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Error Trigger
n8n-nodes-base.errorTrigger - Slack
n8n-nodes-base.slack - Convert to File
n8n-nodes-base.convertToFile - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge
From the author
Quick overview This workflow runs daily to detect dead Shopify inventory by comparing current product stock against recent paid order history, then generates a CSV report and sends it via Gmail and Slack, with global error notifications posted to Slack. How…