Template · Change
Wasted-spend sheet
Zero-sale, high-click search terms, every week.
For agencies and brandsZapier about 10 minReads ✓ · Writes —
Or copy the prompt for your AIExample output · placeholder clients
Example outputReads ✓ · Writes —
Synced to Sheets
search termclicksspendsales
2vase gift38$412$0
3kettle red29$388$0
4free vase22$201$0
5speaker stand17$96$0
Spent, never sold$1,097
What you need
Three things. It checks them off as you go.
2 of 3 readyA Build keyFree for one account. No card.
ReadyYour accountsAmazon Ads, one account or many.
1 of 1Amazon Ads ✓
Where it landsA Google Sheet for the list.
wasted-spendHow it runs
Whole run: about 30 seconds. Times are estimates.A clean list, every Monday.
Mon 7:00
Wakes up
Your schedule starts the run, Mondays at 7.
about 20 sec
Reads
The last 30 days of search terms.
about 5 sec
Filters
Keeps terms with many clicks and no sales.
about 5 sec
Writes
One row per term in your Sheet, costliest first.
Wakes up Mon 7:00
Your schedule starts the run.
Reads about 20 sec
30 days of search terms.
Filters about 5 sec
Many clicks, no sales.
Writes about 5 sec
One row per term, costliest first.
Whole run: about 30 seconds. Times are estimates.
The prompt and the flow
Paste this into your AI.
Works inClaude CodeCursorLovablen8nZapier
Build me a Zapier zap that every Monday finds Amazon Ads search terms with 15 or more clicks and no sales in the last 30 days, and adds them to the Google Sheet wasted-spend, costliest first. 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.
wasted-spendThe Sheet the list is written to.
15 or more clicksChange the click limit.
Day two
Change it. Schedule it. Fix it.
Change it
Paste one line to your AI.
Schedule it
Mondays at 7. Where you set it:
n8nSchedule node
ZapierSchedule trigger
AI toolsAsk for a scheduled run
If it breaks
A failed run emails you the error, not an empty sheet.
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 run emails you the error, not an empty sheet. Paste the error to your AI.
More in Change
All templates →Same job, other tools.
14 proposedclicks · sales
+ vase gift38 · $0
+ free vase22 · $0
Approve allthen applied
Negatives sweep with approval
Proposed negatives, applied after you approve.
Claude CodeReads ✓ · Writes ✓ about 30 min
Build
12 bid changes · 4 clientscap $2.00 · undo 24h
ApproveReject
Approval queue for bid and budget changes
Tap to approve, then applied, with a change log.
LovableReads ✓ · Writes ✓ about 60 min
63
Waste high
Stock fine
Margin unknown
Stock fine
Margin unknown
30-day account audit
A generated audit sheet to win the pitch.
Claude CodeReads ✓ · Writes — about 20 min
Find your wasted spend today.
Free for one account, no card. About 10 minutes.