Flag delayed Shopify orders with Slack, Google Sheets and Gmail
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 13 nodes and runs on a schedule (cron 0 8 * * *). Along the way it connects Slack, Google Sheets and Gmail.
How it runs
Trigger: On a schedule (cron 0 8 * * *).
- Fetch Unfulfilled Shopify Orders (HTTP Request): calls an HTTP API
- Parse Orders & Calculate Age (Code): runs custom JavaScript code
- Filter: keeps only the items that match a condition
- Classify Delay Severity (Edit Fields (Set)): sets 3 fields: severity, severityEmoji, severityLabel
- Aggregate: combines items into one
- Any Delayed Orders Found (If): checks a condition and branches into true / false
- Build Slack Digest Message (Code): runs custom JavaScript code
- Post Delay Digest to Slack (Slack): uses Slack
- Split Orders for Logging (Split Out): splits a list into separate items
- Log Each Order to Sheet (Google Sheets): append
…plus 2 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 (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Edit Fields (Set)
n8n-nodes-base.set - Aggregate
n8n-nodes-base.aggregate - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow runs daily to check Shopify for open, unfulfilled orders older than two days, classifies them by delay severity, posts a digest to Slack, logs each delayed order to Google Sheets, and emails an HTML summary report via Gmail. How…