Weekly

Get last week's Etsy orders and revenue every Monday

A Monday email gives the order count and total for the past week next to the week before.

Runs: Weekly
Apps: Etsy
AI: Not needed
Access: transactions_r

Send this to your assistant

Create a ClickRuntime automation: every Monday at 9am, email me how many Etsy orders I had last week and the total revenue, compared with the previous week.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

Etsy's stats pages show visits and orders, but putting last week next to the week before takes several clicks and a calculator. Sellers with a home studio or a side business tend to look only after a slow stretch, so a falling trend gets noticed a month late. A seasonal dip, a broken listing or a promotion that worked all stay invisible.

On Monday, ClickRuntime reads your Etsy receipts for the past seven days, counts the orders, adds up the grand totals, compares them with the figures it stored the previous week, and emails you a short summary with the change in orders and revenue.

If you sell in more than one currency or run several shops, you can ask for the totals to be split so each is reported on its own.

What you get out of it

Notice slowdowns within seven days
A weekly comparison makes a drop obvious while it is still small. If revenue falls by a fifth, you check listings, renewals and ad spend that week instead of at month end. Small problems are cheaper to fix than big ones.
Judge promotions with real numbers
After a sale or a social post, you can see whether orders rose against the prior week. That tells you whether the discount paid for itself, rather than leaving you to guess from a feeling.
Plan stock and supplies sooner
Order counts that trend up for three weeks signal that you will run short of materials. Seeing it Monday gives time to reorder paper, fabric or blanks before a backlog.
Replace manual spreadsheets
The summary arrives without exporting a CSV or copying totals. The saved previous-week figure means the comparison is already worked out, saving the Sunday-night bookkeeping many sellers dread. Nothing needs to be exported or pasted.
Keep a simple history for taxes
Each Monday email forms a dated record of weekly revenue. When you prepare quarterly estimates or talk to an accountant, you can add the figures up instead of rebuilding them from the shop manager.

How it works

What happens, step by step

Every Monday, ClickRuntime collects your Etsy orders from the last 7 days.
It counts them and adds up the revenue.
It compares the result with the week before, which it saved last time.
You get an email with this week's orders and revenue next to the previous week's.

Before it runs live

Connect Etsy

What you get

RunsWeekly

Get last week's Etsy orders and revenue every Mondaytoday, 9:00Succeeded

Email · Etsy last weekOrders: 63 Revenue: $2,140.75 (previous week: 51 orders, $1,802.10)

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.

Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

Run it at a different time, more or less often, or only on weekdays
Add an AI step, for example to summarize, sort or draft a reply
Add another app, for example also send it to Slack
Combine it with other Etsy steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

weekly_sales_digest.pyexample

import time
from clickruntime import on_trigger, credentials, http, state, notify

SHOP_ID = "12345678"

@on_trigger
def run(event):
    headers = {"x-api-key": credentials.secret("ETSY_API_KEY"),
               "Authorization": f"Bearer {credentials.connection('etsy', 'shop')}"}
    end = int(time.time()) // 86400 * 86400
    receipts, offset = [], 0
    while True:
        body = http.get(f"https://openapi.etsy.com/v3/application/shops/{SHOP_ID}/receipts", headers=headers,
                        params={"min_created": end - 7 * 86400, "max_created": end, "limit": 100,
                                "offset": offset}).json()
        receipts += body["results"]
        offset += 100
        if offset >= body["count"]:
            break
    revenue = sum(r["grandtotal"]["amount"] / r["grandtotal"]["divisor"] for r in receipts)
    prev = state.get("last_week")
    vs = f" (previous week: {prev['orders']} orders, ${prev['revenue']:,.2f})" if prev else ""
    notify.email_me(f"Etsy last week: {len(receipts)} orders, ${revenue:,.2f}",
                    f"Orders: {len(receipts)}\nRevenue: ${revenue:,.2f}{vs}")
    state.set("last_week", {"orders": len(receipts), "revenue": revenue})
    return {"orders": len(receipts), "revenue": revenue}

FAQ

Common questions

Does the revenue figure include shipping and tax?

The total uses the grand total on each Etsy receipt, which includes shipping and collected tax. If you prefer item revenue only, the calculation can use the subtotal field instead, so it matches the figure you report. Refunded receipts can be excluded too.

What happens in the first week with no previous number?

The first email reports the current week and notes that there is nothing to compare against. From the second Monday on, the stored figure from the prior run is used to calculate the change. It keeps the new figure for next time.

Can the digest include my best-selling listing?

Yes. Receipts contain the line items, so the email can also name the listing that sold the most units that week. Ask for it, and the summary adds one line with the listing title and count.

What permissions does it need?

transactions_r. Nothing else in your accounts is used.

Does it need AI?

No. It runs without AI, so it doesn't use your plan's AI allowance.

How many runs does it use?

One run each time it runs (weekly). Checks that find nothing to do and stop right away aren't counted.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Daily