Shopify and Resend: Daily Order Digest Email Template
A scheduled Spojit workflow that pulls yesterday's Shopify orders, rolls them into a clean summary, and emails it from your own domain via Resend.
What It Builds
A Schedule trigger fires every morning and a Shopify Connector node fetches the prior day's orders. A Transform node rolls them into a totals-and-top-products summary, and a Resend Connector node sends the digest from your own verified domain. The result is a tidy daily recap in your inbox without anyone running an export by hand.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a workflow that runs every day at 7am, pulls all Shopify orders placed the previous day, summarizes them into total order count, total revenue, average order value, and the top 5 best-selling products, then emails that summary to ops@mycompany.com from our own domain using Resend with the subject "Daily Order Digest".
Connectors Used
- Schedule trigger - runs the workflow on a daily cron in your timezone.
- Shopify - reads the prior day's orders and line items.
- Resend - sends the digest from your verified sending domain.
Customize It
Change the run time, the recipient address, or the subject line directly in the prompt. You can also swap the metrics (add refunds, new vs returning customers, or a different number of top products) or point it at a different day range such as the last 7 days for a weekly recap.
Tips
- Verify your sending domain in Resend first, or the Resend node will reject the
fromaddress. - Your Shopify API key needs read access to orders and products.
- Keep the Shopify node in Direct mode for predictable, no-AI-cost fetches; use Agent mode only if you want Miraxa to decide which fields to pull.