Template · Watch
What’s-on-fire board
Every client ranked by ACoS drift, spend spike and sales drop.
For agenciesClaude Code about 20 minReads ✓ · Writes —
Example output · placeholder clients
Example outputReads ✓ · Writes —
Client board · Mon 7:00Synced to Sheets
clientACoSspendsales
Kettle Lane+6.1 pts+34%−12%
Lumen Audio+4.3 pts+9%−2%
Petal & Co+0.8 pts+3%−6%
Trailhead+0.2 pts−1%+4%
Northwind−0.4 pts+2%+7%
2 on fire · worst first
What you need
Three things. It checks them off as you go.
1 of 3 readyA Build keyFree for one account. No card.
ReadyYour accountsAmazon Ads and Seller, for each client.
3 of 5Northwind ✓Lumen Audio ✓Petal & Co ✓Trailhead pendingKettle Lane pending
Where it landsA Google Sheet for the board.
client-boardHow it runs
Whole run: about 1 minute. Times are estimates.The worst client, first.
7:00
Wakes up
Your schedule starts the run, every morning at 7.
about 40 sec
Reads
Yesterday against the last 7 days, for every client.
about 10 sec
Ranks
Scores ACoS drift, spend spike and sales drop.
about 5 sec
Fills the board
Writes one row per client to your Sheet, worst first.
Wakes up 7:00
Your schedule starts the run.
Reads about 40 sec
Yesterday against 7 days, every client.
Ranks about 10 sec
Scores drift, spike and drop.
Fills the board about 5 sec
One row per client, worst first.
Whole run: about 1 minute. Times are estimates.
The prompt
Paste this into your AI.
Works inClaude CodeCursorLovablen8nZapier
Every morning, read ACoS, spend and sales for every client and rank them worst first by ACoS drift, spend spike and sales drop in the Google Sheet client-board. Docs: https://build.sellermate.ai/docs. My key is in BUILD_API_KEY.
BUILD_API_KEYYour key, set as a variable. Never paste the key itself.
client-boardThe Sheet the board is written to.
every clientKeep it, or name the clients.
Day two
Change it. Schedule it. Fix it.
Change it
Paste one line to your AI.
Schedule it
Every morning at 7. Where you set it:
n8nSchedule node
ZapierSchedule trigger
AI toolsAsk for a scheduled run
If it breaks
A failed run says so on the board, not a stale ranking.
Sheets write failed:
permission_denied
permission_denied
Paste it to your AI
Three questions
Short answers.
Is it free?
The template is free. So is one account, with no card. More accounts are on the pricing page.
Can I change it?
Yes. It is a prompt you own. Ask your AI for any edit, like the three above.
What if it breaks?
A failed read says so at the top of the board, not a stale ranking. Paste the error to your AI.
More in Watch
All templates →Same job, other tools.
Lumen budgetend 118%
Budget pacing alert
A Slack line per client with month-end spend.
n8nReads ✓ · Writes — about 15 min
Northwindsynced 2m
Lumen Audiosynced 2m
Petal & Coauth lapsed
Connection health alert
A Slack alert when data is stale or access lapsed.
n8nReads ✓ · Writes — about 10 min
BuildMon 8:01
Monday report · 5 clientsNorthwind$8.2k20%Lumen Audio$6.9k24%Petal & Co$5.1k27%
Monday client report to Slack
One Slack card per client, plus a Sheet row.
n8nReads ✓ · Writes — about 20 min
See what is on fire today.
Free for one account, no card. About 20 minutes.