An n8n workflow automation that processes Stripe payment events with a built-in risk scoring engine, routing high-risk transactions to a fraud review Slack channel. Approved payments are recorded in Postgres and mirrored to a Google Sheets daily ledger, while customers receive automated receipt emails and the finance team gets real-time Slack payment notifications.

完整 FlowZap 代码

billing { # Billing
n1: rectangle label:"Stripe - Payment Succeeded" system:"Stripe"
n2: rectangle label:"Code - Compute risk score + sanitize metadata" system:"n8n"
n3: diamond label:"IF: Risk score < threshold?" system:"n8n"
n1.handle(right) -> n2.handle(left) [label="Event data"]
n2.handle(right) -> n3.handle(left) [label="Risk evaluation"]
}

finance { # Finance
n4: rectangle label:"Postgres - Insert Payment Record" system:"Postgres"
n5: rectangle label:"Google Sheets - Append Row (Daily ledger)" system:"Google Sheets"
n3.handle(right) -> finance.n4.handle(left) [label="Yes"]
n4.handle(right) -> finance.n5.handle(left) [label="Mirror ledger"]
}

customer { # Customer
n6: rectangle label:"Email Send - Receipt Email" system:"Email"
n7: rectangle label:"Slack - Post Message (#payments)" system:"Slack"
n4.handle(bottom) -> customer.n6.handle(top) [label="Send receipt"]
n6.handle(right) -> customer.n7.handle(left) [label="Notify team"]
}

exceptions { # Exceptions
n8: rectangle label:"Slack - Post Message (#fraud-review)" system:"Slack"
n3.handle(bottom) -> exceptions.n8.handle(top) [label="No → Manual review"]
}

相关模板