If your orders already land in a Google Sheet (see the Etsy and sale-alert guides), the report is the easy part. This scenario runs every Monday morning, sums last week's rows, finds the best-selling item and emails you five lines. No dashboard, no login, just the numbers.
What you need
A Google Sheet of orders with Date, Product and Total columns, an email account, and a free Make account.
The five steps
- In Make, create a scenario scheduled for Mondays at 08:00 in your time zone.
- Add Google Sheets Search Rows with a filter: Date between last Monday and last Sunday.
- Add an Array aggregator to collect the rows, then a Text aggregator or a few built-in functions to compute the count, the sum of Total and the most frequent Product.
- Add Email Send an Email with a plain-text body: orders, revenue, top product, best day, and a comparison to the week before if you keep a totals sheet.
- Run it once manually to check the numbers against the sheet, then leave it on.
Useful extras
Send the same report to a Telegram chat. Add a line for refunds. Once a month, add a second scenario that emails the monthly totals.
What this does not do
It reports what is in the sheet. If the sheet misses orders, the report misses them too, which is a good reason to automate the logging first.
Cost
A handful of operations per week. This is the cheapest scenario in the set.
Everything above runs on the free Make plan.
Build it tonight; the first run is the test.
Build the Monday report on the free Make plan
AFFILIATE LINK. THE PRICE IS THE SAME FOR YOU.