PPC & Ads · Blog post · source Aug 1, 2025
Weekly KPI Report and Search Term Insights with n8n and OpenAI
Turn Ads console and Seller Central data into a weekly report with search term findings
She calls it a move from a tedious manual workflow to a strategic asset, but gives no time or ACOS figures.
Per source Self-reported by the source, not independently verified.
Copy-paste prompt
Here is last week's Sponsored Products search term report (CSV). Target ACOS [30]%. List: 1) search terms with at least [15] clicks and no orders, by spend; 2) converting search terms that aren't keywords in any campaign; 3) terms where broad or phrase is converting but exact isn't running; 4) any campaign whose spend or ACOS moved more than 25% from the prior week. Return a table for each, numbers only, no advice paragraph.
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 Amazon listings and PPC manager built a stack in n8n with GPT that extracts data from the Amazon Advertising Console and Seller Central, builds a weekly report with KPI tracking, and sends updates to Google Sheets, ClickUp and email. A GPT step merges the raw search term data with analysis to flag keywords they aren't targeting, wasted spend and poor match types, and performance anomalies.
How it went
She calls it a move from a tedious manual workflow to a strategic asset, but gives no time or ACOS figures.
We only report what the source says. Results are self-reported unless noted.
Worth knowing
A first-hand LinkedIn post without numbers. GPT here runs inside n8n, so it's the OpenAI API rather than the ChatGPT app. Give the model your target ACOS and minimum clicks so 'wasted spend' means the same thing every week.