MCP servers for Google Search Console and Google Keyword Planner

Przegląd projektu

Marketing agency serving 20+ SEO/PPC clients needed automated access to data from Google Search Console (performance, indexing, Core Web Vitals) and Google Keyword Planner (keyword volume, CPC estimates, competition). Manual data export from dashboards took 5-10h weekly, and paid SEO tools like Ahrefs ($99-999/mo) and SEMrush ($119-449/mo) generated costs of $200-1500/month for the entire agency.

Wyzwanie

Agency without automated access to Google Search Console and Google Keyword Planner was losing dozens of hours monthly on manual data export. Paid SEO tools (Ahrefs, SEMrush) cost $200-1500/month for 5-person team, yet still didn't provide direct access to real-time GSC data.

Manual GSC data export

For each of 20+ clients had to manually enter Google Search Console, select date range, export CSV with queries/pages/countries, consolidate data in spreadsheets. 5-10h weekly wasted on copy-paste.

High costs of paid SEO tools

Ahrefs ($99-999/mo), SEMrush ($119-449/mo), Moz ($99-599/mo) for 5-person team costs $200-1500/month. Yet none of these tools give direct access to GSC API - they show own estimates, not real data.

No programmatic access to Keyword Planner

Google Keyword Planner available only through Google Ads interface - impossible automated keyword research. Each keyword research required manual entry of seed keywords, copying volume/CPC data to spreadsheets.

No integration with custom dashboards

Data from GSC and Keyword Planner locked in Google interfaces - no possibility to integrate with own CRM/client dashboard. Reports created manually in Google Sheets instead of automated live dashboards.

Nasze rozwiązanie

We built 2 MCP servers (Model Context Protocol) providing automated access to Google Search Console API and Google Ads Keyword Planner API. OAuth 2.0 authentication, automated data fetching (queries, impressions, CTR, position, keyword volume, CPC), integration with Claude Code for instant SEO analysis. Zero recurring costs - alternative to Ahrefs/SEMrush.

Google Search Console MCP Server

MCP server in Node.js/TypeScript with Google Search Console API integration. OAuth 2.0 flow (consent screen, refresh tokens), endpoints: (1) searchAnalytics - queries, impressions, CTR, avg position for date range and dimensions (query/page/country/device), (2) sitemaps - sitemap list, status, errors, (3) urlInspection - indexing status, crawl info, mobile usability, Core Web Vitals for specific URLs.

Google Keyword Planner MCP Server

MCP server with Google Ads API (Keyword Planner service). OAuth 2.0 + developer token, manager account access. Endpoints: (1) getKeywordIdeas - seed keywords → suggestions list with monthly search volume, competition (LOW/MEDIUM/HIGH), avg CPC, (2) getHistoricalMetrics - historical volume/CPC trends for keyword list, (3) getAdGroupKeywords - keyword ideas grouped by ad groups (for PPC campaigns).

Claude Code Integration

MCP servers integration with Claude Code - user can request SEO analysis via chat ('show me top 10 queries for domain X last 30 days', 'get keyword volume for marketing automation', 'compare CTR desktop vs mobile'). Claude automatically calls MCP tools, parses JSON response, presents insights in table/markdown.

Automated Reporting & Dashboards

Ability to build custom dashboards/reports with real-time GSC and Keyword Planner data. Example: Python script calling MCP endpoints via stdin/stdout (MCP protocol), fetching data for all 20+ clients, generating PDF reports with charts (matplotlib), sending via email (SendGrid). Zero manual work.

Schedule free consultation about your project

During 30-minute call we'll analyze your business requirements and propose fastest path to implementation. We think business-first - goal first, then technology.

Phone

Subject

You consent to telephone contact for the purpose of handling this application and accept the Privacy Policy of HeyNeuron.com Big Growth Sp. z o.o.

Proces realizacji

Days 1-2

Planning & API Setup

Research Google Search Console API and Google Ads API (Keyword Planner), setup Google Cloud Project (enable APIs, OAuth consent screen), create OAuth 2.0 credentials (client ID, client secret), apply for Google Ads developer token, design MCP server architecture (endpoints, data models).

Days 3-6

Development - GSC MCP Server

Development Google Search Console MCP server (Node.js/TypeScript): OAuth 2.0 flow (authorization code → access token, refresh token storage), searchAnalytics endpoint (queries, impressions, CTR, position with filters: date range, dimensions, row limit), sitemaps endpoint (sitemap URLs list, status, errors), urlInspection endpoint (indexing status, crawl date, mobile usability, Core Web Vitals), error handling, rate limiting (200 queries/min quota).

Days 7-10

Development - Keyword Planner MCP Server

Development Google Keyword Planner MCP server: OAuth 2.0 + developer token authentication, manager account setup (link client accounts), getKeywordIdeas endpoint (seed keywords → suggestions with volume/CPC/competition), getHistoricalMetrics endpoint (volume/CPC trends by month), keyword filtering (min/max volume, competition level), response parsing (extract monthly_searches, avg_monthly_searches, competition, cpc_bid).

Days 11-12

Integration & Documentation

MCP servers integration with Claude Code (MCP config, test prompts), documentation of usage examples ('show top queries', 'get keyword volume for X', 'compare CTR'), deployment instructions (npm install, OAuth setup, .env config), tests with real client accounts (20+ GSC domains, Google Ads accounts), agency team onboarding.

Czas realizacji

12 days

Zakres usługi

API Integration & Automation

Technologie

Node.js/TypeScript

Google Search Console API

Google Ads API

OAuth 2.0

MCP SDK

Claude Code

Galeria projektu

Chcesz podobnych wyników?

Umów się na bezpłatną konsultację i sprawdź, jak AI może pomóc Twojemu biznesowi.

Umów bezpłatną konsultację