Skip to content

Repository files navigation

Open Google MCP

A read-only Model Context Protocol (MCP) server for Google Ads (via GAQL), Search Console, and Google Analytics 4. Designed for AI assistants and LLM agents to safely read campaign performance, search analytics, website traffic, and more.

open-google-mcp

Tools

Google Ads

Tool Input Description
list_accessible_customers Discover Google Ads account IDs
get_resource_metadata resource_name Explore selectable/filterable/sortable fields for a resource
search customer_id, resource, fields, conditions?, orderings?, limit? Execute read-only GAQL queries

Google Search Console

Tool Input Description
gsc_get_capabilities Get categorized tool list with auth status
gsc_list_properties List all GSC properties (start here)
gsc_get_site_details site_url Verification/ownership for a property
gsc_get_search_analytics site_url, days?, dimensions?, row_limit? Top queries with clicks, impressions, CTR, position
gsc_get_performance_overview site_url, days? Executive summary with daily trend
gsc_compare_search_periods site_url, period1_start/end, period2_start/end Compare two date ranges
gsc_get_advanced_search_analytics site_url, start_date?, end_date?, dimensions?, search_type?, row_limit?, start_row?, sort_by?, sort_direction?, filters? Filtered, sorted, paginated analytics
gsc_inspect_url site_url, page_url Debug a URL's crawl/index status
gsc_get_sitemaps site_url List sitemaps with status and errors

Google Analytics 4

Tool Input Description
ga4_get_capabilities Get categorized tool list with auth status
ga4_list_properties Discover all accessible GA4 properties
ga4_get_metadata property_id Browse available dimensions and metrics
ga4_run_report property_id, dimensions?, metrics?, start_date?, end_date?, filters?, order_bys?, limit? Run a standard report with filtering and ordering
ga4_run_realtime_report property_id, dimensions?, metrics?, limit? Get real-time data (last 30 minutes)

Manager Account Auto-Routing

If search targets a manager (MCC) account and finds no data directly, it automatically:

  1. Detects the account is a manager
  2. Finds child accounts
  3. Runs the query on each child
  4. Returns combined results with _source_customer_id marking which account each row belongs to

Setup

Prerequisites (all paths)


Option A: Docker (recommended — no Python required)

1. Clone

git clone https://github.com/ceotind/open-google-mcp.git
cd open-google-mcp

2. Create and authorize a service account

A single service account authenticates Google Ads, Search Console, and Google Analytics 4.

  1. Go to GCP Console → APIs & Services → Credentials → Create Credentials → Service Account
  2. Download the JSON key file, then copy these fields into .env:
    • GOOGLE_SERVICE_ACCOUNT_EMAIL
    • GOOGLE_SERVICE_ACCOUNT_KEY (the private_key — keep the \n escapes)
    • GOOGLE_SERVICE_ACCOUNT_KEY_ID
    • GOOGLE_SERVICE_ACCOUNT_CLIENT_ID
    • GOOGLE_SERVICE_ACCOUNT_PROJECT_ID
  3. Google Ads: add the service account email in your manager account (Settings → Account access → Service account users)
  4. Search Console: add the same email to your property (Settings → Users and permissions → Add user, grant Full access)
  5. Google Analytics 4: add the same email to your GA4 property (Admin → Account Access Management → Add user → Viewer)

3. Configure .env

cp .env.example .env
# Edit .env with the service account values + developer token
Variable Description
GOOGLE_ADS_DEVELOPER_TOKEN Your Google Ads API developer token
GOOGLE_SERVICE_ACCOUNT_EMAIL Service account email
GOOGLE_SERVICE_ACCOUNT_KEY Private key (with \n newlines)
GOOGLE_SERVICE_ACCOUNT_KEY_ID Private key ID
GOOGLE_SERVICE_ACCOUNT_CLIENT_ID Client ID
GOOGLE_SERVICE_ACCOUNT_PROJECT_ID GCP project ID
GOOGLE_ADS_LOGIN_CUSTOMER_ID Optional — for MCC account routing
GA4_CREDENTIALS_PATH Optional — dedicated GA4 credential file

