Daily

Get yesterday's Squarespace sales each morning

A short email gives yesterday's order count and revenue.

Runs: Daily
Apps: Squarespace
AI: Not needed
Access: Orders read

Send this to your assistant

Create a ClickRuntime automation: every morning at 7am, email me how many Squarespace orders I got yesterday and the total revenue.

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

A small shop owner on Squarespace builds the store, photographs the products and answers customers, and has little time to open the Orders panel just to see how yesterday went. Without a regular figure, a slow week goes unnoticed until the end of the month, and a good day is not connected to the post or the email that caused it. Decisions about advertising and stock rely on a feeling about how sales are going.

Each morning, ClickRuntime lists the orders placed the day before through the Squarespace Commerce API, adds up the grand totals and emails you the number of orders and the revenue. It takes a few seconds to read, and arrives at the same hour every day.

Solo founders, craft sellers and small agencies that run Squarespace stores use it as a daily pulse.

What you get out of it

You know how yesterday went
A single figure each morning replaces vague impressions. A quiet day or a big one is clear before the first coffee, and the team can respond to it promptly. That awareness helps small teams plan the day, from staffing to what to post online.
Marketing cause and effect is visible
When a newsletter or a post goes out, the next morning's figure shows how it did. Over weeks, you learn which actions bring orders and which do not. Knowing what works means you stop spending effort on what does not.
Slow spells are spotted early
A week of weak sales shows up as a trend in the emails, which prompts action such as a promotion, long before month-end accounts make it obvious. Acting within days rather than weeks makes a real difference to a small store's cash flow.
No dashboard login is needed
The figure arrives in your inbox, so you can check it from a phone without logging in to Squarespace, and forward it to a partner or accountant if they ask.
A daily record builds up
Each email is a dated entry, giving you a simple history of daily revenue for tax time, planning and comparing this season with the last one. It is also a useful backup if you ever need to reconstruct a period.

How it works

What happens, step by step

Every morning, ClickRuntime collects yesterday's orders from your Squarespace store.
It counts them and adds up the order totals.
You get a short email with yesterday's order count and revenue.

Before it runs live

Connect Squarespace

What you get

RunsDaily

Get yesterday's Squarespace sales each morningtoday, 9:00Succeeded

Email · Yesterday's salesSquarespace 2026-10-18: 14 orders, $1,286.50

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

daily_sales_digest_squarespace.pyexample

from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, notify

@on_trigger
def run(event):
    headers = {"Authorization": f"Bearer {credentials.secret('SQUARESPACE_API_KEY')}", "User-Agent": "ClickRuntime"}
    day = date.today() - timedelta(days=1)
    orders, cursor = [], None
    while True:
        params = {"cursor": cursor} if cursor else {"modifiedAfter": f"{day}T00:00:00Z",
                                                    "modifiedBefore": f"{date.today()}T00:00:00Z"}
        body = http.get("https://api.squarespace.com/1.0/commerce/orders", headers=headers, params=params).json()
        orders += [o for o in body["result"] if o["createdOn"].startswith(str(day))]
        if not body["pagination"]["hasNextPage"]:
            break
        cursor = body["pagination"]["nextPageCursor"]
    revenue = sum(float(o["grandTotal"]["value"]) for o in orders)
    notify.email_me(f"Squarespace {day}: {len(orders)} orders, ${revenue:,.2f}",
                    f"Orders: {len(orders)}\nRevenue: ${revenue:,.2f}")
    return {"orders": len(orders), "revenue": revenue}

FAQ

Common questions

Does the total include shipping and tax?

It sums each order's grand total as Squarespace reports it, which includes shipping, taxes and discounts. If you prefer a product-only figure, the subtotal can be used instead, and the email says which one it shows.

What time zone defines yesterday?

The run uses the time zone you specify, normally your store's own, so yesterday means your own midnight to midnight. Orders near midnight are therefore counted on the day your customers placed them. Set it once and forget it.

Are refunded or cancelled orders subtracted?

By default the email counts orders placed that day. Refunds can be listed separately or subtracted if you want net revenue, which you can say when setting it up, so the figure matches your bookkeeping.

What permissions does it need?

Orders read. 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 (daily). 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