🎁 Get the FREE AI Skills Starter Guide β€” Subscribe β†’
BytesAgainBytesAgain
πŸ¦€ ClawHub

Google Ads

by @byungkyu

Google Ads API integration with managed OAuth. Query campaigns, ad groups, keywords, and performance metrics with GAQL. Use this skill when users want to int...

Versionv1.0.7
Downloads7,357
Stars⭐ 20
TERMINAL
clawhub install google-ads-api

πŸ“– About This Skill


name: google-ads description: | Google Ads API integration with managed OAuth. Query campaigns, ad groups, keywords, and performance metrics with GAQL. Use this skill when users want to interact with Google Ads data. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway). compatibility: Requires network access and valid Maton API key metadata: author: maton version: "1.0" clawdbot: emoji: 🧠 requires: env: - MATON_API_KEY

Google Ads

Access the Google Ads API with managed OAuth authentication. Query campaigns, ad groups, keywords, and performance metrics using GAQL.

Quick Start

# List accessible customers
python <<'EOF'
import urllib.request, os, json
req = urllib.request.Request('https://api.maton.ai/google-ads/v23/customers:listAccessibleCustomers')
req.add_header('Authorization', f'Bearer {os.environ["MATON_API_KEY"]}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))
EOF

Base URL

https://api.maton.ai/google-ads/{native-api-path}

Maton proxies requests to googleads.googleapis.com and automatically injects OAuth and developer tokens.

Authentication

All requests require the Maton API key in the Authorization header:

Authorization: Bearer $MATON_API_KEY

Environment Variable: Set your API key as MATON_API_KEY:

export MATON_API_KEY="YOUR_API_KEY"

Getting Your API Key

1. Sign in or create an account at maton.ai 2. Go to maton.ai/settings 3. Copy your API key

Connection Management

Manage your Google Ads OAuth connections at https://api.maton.ai.

List Connections

python <<'EOF'
import urllib.request, os, json
req = urllib.request.Request('https://api.maton.ai/connections?app=google-ads&status=ACTIVE')
req.add_header('Authorization', f'Bearer {os.environ["MATON_API_KEY"]}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))
EOF

Create Connection

python <<'EOF'
import urllib.request, os, json
data = json.dumps({'app': 'google-ads'}).encode()
req = urllib.request.Request('https://api.maton.ai/connections', data=data, method='POST')
req.add_header('Authorization', f'Bearer {os.environ["MATON_API_KEY"]}')
req.add_header('Content-Type', 'application/json')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))
EOF

Get Connection

python <<'EOF'
import urllib.request, os, json
req = urllib.request.Request('https://api.maton.ai/connections/{connection_id}')
req.add_header('Authorization', f'Bearer {os.environ["MATON_API_KEY"]}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))
EOF

Response:

{
  "connection": {
    "connection_id": "{connection_id}",
    "status": "ACTIVE",
    "creation_time": "2025-12-08T07:20:53.488460Z",
    "last_updated_time": "2026-01-31T20:03:32.593153Z",
    "url": "https://connect.maton.ai/?session_token=...",
    "app": "google-ads",
    "metadata": {}
  }
}

Open the returned url in a browser to complete OAuth authorization.

Delete Connection

python <<'EOF'
import urllib.request, os, json
req = urllib.request.Request('https://api.maton.ai/connections/{connection_id}', method='DELETE')
req.add_header('Authorization', f'Bearer {os.environ["MATON_API_KEY"]}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))
EOF

Specifying Connection

If you have multiple Google Ads connections, specify which one to use with the Maton-Connection header:

python <<'EOF'
import urllib.request, os, json
data = json.dumps({'query': 'SELECT campaign.id, campaign.name FROM campaign'}).encode()
req = urllib.request.Request('https://api.maton.ai/google-ads/v23/customers/1234567890/googleAds:search', data=data, method='POST')
req.add_header('Authorization', f'Bearer {os.environ["MATON_API_KEY"]}')
req.add_header('Content-Type', 'application/json')
req.add_header('Maton-Connection', '{connection_id}')
print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))
EOF

If you have multiple connections, always include this header to ensure requests go to the intended account.