4. Build and run

docker compose build
docker compose run --rm open-google-mcp

5. MCP client config

Claude Desktop:

{
  "mcpServers": {
    "open-google-mcp": {
      "command": "docker",
      "args": ["compose", "run", "--rm", "open-google-mcp"],
      "workdir": "/path/to/open-google-mcp"
    }
  }
}

opencode:

{
  "mcp": {
    "open-google-mcp": {
      "type": "local",
      "command": ["docker", "compose", "run", "--rm", "open-google-mcp"],
      "workdir": "/path/to/open-google-mcp",
      "enabled": true
    }
  }
}

Cursor:

  • Name: open-google-mcp
  • Type: command
  • Command: docker compose run --rm open-google-mcp
  • Working directory: /path/to/open-google-mcp

Option B: Python (local install)

1. Clone and install

git clone https://github.com/ceotind/open-google-mcp.git
cd open-google-mcp
python3 -m venv .venv
source .venv/bin/activate
pip install -e .

2. Create and authorize a service account

Same steps as Option A above — a single service account works for Ads, GSC, and GA4.

  1. Go to GCP Console → APIs & Services → Credentials → Create Credentials → Service Account
  2. Download the JSON key file, then copy these fields into .env:
    • GOOGLE_SERVICE_ACCOUNT_EMAIL
    • GOOGLE_SERVICE_ACCOUNT_KEY
    • GOOGLE_SERVICE_ACCOUNT_KEY_ID
    • GOOGLE_SERVICE_ACCOUNT_CLIENT_ID
    • GOOGLE_SERVICE_ACCOUNT_PROJECT_ID
  3. Google Ads: add the service account email in your manager account
  4. Search Console: add the same email to your property with Full access
  5. Google Analytics 4: add the same email to your GA4 property with Viewer access

3. Configure .env

cp .env.example .env
Variable Description
GOOGLE_ADS_DEVELOPER_TOKEN Your Google Ads API developer token
GOOGLE_SERVICE_ACCOUNT_EMAIL Service account email
GOOGLE_SERVICE_ACCOUNT_KEY Private key (with \n newlines)
GOOGLE_SERVICE_ACCOUNT_KEY_ID Private key ID
GOOGLE_SERVICE_ACCOUNT_CLIENT_ID Client ID
GOOGLE_SERVICE_ACCOUNT_PROJECT_ID GCP project ID
GOOGLE_ADS_LOGIN_CUSTOMER_ID Optional — for MCC account routing
GA4_CREDENTIALS_PATH Optional — dedicated GA4 credential file

4. Run

source .venv/bin/activate
source .env
python -m open_google_mcp

Or use the wrapper script (loads .env automatically):

./server.sh

5. MCP client config

Claude Desktop:

{
  "mcpServers": {
    "open-google-mcp": {
      "command": "/path/to/open-google-mcp/server.sh"
    }
  }
}

opencode:

{
  "mcp": {
    "open-google-mcp": {
      "type": "local",
      "command": ["/path/to/open-google-mcp/server.sh"],
      "enabled": true
    }
  }
}

Cursor:

  • Name: open-google-mcp
  • Type: command
  • Command: /path/to/open-google-mcp/server.sh

Google Ads — Usage Examples

List Ads accounts

list_accessible_customers

Discover fields for a resource

get_resource_metadata(resource_name="campaign")

Get active search campaigns with performance

search(
  customer_id="1234567890",
  resource="campaign",
  fields=["campaign.id", "campaign.name", "campaign.status",
          "campaign.advertising_channel_type", "metrics.clicks",
          "metrics.impressions", "metrics.cost_micros"],
  conditions=["campaign.status = 'ENABLED'",
              "segments.date DURING LAST_30_DAYS"],
  orderings=["metrics.clicks DESC"],
  limit=10
)

Get child accounts under a manager

