Stripe and MySQL: Invoice Ledger Sync Template

A scheduled workflow that pulls recent Stripe invoices and upserts each one into a MySQL ledger table, giving you a queryable local record of billing for reporting and audits.

What It Builds

A Schedule trigger fires on a cron you set, then a Stripe Connector node lists invoices created since the last run. A Loop walks each invoice and a MySQL Connector node upserts it into your ledger table, keyed on the Stripe invoice ID so re-runs update rather than duplicate. The result is an always-current local copy of your billing data you can query with plain SQL.

The Prompt

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

Build a workflow that runs every morning, lists Stripe invoices created in the last 24 hours, and for each invoice upserts a row into my MySQL "invoice_ledger" table with the invoice ID, customer email, amount due, amount paid, currency, status, and created date, matching on invoice ID so existing rows are updated instead of duplicated.

Connectors Used

Schedule trigger - runs the sync on the cron and timezone you choose.
Stripe - lists recent invoices and their amounts, status, and customer.
MySQL - upserts each invoice into your ledger table.

Customize It

Tweak the prompt to change the cadence (hourly, weekly), the lookback window, the target table name, or which invoice fields land in each column. You can also narrow to a single status such as paid, or add line-item detail to a second table.

Tips

Use a unique key or index on the Stripe invoice ID column so the upsert reliably matches existing rows.
Keep the lookback window slightly wider than the schedule interval so a missed run still backfills.
Direct mode on each Connector node keeps this deterministic and avoids AI cost; reserve Agent mode for steps that need judgment.