Security & Permissions

  • Access is scoped to campaigns, ad groups, ads, keywords, and reporting within the connected Google Ads account.
  • All write operations require explicit user approval. Before executing any create, update, or delete call, confirm the target resource and intended effect with the user.
  • API Reference

    List Accessible Customers

    GET /google-ads/v23/customers:listAccessibleCustomers
    

    Search (GAQL Query)

    POST /google-ads/v23/customers/{customerId}/googleAds:search
    Content-Type: application/json

    { "query": "SELECT campaign.id, campaign.name, campaign.status FROM campaign ORDER BY campaign.id" }

    Search Stream (for large results)

    POST /google-ads/v23/customers/{customerId}/googleAds:searchStream
    Content-Type: application/json

    { "query": "SELECT campaign.id, campaign.name FROM campaign" }

    Common GAQL Queries

    List Campaigns

    SELECT campaign.id, campaign.name, campaign.status, campaign.advertising_channel_type
    FROM campaign
    WHERE campaign.status != 'REMOVED'
    ORDER BY campaign.name
    

    Campaign Performance

    SELECT campaign.id, campaign.name, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions
    FROM campaign
    WHERE segments.date DURING LAST_30_DAYS
    ORDER BY metrics.impressions DESC
    

    List Ad Groups

    SELECT ad_group.id, ad_group.name, ad_group.status, campaign.id, campaign.name
    FROM ad_group
    WHERE ad_group.status != 'REMOVED'
    

    List Keywords

    SELECT ad_group_criterion.keyword.text, ad_group_criterion.keyword.match_type, metrics.impressions, metrics.clicks
    FROM keyword_view
    WHERE segments.date DURING LAST_30_DAYS
    

    Code Examples

    JavaScript

    // Get customer IDs
    const customers = await fetch(
      'https://api.maton.ai/google-ads/v23/customers:listAccessibleCustomers',
      { headers: { 'Authorization': Bearer ${process.env.MATON_API_KEY} } }
    ).then(r => r.json());

    // Query campaigns const campaigns = await fetch( https://api.maton.ai/google-ads/v23/customers/${customerId}/googleAds:search, { method: 'POST', headers: { 'Content-Type': 'application/json', 'Authorization': Bearer ${process.env.MATON_API_KEY} }, body: JSON.stringify({ query: 'SELECT campaign.id, campaign.name FROM campaign' }) } ).then(r => r.json());

    Python

    import os
    import requests

    headers = {'Authorization': f'Bearer {os.environ["MATON_API_KEY"]}'}

    Query campaigns

    response = requests.post( f'https://api.maton.ai/google-ads/v23/customers/{customer_id}/googleAds:search', headers=headers, json={'query': 'SELECT campaign.id, campaign.name FROM campaign'} )

    Notes

  • Use listAccessibleCustomers first to get customer IDs
  • Customer IDs are 10-digit numbers (remove dashes)
  • Monetary values are in micros (divide by 1,000,000)
  • Date ranges: LAST_7_DAYS, LAST_30_DAYS, THIS_MONTH
  • Status values: ENABLED, PAUSED, REMOVED
  • IMPORTANT: When using curl commands, use curl -g when URLs contain brackets (fields[], sort[], records[]) to disable glob parsing
  • IMPORTANT: When piping curl output to jq or other commands, environment variables like $MATON_API_KEY may not expand correctly in some shell environments. You may get "Invalid API key" errors when piping.
  • Error Handling

    | Status | Meaning | |--------|---------| | 400 | Missing Google Ads connection | | 401 | Invalid or missing Maton API key | | 429 | Rate limited (10 req/sec per account) | | 4xx/5xx | Passthrough error from Google Ads API |

    Troubleshooting: API Key Issues

    1. Check that the MATON_API_KEY environment variable is set:

    echo $MATON_API_KEY
    

    2. Verify the API key is valid by listing connections:

    python <<'EOF'
    import urllib.request, os, json
    req = urllib.request.Request('https://api.maton.ai/connections')
    req.add_header('Authorization', f'Bearer {os.environ["MATON_API_KEY"]}')
    print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))
    EOF
    

    Troubleshooting: Invalid App Name

    1. Ensure your URL path starts with google-ads. For example:

  • Correct: https://api.maton.ai/google-ads/v23/customers:listAccessibleCustomers
  • Incorrect: https://api.maton.ai/v23/customers:listAccessibleCustomers
  • Resources

  • Google Ads API Overview
  • GAQL Reference
  • Metrics Reference
  • Search
  • Maton Community
  • Maton Support
  • πŸ’‘ Examples

    # List accessible customers
    python <<'EOF'
    import urllib.request, os, json
    req = urllib.request.Request('https://api.maton.ai/google-ads/v23/customers:listAccessibleCustomers')
    req.add_header('Authorization', f'Bearer {os.environ["MATON_API_KEY"]}')
    print(json.dumps(json.load(urllib.request.urlopen(req)), indent=2))
    EOF
    

    πŸ“‹ Tips & Best Practices

  • Use listAccessibleCustomers first to get customer IDs
  • Customer IDs are 10-digit numbers (remove dashes)
  • Monetary values are in micros (divide by 1,000,000)
  • Date ranges: LAST_7_DAYS, LAST_30_DAYS, THIS_MONTH
  • Status values: ENABLED, PAUSED, REMOVED
  • IMPORTANT: When using curl commands, use curl -g when URLs contain brackets (fields[], sort[], records[]) to disable glob parsing
  • IMPORTANT: When piping curl output to jq or other commands, environment variables like $MATON_API_KEY may not expand correctly in some shell environments. You may get "Invalid API key" errors when piping.