search(
  customer_id="1234567890",
  resource="customer_client",
  fields=["customer_client.id", "customer_client.descriptive_name", "customer_client.manager"]
)

Google Search Console — Usage Examples

List GSC properties

gsc_list_properties

Get search analytics

gsc_get_search_analytics(
  site_url="https://example.com",
  days=28,
  dimensions="query",
  row_limit=10
)

Get performance overview

gsc_get_performance_overview(
  site_url="https://example.com",
  days=28
)

Compare two time periods

gsc_compare_search_periods(
  site_url="https://example.com",
  period1_start="2025-01-01",
  period1_end="2025-01-31",
  period2_start="2025-02-01",
  period2_end="2025-02-28",
  dimensions="query",
  limit=10
)

Advanced analytics with filters

gsc_get_advanced_search_analytics(
  site_url="https://example.com",
  dimensions="query,device",
  search_type="WEB",
  row_limit=50,
  sort_by="impressions",
  sort_direction="descending",
  filters='[{"dimension":"country","operator":"equals","expression":"usa"}]'
)

Inspect a URL

gsc_inspect_url(
  site_url="https://example.com",
  page_url="https://example.com/blog/post"
)

List sitemaps

gsc_get_sitemaps(site_url="https://example.com")

Google Analytics 4 — Usage Examples

Start here — discover properties

ga4_list_properties

Returns your property ID (e.g. 123456789) — use it in all other GA4 tools.

Browse available dimensions and metrics

ga4_get_metadata(property_id="123456789")

Returns 300+ dimensions and 100+ metrics available for reporting.

Run a basic report (property-level summary)

ga4_run_report(
  property_id="123456789",
  metrics="activeUsers,sessions,newUsers",
  start_date="28daysAgo",
  end_date="today"
)

Top countries by users

ga4_run_report(
  property_id="123456789",
  dimensions="country",
  metrics="activeUsers",
  start_date="28daysAgo",
  end_date="today",
  limit=10,
  order_bys=[{"metric": "activeUsers", "desc": true}]
)

Top pages with views

ga4_run_report(
  property_id="123456789",
  dimensions="pagePath",
  metrics="screenPageViews,activeUsers",
  start_date="28daysAgo",
  end_date="today",
  limit=10,
  order_bys=[{"metric": "screenPageViews", "desc": true}]
)

Traffic sources breakdown

ga4_run_report(
  property_id="123456789",
  dimensions="sessionDefaultChannelGrouping",
  metrics="activeUsers,sessions",
  start_date="28daysAgo",
  end_date="today",
  limit=10,
  order_bys=[{"metric": "activeUsers", "desc": true}]
)

Filter by country (e.g. only Ireland)

ga4_run_report(
  property_id="123456789",
  dimensions="city",
  metrics="activeUsers",
  start_date="28daysAgo",
  end_date="today",
  filters={"field": "country", "type": "string_filter",
           "value": "Ireland", "match_type": "EXACT"},
  limit=10
)

Device breakdown

ga4_run_report(
  property_id="123456789",
  dimensions="deviceCategory",
  metrics="activeUsers,sessions",
  start_date="28daysAgo",
  end_date="today"
)

Real-time report (last 30 minutes)

ga4_run_realtime_report(
  property_id="123456789",
  dimensions="country,deviceCategory",
  metrics="activeUsers",
  limit=10
)

Date formats

You can use relative or absolute dates:

  • Relative: today, yesterday, 7daysAgo, 28daysAgo, 30daysAgo
  • Absolute: 2026-01-01 (YYYY-MM-DD format)

GAQL Tips

  • Field names must be fully qualified: campaign.id, not id
  • Date format: YYYY-MM-DD with dashes
  • Relative dates: DURING LAST_7_DAYS, LAST_30_DAYS, THIS_MONTH, THIS_QUARTER
  • For change_event resource, limit must be ≤ 10000
  • Conditions are AND-combined
  • Use get_resource_metadata first to discover valid fields

License

MIT

About

Feed data from Google Ads, G4 Analytics and Google Search Console to your AI

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages