Reconcile recent Stripe charges with ClickHouse revenue
Get a focused list of charge totals and any discrepancies Notis can identify in the ClickHouse data you point it to.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
List Charges
Retrieves a list of stripe charges with filtering and pagination; use valid cursor ids from previous responses for pagination, and note that charges are typically returned in reverse chronological order.
Why this helps
Comparing payment activity to analytics records by hand makes reconciliation easy to postpone.
- Review recent charges and revenue records together.
- Focus attention on mismatches found in the available data.
- Reduce recurring manual comparison work.
Setup
Build it in a few focused steps.
- 1Connect ClickHouse and Stripe once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3In one instruction, ask Notis to list recent charges and compare them with the relevant ClickHouse revenue records.
- 4Pick a recurring schedule and choose where run reports go.
- 5Test with one real example and check how matches and differences are described.
Questions about this workflow
Will it know which ClickHouse records correspond to charges?
Only if the records expose useful shared identifiers or the instruction describes a reliable comparison. Notis cannot infer unavailable fields.
Does this update either system?
This workflow retrieves Stripe charges and analyzes ClickHouse data. It does not update either system.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link ClickHouse to Stripe. A trigger fires from one place; an action lands in another.
ClickHouse triggers
Stripe actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Cancel subscription
Cancels a customer's active stripe subscription at the end of the current billing period, with options to invoice immediately for metered usage and prorate charges for unused time.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Confirm payment intent
Confirms a stripe paymentintent to finalize a payment; a `return url` is necessary if the payment method requires customer redirection.
Create Customer
Creates a new customer in stripe, required for creating charges or subscriptions; an email is highly recommended for customer communications.
Create an invoice
Creates a new draft stripe invoice for a customer; use to revise an existing invoice, bill for a specific subscription (which must belong to the customer), or apply detailed customizations.
Create payment intent
Creates a stripe paymentintent to initiate and process a customer's payment; using `application fee amount` for a connected account requires the `stripe-account` header.
Create a price
Creates a new stripe price for a product, defining its charges (one-time or recurring) and billing scheme; requires either an existing `product` id or `product data`.
Create product
Creates a new product in stripe, encoding the request as `application/x-www-form-urlencoded` by flattening nested structures.
Create Refund
Creates a full or partial refund in stripe, targeting either a specific charge id or a payment intent id.
Connect any two apps with Notis in the middle.
ClickHouse and Stripe, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Stripe.