Automate Google Ads Analysis with GPT-5.4 in n8n Workflows

Stop wasting ad budget on irrelevant search queries. This n8n workflow automates your Google Ads search term analysis using GPT-5.4, transforming manual spreadsheet reviews into an intelligent, automated pipeline that delivers actionable keyword recommendations directly to Google Sheets.

What this workflow does

This production-ready automation connects Google Ads API, OpenAI, and Google Sheets to create a comprehensive search term intelligence system that runs every 30 days or on-demand:

• Extracts complete search term data from Google Ads - Uses Google Ads API (GAQL searchStream) to pull every search term that triggered ads in the last 30 days, including campaign context, matched keywords, match types, search term status, and full performance metrics (impressions, clicks, CTR, cost, conversions, conversion rates)
• Processes and cleans raw data - Code nodes normalize API data, format currency and percentages, apply metrics thresholds, and structure clean datasets for AI analysis
• Performs AI-powered search term analysis - GPT-5.4 analyzes each search term for relevance, intent matching, and performance optimization opportunities
• Generates structured reports in Google Sheets - Automatically saves comprehensive analysis with actionable keyword exclusion and inclusion recommendations

Use cases

• PPC managers - Eliminate manual search term reviews and identify budget-wasting queries automatically
• Digital marketing agencies - Scale search term optimization across multiple client accounts with consistent AI-driven analysis
• In-house marketing teams - Maintain clean, high-performing Google Ads campaigns without dedicating hours to manual keyword analysis
• Campaign optimization - Discover high-intent search terms for keyword expansion and low-relevance terms for negative keyword lists

Technical details

Built with essential n8n nodes including HTTP Request for Google Ads API integration, Code nodes for data processing, Google Sheets connector for report automation, Set nodes for data manipulation, and Manual Trigger for on-demand execution. This workflow transforms complex Google Ads search term data into actionable intelligence using advanced AI analysis.