An n8n scheduled workflow that checks Shopify inventory levels every morning, builds a low-stock item list, and evaluates each product against configurable reorder thresholds. Items below threshold trigger a Slack #ops alert and an escalation email to the supply chain team. All stock check results — both alerts and all-clear statuses — are logged to Google Sheets.

Full FlowZap Code

schedule { # Schedule
n1: rectangle label:"Schedule Trigger - Every morning" system:"n8n"
n2: rectangle label:"Shopify - Check Inventory Levels" system:"Shopify"
n1.handle(right) -> n2.handle(left) [label="Run check"]
}

decision { # Decision
n3: rectangle label:"Code - Build low-stock list" system:"n8n"
n4: diamond label:"IF: Any item below threshold?" system:"n8n"
schedule.n2.handle(right) -> decision.n3.handle(left) [label="Inventory"]
decision.n3.handle(right) -> decision.n4.handle(left) [label="Low stock list"]
}

notify { # Notify
n5: rectangle label:"Slack - Alert #ops (low stock)" system:"Slack"
n6: rectangle label:"Email Send - Low Stock Email" system:"Email"
decision.n4.handle(right) -> notify.n5.handle(left) [label="Yes"]
notify.n5.handle(right) -> notify.n6.handle(left) [label="Escalate"]
}

audit { # Audit
n7: rectangle label:"Google Sheets - Append Row (Stock alert log)" system:"Google Sheets"
notify.n6.handle(bottom) -> audit.n7.handle(top) [label="Log"]
decision.n4.handle(bottom) -> audit.n7.handle(top) [label="No → Log OK"]
}

Related templates