The Problem

The $1,800/Year SEO Tool Tax

Almost every content marketer, developer, or business owner writing articles buys a subscription to Ahrefs, Semrush, or Moz. The primary reason? They want to find search volume trends. They want to know if writing about seo automation is worth their time compared to keyword research tool.

This adds up to $100–$200 per month. But the irony is that these tools don't own search volume data—they fetch, scrape, or estimate it from Google's own databases. Google is the source of truth, and Google offers it for free via the Google Ads Keyword Planner.

But accessing it manually is painful. The Google Ads Web UI is notoriously slow. You have to log in, navigate through five different sub-menus, type terms one by one, wait for page reloads, and close pop-ups urging you to launch a paid ad campaign. It wastes time and kills productivity.

Direct API Access: The Developer's Shortcut

You can bypass the slow web interface entirely. By querying Google's database directly through the Google Ads API, you can extract exact monthly search volumes and competition metrics using a simple terminal command. And you can do it without active ad campaigns or billing setup.

The Solution

Google Ads API Keyword Planner Script

I built and open-sourced a lightweight Python boilerplate script that interfaces directly with Google Ads API. It loads credentials safely from a local configuration, connects to Google's KeywordPlanIdeaService, and outputs sorted results in your terminal in under 5 seconds.

Here is what the script output looks like in practice:

Fetching keyword ideas for: ['seo automation', 'keyword research tool']...

================================================================================
Keyword | Avg Monthly Searches | Competition
================================================================================
keyword planner google | 390 | MEDIUM
keyword analyse tool | 260 | MEDIUM
seo automation | 110 | MEDIUM
keyword research tool | 110 | MEDIUM
================================================================================
Standard Flow

The Bloated Web UI

  • Open slow Google Ads manager dashboard
  • Click Tools > Keyword Planner (45-second load)
  • Type seeds, click get results
  • Close popups to input credit card info
  • Manually export CSV file, import to sheets
Automated Flow

The Terminal Script

  • Type seeds inside python script file
  • Run: python google_ads_keywords.py
  • Get a formatted table in 4 seconds
  • Data is ready to be piped to files or other APIs
AI Integration

Automating Content Generation via Agent Skills

Having a command-line script is great, but the real power comes from integration. Because this script runs on standard Python code, it can be defined as an Agent Skill for custom AI workflows (like n8n, LangChain, or Cursor/Claude Code assistants).

Before drafting any article on your site, your AI agent can run the script programmatically to analyze keywords, identify terms with search traffic, and automatically structure your page headers (H1 to H6) to match real-world queries. This removes guesswork entirely and guarantees that your content targets active intent.

Structuring your headers correctly is not just good for Google Search ranking—it is also a key factor for visibility in conversational AI answers. If search bots cannot parse your page hierarchy, your content won't get cited. You can read more about this in my detailed AI Visibility Guide.

Want to integrate this keyword automation into your own CRM or AI workflows?

I help businesses build custom content pipelines, connect APIs, and set up automated search volume tracking. Let’s map out your automation goals.

Book a free 30-min strategy call →
Installation & Run

How to Set it Up

Setting up the Google Ads API client library is completely free and requires zero active ad budget, but the Google developer console has a few authentication requirements (like generating a developer token, creating OAuth credentials, and preventing the 7-day token expiration issue).

I have written a comprehensive, step-by-step setup guide covering every stage of the setup in the repository's documentation.

👉 Read the full setup walkthrough on the google-ads-keyword-extractor GitHub page.

Get the Open Source Keyword Extractor Code

Clone the script template, access the step-by-step setup guides, and start pulling search volumes locally in seconds.

Clone on GitHub →
FAQ

Frequently Asked Questions

Do I need to pay or add a credit card to get a developer token?
No. Requesting a Developer Token in the Google Ads API Center is completely free. The Test Access token is granted instantly without requiring any billing setup or active credit cards.
Why does the script return broad ranges (like 1K-10K) instead of exact volume?
Google restricts exact search volumes (e.g. 4400) to Google Ads accounts with active ad spend. If your account has zero ad spend, the API returns ranges (e.g., 100-1K, 1K-10K). These ranges are still highly effective for comparing keyword priorities. If you use a customer ID with active/historical spend, you will get exact numbers.
Why does my OAuth refresh token expire every 7 days?
If your token expires weekly, it is because your Google Cloud Console project's OAuth screen is in "Testing" mode. Go to Cloud Console > APIs & Services > OAuth consent screen and click "Publish App". This moves the app to "In Production" status, preventing token expiration for personal use.
How does Google search volume help with AI search visibility (GEO)?
People phrase queries similarly whether typing into Google or prompting ChatGPT/Perplexity. Knowing the terms with real search volume helps you optimize your semantic headings (H1-H6). When AI engines perform live web crawls to generate answers, your page matches their semantic search patterns perfectly.
Need help automating your marketing or SEO workflows?

I build custom, code-first AI automations (RAG agents, backend integrations, and technical SEO/GEO setups). Munich-based developer working with international clients.

← Back to articles