PPC & Ads · Workflow template · source Apr 29, 2025
PPC Recommendations from Ads Reports with an n8n Template
Email yourself bid, budget and keyword recommendations from ads reports
Template only: it sends recommendations by email and doesn't change bids itself.
Per source A published workflow template, not a reported result.
Copy-paste prompt
You are analyzing my last 30 days of Amazon Sponsored Products reports (search term, targeting, campaign, placement, budget). Target ACOS: [x]%. Return: 1) search terms to add as negatives (spend, clicks, 0 orders); 2) search terms to harvest into exact match; 3) bid changes by target, max ±[20]%, with the reason; 4) placement adjustments; 5) campaigns limited by budget that are under target ACOS. Recommendations only, with the numbers behind each.
The source didn't publish its exact prompt. We wrote this starter so you can try the same workflow. Replace anything in [brackets].
What they did
An n8n template by Brian Money downloads Sponsored Products reports from a Google Drive folder (CSV or XLSX), has OpenAI's GPT-4o analyze campaign, keyword, placement, targeting and budget performance, and emails structured optimization recommendations through Gmail. You schedule five reports in the Amazon Ads console (Search Term and Targeting detailed; Campaign, Placement and Budget summary; last 30 days, daily).
How it went
Template only: it sends recommendations by email and doesn't change bids itself. The page lists setup time as 15-30 minutes and says it handles multiple ASINs and ad accounts.
We only report what the source says. Results are self-reported unless noted.
Worth knowing
This is a published workflow template, not a reported result: nobody in the source says what it did for their sales. Read the template's setup steps and test it on one account before you rely on it. You need an OpenAI API key; the Amazon Ads API is optional.