Weekly BigCommerce sales report emailed to your team

Every 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.