Payment → risk check → ledger → receipt (Stripe → Postgres → Email)
快速摘要
触发器
Stripe - Payment Succeeded
步骤
8
流程
Stripe - Payment Succeeded → Code - Compute risk score + sanitize metadata → IF: Risk score < threshold? → Postgres - Insert Payment Record → Google Sheets - Append Row (Daily ledger)
泳道
4
集成
Email, Google Sheets, n8n, Postgres, Slack, Stripe
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"]
}