An n8n workflow automation that processes new Shopify paid orders by computing profit margins and tagging VIP customers. High-risk or high-value orders are routed to a dedicated Slack fraud-review channel via IF branching, while normal orders trigger ops alerts. Every transaction is appended to a Google Sheets order ledger for accounting and reporting.

Full FlowZap Code

commerce { # Commerce
n1: rectangle label:"Shopify - New Paid Order" system:"Shopify"
n2: rectangle label:"Code - Compute margin + tag VIP customers" system:"n8n"
n3: diamond label:"IF: High-risk / high-value?" system:"n8n"
n1.handle(right) -> n2.handle(left) [label="Order payload"]
n2.handle(right) -> n3.handle(left) [label="Scoring"]
}

ops { # Ops
n4: rectangle label:"Slack - Post Order Alert (#ops)" system:"Slack"
n5: rectangle label:"Slack - Post Message (#fraud-review)" system:"Slack"
n3.handle(bottom) -> ops.n4.handle(top) [label="No → Normal"]
n3.handle(right) -> ops.n5.handle(left) [label="Yes → Review"]
}

accounting { # Accounting
n6: rectangle label:"Google Sheets - Append Order Row" system:"Google Sheets"
ops.n4.handle(right) -> accounting.n6.handle(left) [label="Log order"]
ops.n5.handle(bottom) -> accounting.n6.handle(top) [label="Log flagged"]
}

Related templates