Shopify and Resend: Weekly Top-Sellers Report Template
A weekly Spojit workflow that ranks your Shopify products by units sold and emails the top-sellers leaderboard to your merchandising team through Resend.
What It Builds
A Schedule trigger fires once a week and a Shopify Connector node pulls the past seven days of orders. A Transform node tallies units sold per product and ranks them, then a Resend Connector node emails the formatted leaderboard to merchandising. The result is a recurring report that lands in inboxes without anyone exporting a spreadsheet.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow that runs every Monday at 8am, pulls the last 7 days of Shopify orders, ranks the products by total units sold, and emails the top 10 sellers as a numbered leaderboard with units sold and revenue to merchandising@mycompany.com using Resend.Connectors Used
- Schedule trigger - runs the report on a weekly cron in your timezone.
- Shopify - reads orders and line items for the reporting window.
- Resend - sends the ranked report from your own verified domain.
Customize It
Change the cron time, the lookback window (7 days), the leaderboard length (top 10), the recipient address, or the metric you rank by (units sold versus revenue). You can also swap the ranking dimension to product type or vendor right in the prompt.
Tips
- Use a Resend connection on a verified sending domain so the report does not land in spam.
- Keep the Shopify node in Direct mode for the order read: it is exact, repeatable, and adds no AI cost.
- For very high order volumes, narrow the date range or paginate so the report stays fast.