Weekly BigCommerce sales report emailed to your team
Every Monday morning, get a plain-English summary of your BigCommerce store's week: revenue, top sellers, and what needs attention.
BigCommerce
GmailSalesFinanceAI ReportsDaily DigestsEmail AutomationEvery Monday at 9am, run an agent that emails our team a plain-English weekly sales performance report for our BigCommerce store.
Pull the last seven days of orders from BigCommerce using Get All Orders, filtered by min_date_created to seven days ago. For each order, fetch the line items with List Order Products so you know what actually sold and in what quantity.
Then pull the prior seven days for the comparison window. Use Get a Count of Orders to size the comparison window, and Get All Orders again for the fourteen-to-seven-days-ago range so you have order-level detail on both sides.
Compute total revenue, order count, average order value, and top selling products (by revenue and by units) for the current week, plus week-over-week deltas against the prior week.
Then write a short narrative that highlights what actually moved: which SKUs jumped, which fell off, and any unusual refund or status patterns you spot by checking Get All Order Statuses against the counts in each state. This is not a fixed template. The callouts should reflect what the data actually shows this week, and it needs an agent because the ''what actually matters'' judgement is not something you can hardcode.
Send the finished report to the configured recipient list via Gmail Send a Message. Use a clear subject line like ''Weekly BigCommerce sales report for [week of]'' so it is easy to find later.
What does this prompt do?
- Pulls the last seven days of orders and line items from your BigCommerce store, plus the previous seven days for comparison.
- Calculates total revenue, order count, average order value, top selling products, and week-over-week changes.
- Writes a short narrative that highlights which products jumped, which fell off, and any unusual refund or status patterns.
- Emails the finished report to the recipient list you choose, every Monday at 9am.
What do I need to use this?
- A BigCommerce store you can connect to
- A Gmail account to send the report from
- The email addresses of the people who should receive the weekly report
How can I customize it?
- Change the schedule to a different day, time, or cadence (bi-weekly, monthly, etc.)
- Update the list of recipients on the email or change the subject line format
- Adjust what the narrative focuses on, like top movers, refund spikes, or specific product categories
FAQs
How far back does the report look?
Can I send it to my whole team?
Will this work for any BigCommerce store?
Does the email come from my Gmail account?
What kind of insights does it actually write?
Related templates
Every couple of hours we find the chats your team never answered, email those visitors a real reply, and hand the sensitive ones to a support lead.
One board showing every party you are onboarding, which documents are still missing or expiring, and a one click chase email for exactly what is outstanding.
Every hour, new email attachments get sorted by document type and vendor, saved under clear names, and logged in a spreadsheet index.
Pick an open role and see which past applicants deserve a second look, with an assistant that ranks the best fits and drafts personal outreach.
See every voyage on your books ranked by money at risk, open the full statement of facts, and let an agent draft the demurrage claim for review.
Look up any Kajabi member by email or name and see every offer, purchase, and payment in one profile, then grant, revoke, or swap access from the same row.
Stop stitching together your weekly sales numbers by hand.
Have a plain-English BigCommerce recap in your team's inbox every Monday morning, with the "what actually matters" already called out.