Weekly
Get a Friday summary of invoices you sent
At the end of each week you have a record of every invoice created in Wave and the total billed.
- Runs
- Weekly
- Apps
- Wave
- AI
- Not needed
- Access
- full access token
Send this to your assistant
Create a ClickRuntime automation: every Friday at 5pm, email me all invoices I created in Wave since Monday, with customer, amount and status, and the week's total.
First time? Adding ClickRuntime to your assistant takes about two minutes.
Why use it
Why teams use this automation
Month after month, a bookkeeper or owner is asked a simple question: how many invoices did we send last week, and for how much? In Wave the answer means opening the Invoices page, filtering by date, and adding up the totals. When that is not done on a regular rhythm, billing gaps hide. A recurring client simply never got an invoice for the month, and it surfaces only when cash runs short.
Every week the automation queries Wave for invoices created in the past seven days and emails you the list: number, customer, date and amount, with a total at the bottom. It reads the createdAt value on each invoice, so the window is exact and nothing is counted twice across weeks.
It is useful for owners who want a Monday check that billing is keeping pace with the work that was actually done.
What you get out of it
Spot customers who were never billed
If a retainer client is missing from the weekly list, you notice within days. A forgotten invoice found in week one costs nothing; the same one found in month three becomes an awkward back-bill and a delayed payment.
Weekly billing total at a glance
The email adds up what you invoiced, so you see whether revenue billed this week is on track against the month's target without opening a report, exporting a file or asking the bookkeeper for a quick number.
Easy hand-off to an accountant
Forwarding the weekly emails gives your accountant a running log of what was issued and when, which shortens the questions at quarter end and reduces the time they bill you for reconstructing invoice dates.
Catches duplicate invoices
Two invoices for the same customer and amount in one list stand out. You can void the duplicate before the client pays twice or calls to complain, which protects the relationship and saves a refund.
Builds a habit of regular review
A message that arrives on the same day each week creates a small ritual. Billing is checked weekly rather than only when money gets tight, which is when mistakes are most expensive to discover.
How it works
What happens, step by step
Every Friday ClickRuntime gets the invoices created in Wave during the week.
It lists each one with the invoice number, customer, amount and status, and adds up the total billed.
The weekly record arrives in your inbox as one email.
Before it runs live
- Connect Wave
What you get
Build your own
Need it to work differently?
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 Wave steps into one automation
Under the hood
The code that runs this automation
from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, notify
BUSINESS_ID = "your-wave-business-id"
def wave(query, variables=None):
token = credentials.connection("wave", "work")
resp = http.post("https://gql.waveapps.com/graphql/public", headers={"Authorization": f"Bearer {token}"},
json={"query": query, "variables": {"biz": BUSINESS_ID, **(variables or {})}})
return resp.json()["data"]["business"]
QUERY = """query($biz: ID!, $start: Date!) { business(id: $biz) { invoices(invoiceDateStart: $start, pageSize: 100) {
edges { node { invoiceNumber status customer { name } total { value } } } } } }"""
@on_trigger
def run(event):
monday = date.today() - timedelta(days=date.today().weekday())
invoices = [e["node"] for e in wave(QUERY, {"start": monday.isoformat()})["invoices"]["edges"]]
lines = [f"#{i['invoiceNumber']} {i['customer']['name']}: {i['total']['value']} ({i['status']})" for i in invoices]
total = sum(float(i["total"]["value"]) for i in invoices)
notify.email_me(f"Wave invoices this week: {total:,.2f}", "\n".join(lines) or "No invoices this week.")
return {"count": len(lines), "total": total}FAQ
Common questions
Does the log include draft invoices?
What period does each weekly email cover?
Can the totals be split by currency?
What permissions does it need?
Does it need AI?
How many runs does it use?
Can I change how it works?
Related
You might also like
Email yourself overdue Wave invoices every Monday
The week starts with one email listing each late invoice and how much is still due.
See how it worksGet a Slack ping when a Wave invoice is paid
Within a quarter of an hour of an invoice turning paid, you see the customer and amount in Slack.
See how it worksPost new Wave customers to Slack
When a customer is added in Wave, their details appear in Slack within the hour.
See how it worksKeep exploring
Set up “Get a Friday summary of invoices you sent” from your assistant
Copy the prompt above, or connect your assistant first. Free plan, no credit card.
