Shopify and Resend: Monthly Refund Summary Email Template

A scheduled workflow that tallies your Shopify refunds and cancellations for the month and emails the figures to finance through Resend.

What It Builds

A Schedule trigger fires on the first of each month. A Shopify Connector node pulls the prior month's refunds and cancelled orders, a Transform node sums the totals and counts, and a Resend Connector node sends a clean summary email to your finance inbox. No spreadsheets, no manual pulls.

The Prompt

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

Build a workflow that runs on the first day of every month, pulls all Shopify refunds and cancelled orders from the previous calendar month, totals the refunded amount and the count of refunds and cancellations, and emails that summary to finance@mycompany.com through Resend with the month name in the subject line.

Connectors Used

Schedule trigger - runs the summary once a month on a cron schedule with your timezone.
Shopify - reads refunds and cancelled orders for the reporting period.
Resend - sends the formatted summary from your own verified domain.

Customize It

Change the cron timing in the prompt to run weekly or quarterly, swap finance@mycompany.com for a distribution list, or add a breakdown by reason code or product. You can also ask for the figures grouped by store location if you sell across multiple Shopify markets.

Tips

Give the Shopify connection read scope for orders and refunds so the pull returns complete data.
Verify your sending domain in Resend first, otherwise the email will not deliver.
Use the Shopify node in Direct mode for a predictable, AI-free data pull, then add an Agent-mode node only if you want a written commentary on the trend.