MySQL and Resend: Weekly KPI Scorecard Email Template

A Spojit template that runs your key MySQL metrics every week, rolls them into one digest, and emails the scorecard to leadership through Resend.

What It Builds

A Schedule trigger fires once a week and kicks off several MySQL Connector nodes in Direct mode, one per KPI query. A Transform node formats the returned numbers into a clean digest, and a Resend Connector node sends the finished scorecard to your leadership distribution list.

The Prompt

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

Build a workflow that runs every Monday at 7am. Query my MySQL database for last week's total revenue, new signups, active users, and churned accounts, then combine the results into a single formatted KPI scorecard and email it to leadership@acme.com through Resend with the subject "Weekly KPI Scorecard".

Connectors Used

Schedule trigger - runs the workflow on a weekly cron.
MySQL - runs each KPI query against your reporting database.
Resend - delivers the digest email from your own verified domain.

Customize It

Change the day and time in the prompt to shift when the report runs, swap in your own KPI queries and metric names, point the email at a different recipient or subject, and adjust the date range (for example, last 30 days instead of last week) so the scorecard matches how your team reviews performance.

Tips

Keep each metric in its own MySQL node in Direct mode so a single slow query never blocks the rest.
Use a read-only database user for the connection: this workflow only needs SELECT access.
Verify your sending domain in Resend before the first run so the digest lands in inboxes, not spam.