Generate a Google Ads keyword plan from seed keywords with Keyword Planner and OpenAI
Go to Workflow
Zeljislav Petrovic
Description
Who is this template for?
This workflow is built for digital marketers, SEO/PPC specialists, and business owners who run or plan Google Ads campaigns and need a fast, structured way to discover and evaluate keywords. Instead of manually exporting data from Google Keyword Planner and sorting it in spreadsheets, this template automates the entire process — from raw seed keywords to a fully enriched, AI-analyzed keyword plan saved directly in Google Sheets.
What this workflow does
This n8n workflow connects Google Keyword Planner, OpenAI chat model, and Google Sheets to deliver a production-ready keyword research pipeline:
User submits a form with their website URL, company name, industry/niche, seed keywords, and products/services
Google Keyword Planner API returns keyword ideas with real search volume, competition level, and CPC bid range data
OpenAI chat model (e.g, GPT-5.4-mini) analyzes all keyword ideas in business context — scoring relevance, classifying intent (informational, navigational, commercial, transactional), assigning keyword type (branded, competitor, product, application, etc.), and generating additional relevatn high-intent keyword suggestions.
Google Sheets receives two outputs: a structured keyword plan sheet (AI-enriched, evaluated, scored, and classified) and a raw keyword ideas sheet (all Keyword Planner results)
The result is a complete, ready-to-use keyword strategy document your team can act on immediately.
How to set up
Google Ads API — Create a Google Ads Developer Token and OAuth 2.0 credentials. Add your Google Ads Customer ID to the workflow. Follow the official Google Ads API quickstart.
OpenAI — Add your OpenAI API credentials to the OpenAI chat model node.
Google Sheets — Connect your Google account via OAuth 2.0. The workflow automatically creates a new spreadsheet for each run — no manual sheet setup required.
Configure the HTTP Request node — Update the Customer ID, Developer Token, and geo/language targeting to match your market.
Activate the workflow and submit the form to run your first keyword research & planning session.
Requirements
n8n (cloud or self-hosted)
Google Ads account with API access and a Developer Token
OpenAI API key (GPT-4.1-mini or higher recommended)
Google account with Sheets access
What you get in the output
The workflow automatically creates a new Google Spreadsheet on every run with two sheets:
📊 Keyword Plan
AI-evaluated, scored, and classified keywords ready for Google Ads — filtered to relevance score 5 or higher:
keyword — the keyword text
searchIntent — informational, commercial, transactional, or navigational
keywordType — branded, competitor, product/service, feature/spec, synonym, application, or solution
source — Keyword Planner or AI
seedKeyword — which seed keyword this idea originated from
relevanceScore — AI score (1–10) based on your business context
avgMonthlySearches — monthly search volume from Google Keyword Planner
competition — LOW / MEDIUM / HIGH
recommendedBid — AI-calculated CPC bid recommendation in USD
recommendedMatchType — recommended Google Ads match type (Broad, Phrase, or Exact)
📋 All Keyword Ideas
Raw, unfiltered output from Google Keyword Planner — useful as a reference or for manual review:
keyword — the keyword text
avgMonthlySearches — monthly search volume
competition — LOW / MEDIUM / HIGH
competitionIndex — numeric competition score (0–100)
lowTopOfPageBid — low end of the estimated CPC range in USD
highTopOfPageBid — high end of the estimated CPC range in USD
How to customize this workflow
Change the AI model** — swap GPT-5.4-mini for Claude, Gemini, or any LLM supported by n8n
Add geo/language targeting** — modify the HTTP request body to filter results by country and language
Adjust the relevance threshold** — edit the AI prompt to change the minimum relevance score for inclusion
Add Slack or email notifications** — append a notification node after the Google Sheets write to alert your team when a new keyword plan is ready
Connect to a CMS or ad platform** — pipe the output directly into your Google Ads campaigns or content calendar
This workflow was created by Zeljislav Petrovic and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.