Stripe and MySQL: Daily Payouts Roll-Up Snapshot Template

A scheduled Spojit workflow that pulls the day's Stripe charges and writes a per-day revenue roll-up row into a MySQL reporting table.

What It Builds

A Schedule trigger fires once a day after midnight. A Stripe Connector node lists the previous day's successful charges, a Transform node totals gross revenue, fee, net, and charge count, and a MySQL Connector node in Direct mode inserts a single roll-up row into your reporting table. The result is one clean snapshot row per day, ready for dashboards and finance review.

The Prompt

Paste this into Miraxa and it builds the workflow, connecting the tools for you:

Build a workflow that runs every day at 1am and pulls yesterday's successful Stripe charges. Sum the gross amount, total fees, and net amount, count the charges, then insert one row into the MySQL table daily_revenue with columns report_date, gross, fees, net, and charge_count.

Connectors Used

Schedule trigger - runs the snapshot once a day on a cron schedule in your timezone.
Stripe - lists the prior day's successful charges with amounts and fees.
MySQL - inserts the rolled-up totals as one row in your reporting table.

Customize It

Change the run time in the prompt, point at a different table name or columns, or add a currency filter so each currency gets its own row. You can also widen the window to a weekly roll-up by asking for the last seven days instead of yesterday.

Tips

Use a Stripe key with read access to charges; the MySQL connection only needs insert rights on the reporting table.
Keep the MySQL node in Direct mode for a deterministic, no-AI-cost insert.
Make report_date a unique column so re-runs do not create duplicate rows.