Who is this template for?
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. An n8n automation workflow template by Zeljislav Petrovic.
Zeljislav Petrovic
web
free
Others in the same category, ranked by how often they are opened.
