Analyze Google Ads search terms and get negative keyword suggestions with OpenAI GPT-5.4-mini

Who is this template for?

This workflow is built for PPC managers, digital marketing agencies, and in-house marketing teams who run Google Ads search campaigns and want to stop wasting budget on irrelevant queries. Instead of manually reviewing hundreds or thousands of search terms in spreadsheets, this template automates the entire analysis pipeline — from raw Google Ads data to a fully structured, AI-analyzed search terms report with actionable keyword exclusion and inclusion recommendations, saved directly to Google Sheets.

---

What this workflow does

This n8n workflow connects the Google Ads API, an OpenAI chat model, and Google Sheets to deliver a production-ready search term intelligence pipeline that runs automatically every 30 days — or on demand:

1. Pulls search term data directly from Google Ads — using the Google Ads API (GAQL searchStream), the workflow fetches every search term that triggered an ad in the last 30 days, including campaign and ad group context, matched keyword, match type, search term status (Added / Excluded / None), and full performance metrics: impressions, clicks, CTR, cost, avg CPC/CPM, conversions, conversion rate, and cost per conversion

2. Cleans and formats the dataset for AI — a Code node normalizes and filters raw API data: formats currency and percentage values, applies a metrics threshold filter, and structures the data as a clean input for the AI model

3. Runs a comprehensive AI analysis on every search term — an OpenAI chat model (GPT-5.4-mini or any LLM supported by n8n) acts as a senior PPC strategist. For each term, it outputs: - Intent signal — Transactional, Commercial, Informational, or Navigational - Relevancy — on a 5-level scale from Directly Relevant to Directly Irrelevant - Relevancy reasoning — a specific, business-context-aware explanation referencing campaign fit, intent, and performance signals - Exclusion suggestion — exact negative keyword with correct match type syntax (broad, phrase, or exact) - Exclusion level — Account, Campaign, or Ad Group - Priority for exclusion — High, Medium, Low, or N/A - Inclusion suggestion — keyword to add with recommended match type - Inclusion type — New keyword, New ad group, or New campaign - Inclusion level — Account, Campaign, or Ad Group