Subscription Analytics Pipeline

Who is this for?

You handle billing ops sorting 3 Stripe webhook batches a day into Postgres, and this Postgres webhook workflow routes and records each event. Each batch needs payments, cancels and upgrades sorted, then database and weekly report updated.

What problem does this solve?

You sort payments, cancels and upgrades, then update the database and report. When the webhook arrives, the flow routes by event type, stores in Postgres, and compiles the weekly email. You just scan the report instead of entering each batch yourself.

What this workflow does

1. Store in Database (Postgres)
2. Weekly Report (Email)
3. Google Sheets - Audit Log (Google Sheets)
4. Slack - Error Alerts (Slack)
- Includes Daniel Grey pack: Slack - Error Alerts, Google Sheets - Audit Log, Wait - Rate Limit, Set - Audit Trail (all wired).

How it works

An incoming webhook kicks it off → Route by Event Type, Process Payment, Store in Database.

Setup

1. Open danielgrey.shop/app/templates/dg-1002 → Copy JSON → n8n → Import from Clipboard (or Push to n8n)
2. Connect credentials: Google Sheets, Slack, Postgres
3. Copy the production URL into your sending app, fire one test — it imports clean and goes green first try — then a 10-minute review and activate.

Requirements

- n8n 1.50.0 or later
- Credentials for Google Sheets, Slack, Postgres
- One-time $129 — yours forever, Pro unlocks it too.

Customising

- Tune the logic inside Process Payment — thresholds and weights are plain code with comments.
- Adjust routing in Route by Event Type for the Stripe events you track.