How to integrate Google Analytics MCP with OpenAI Agents SDK

Trusted by
AWS
Glean
Zoom
Airtable
GET STARTED FOR FREEGET A DEMO

30 min · no commitment · see it on your stack

Google Analytics logo
OpenAI Agents SDK logo
divider

Introduction

This guide walks you through connecting Google Analytics to the OpenAI Agents SDK using the Composio tool router. By the end, you'll have a working Google Analytics agent that can show all google analytics accounts i manage, get detailed info for a specific account, list audiences for your ga4 property through natural language commands.

This guide will help you understand how to give your OpenAI Agents SDK agent real control over a Google Analytics account through Composio's Google Analytics MCP server.

Before we dive in, let's take a quick look at the key ideas and tools involved.

Also integrate Google Analytics with

TL;DR

Here's what you'll learn:
  • Get and set up your OpenAI and Composio API keys
  • Install the necessary dependencies
  • Initialize Composio and create a Tool Router session for Google Analytics
  • Configure an AI agent that can use Google Analytics as a tool
  • Run a live chat session where you can ask the agent to perform Google Analytics operations

What is OpenAI Agents SDK?

The OpenAI Agents SDK is a lightweight framework for building AI agents that can use tools and maintain conversation state. It provides a simple interface for creating agents with hosted MCP tool support.

Key features include:

  • Hosted MCP Tools: Connect to external services through hosted MCP endpoints
  • SQLite Sessions: Persist conversation history across interactions
  • Simple API: Clean interface with Agent, Runner, and tool configuration
  • Streaming Support: Real-time response streaming for interactive applications

What is the Google Analytics MCP server, and what's possible with it?

The Google Analytics MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Google Analytics account. It provides structured and secure access to your analytics data, enabling your agent to analyze traffic, retrieve account info, list audiences, and build custom datasets on your behalf.

  • View and manage analytics accounts: Let your agent retrieve detailed information about specific Google Analytics accounts or list all accounts you have access to.
  • Audience insights and segmentation: Easily have your agent list all audiences associated with a GA4 property, helping you understand and segment your visitors.
  • Create custom expanded datasets: Direct your agent to combine key dimensions and metrics into tailored datasets for deeper analysis and reporting.
  • Efficient property and resource discovery: Have your agent confirm the existence of properties and fetch their details, streamlining your analytics management workflow.

Supported Tools & Triggers

Tools
Archive Custom DimensionTool to archive a CustomDimension on a property.
Batch Run Pivot ReportsTool to return multiple pivot reports in a batch for a GA4 property.
Batch Run ReportsTool to return multiple analytics data reports in a batch.
Check CompatibilityTool to list dimensions and metrics compatible with a GA4 report request.
Create Audience ExportTool to create an audience export for Google Analytics.
Create Audience ListTool to create an audience list for later retrieval by initiating a long-running asynchronous request.
Create Custom DimensionTool to create a CustomDimension for a Google Analytics property.
Create Custom MetricTool to create a custom metric in Google Analytics.
Create Expanded Data SetTool to create an expanded data set for a property.
Create Recurring Audience ListTool to create a recurring audience list that automatically generates new audience lists daily based on the latest data.
Create Report TaskTool to create a report task as a long-running asynchronous request for customized Google Analytics event data reports.
Create Rollup PropertyTool to create a roll-up property.
Get AccountTool to retrieve a single Account by its resource name.
Get Attribution SettingsTool to retrieve attribution configuration for a Google Analytics property.
Get AudienceTool to retrieve a single Audience configuration from a Google Analytics property.
Get Audience ExportTool to get configuration metadata about a specific audience export.
Get Audience ListTool to get configuration metadata about a specific audience list.
Get Custom DimensionTool to retrieve a single CustomDimension by its resource name.
Get Data Retention SettingsTool to retrieve data retention configuration for a Google Analytics property.
Get Data Sharing SettingsTool to retrieve data sharing configuration for a Google Analytics account.
Get Google Signals SettingsTool to retrieve Google Signals configuration settings for a GA4 property.
Get Key EventTool to retrieve a Key Event.
Get MetadataTool to get metadata for dimensions, metrics, and comparisons for a GA4 property.
Get PropertyTool to retrieve a single GA4 Property by its resource name.
Get Property Quotas SnapshotTool to retrieve all property quotas organized by category (corePropertyQuota, funnelPropertyQuota, realtimePropertyQuota) for a given GA4 property.
Get Recurring Audience ListTool to get configuration metadata about a specific recurring audience list.
Get Report TaskTool to get report metadata about a specific report task.
List Account SummariesTool to retrieve summaries of all Google Analytics accounts accessible by the caller.
List Accounts (v1beta)Tool to list all Google Analytics accounts accessible by the caller using v1beta API.
List AdSense LinksTool to list all AdSenseLinks on a property.
List Audience ExportsTool to list all audience exports for a property.
List Audience ListsTool to list all audience lists for a specified property to help find and reuse existing lists.
List AudiencesTool to list Audiences on a property.
List BigQuery LinksTool to list BigQuery Links on a property.
List Calculated MetricsList Calculated Metrics
List Channel GroupsTool to list ChannelGroups on a property.
List Conversion EventsTool to list conversion events on a property.
List Custom DimensionsList Custom Dimensions
List Custom MetricsTool to list CustomMetrics on a property.
List DataStreamsTool to list DataStreams on a property.
List Display & Video 360 Advertiser LinksTool to list Display & Video 360 advertiser links on a property.
List DisplayVideo360 Advertiser Link ProposalsTool to list DisplayVideo360AdvertiserLinkProposals on a property.
List Event Create RulesTool to list EventCreateRules configured on a web data stream.
List Expanded Data SetsTool to list ExpandedDataSets on a property.
List Firebase LinksTool to list FirebaseLinks on a property.
List Google Ads LinksTool to list GoogleAdsLinks on a property.
List Key EventsTool to list Key Events.
List Measurement Protocol SecretsTool to list MeasurementProtocolSecrets under a data stream.
List PropertyTool to list GA4 properties based on filter criteria.
List Recurring Audience ListsTool to list all recurring audience lists for a GA4 property.
List Reporting Data AnnotationsTool to list all Reporting Data Annotations for a specific property.
List Report TasksTool to list all report tasks for a Google Analytics property.
List Search Ads 360 LinksTool to list all SearchAds360Links on a property.
List SKAdNetwork Conversion Value SchemasTool to list SKAdNetworkConversionValueSchema configurations for an iOS data stream.
List Subproperty Event FiltersTool to list all subproperty event filters on a property.
List Subproperty Sync ConfigsTool to list SubpropertySyncConfig resources for managing subproperty synchronization configurations.
Provision Account TicketTool to request a ticket for creating a Google Analytics account.
Query Audience ExportTool to query a completed audience export.
Query Audience ListTool to query an audience list.
Query Report TaskTool to retrieve a report task's content.
Run Funnel ReportTool to run a GA4 funnel report.
Run Pivot ReportTool to run a customized pivot report of Google Analytics event data.
Run Realtime ReportTool to run a customized realtime report of Google Analytics event data.
Run ReportTool to run a customized GA4 data report.
Send EventsTool to send event data to Google Analytics 4 using the Measurement Protocol.
Update PropertyTool to update an existing GA4 Property.
Validate EventsTool to validate Measurement Protocol events before sending them to production.

What is the Composio tool router, and how does it fit here?

What is Composio SDK?

Composio's Composio SDK helps agents find the right tools for a task at runtime. You can plug in multiple toolkits (like Gmail, HubSpot, and GitHub), and the agent will identify the relevant app and action to complete multi-step workflows. This can reduce token usage and improve the reliability of tool calls. Read more here: Getting started with Composio SDK

The tool router generates a secure MCP URL that your agents can access to perform actions.

How the Composio SDK works

The Composio SDK follows a three-phase workflow:

  1. Discovery: Searches for tools matching your task and returns relevant toolkits with their details.
  2. Authentication: Checks for active connections. If missing, creates an auth config and returns a connection URL via Auth Link.
  3. Execution: Executes the action using the authenticated connection.

Step-by-step Guide

Prerequisites

Before starting, make sure you have:
  • Composio API Key and OpenAI API Key
  • Primary know-how of OpenAI Agents SDK
  • A live Google Analytics project
  • Some knowledge of Python or Typescript

Getting API Keys for OpenAI and Composio

OpenAI API Key
  • Go to the OpenAI dashboard and create an API key. You'll need credits to use the models, or you can connect to another model provider.
  • Keep the API key safe.
Composio API Key

Install dependencies

pip install composio_openai_agents openai-agents python-dotenv

Install the Composio SDK and the OpenAI Agents SDK.

Set up environment variables

bash
OPENAI_API_KEY=sk-...your-api-key
COMPOSIO_API_KEY=your-api-key
USER_ID=composio_user@gmail.com

Create a .env file and add your OpenAI and Composio API keys.

Import dependencies

import asyncio
import os
from dotenv import load_dotenv

from composio import Composio
from composio_openai_agents import OpenAIAgentsProvider
from agents import Agent, Runner, HostedMCPTool, SQLiteSession
What's happening:
  • You're importing all necessary libraries.
  • The Composio and OpenAIAgentsProvider classes are imported to connect your OpenAI agent to Composio tools like Google Analytics.

Set up the Composio instance

load_dotenv()

api_key = os.getenv("COMPOSIO_API_KEY")
user_id = os.getenv("USER_ID")

if not api_key:
    raise RuntimeError("COMPOSIO_API_KEY is not set. Create a .env file with COMPOSIO_API_KEY=your_key")

# Initialize Composio
composio = Composio(api_key=api_key, provider=OpenAIAgentsProvider())
What's happening:
  • load_dotenv() loads your .env file so OPENAI_API_KEY and COMPOSIO_API_KEY are available as environment variables.
  • Creating a Composio instance using the API Key and OpenAIAgentsProvider class.

Create a Tool Router session

# Create a Google Analytics Tool Router session
session = composio.create(
    user_id=user_id,
    toolkits=["google_analytics"]
)

mcp_url = session.mcp.url

What is happening:

  • You give the Tool Router the user id and the toolkits you want available. Here, it is only google_analytics.
  • The router checks the user's Google Analytics connection and prepares the MCP endpoint.
  • The returned session.mcp.url is the MCP URL that your agent will use to access Google Analytics.
  • This approach keeps things lightweight and lets the agent request Google Analytics tools only when needed during the conversation.

Configure the agent

# Configure agent with MCP tool
agent = Agent(
    name="Assistant",
    model="gpt-5",
    instructions=(
        "You are a helpful assistant that can access Google Analytics. "
        "Help users perform Google Analytics operations through natural language."
    ),
    tools=[
        HostedMCPTool(
            tool_config={
                "type": "mcp",
                "server_label": "tool_router",
                "server_url": mcp_url,
                "headers": {"x-api-key": api_key},
                "require_approval": "never",
            }
        )
    ],
)
What's happening:
  • We're creating an Agent instance with a name, model (gpt-5), and clear instructions about its purpose.
  • The agent's instructions tell it that it can access Google Analytics and help with queries, inserts, updates, authentication, and fetching database information.
  • The tools array includes a HostedMCPTool that connects to the MCP server URL we created earlier.
  • The headers dict includes the Composio API key for secure authentication with the MCP server.
  • require_approval: 'never' means the agent can execute Google Analytics operations without asking for permission each time, making interactions smoother.

Start chat loop and handle conversation

print("\nComposio Tool Router session created.")

chat_session = SQLiteSession("conversation_openai_toolrouter")

print("\nChat started. Type your requests below.")
print("Commands: 'exit', 'quit', or 'q' to end\n")

async def main():
    try:
        result = await Runner.run(
            agent,
            "What can you help me with?",
            session=chat_session
        )
        print(f"Assistant: {result.final_output}\n")
    except Exception as e:
        print(f"Error: {e}\n")

    while True:
        user_input = input("You: ").strip()
        if user_input.lower() in {"exit", "quit", "q"}:
            print("Goodbye!")
            break

        result = await Runner.run(
            agent,
            user_input,
            session=chat_session
        )
        print(f"Assistant: {result.final_output}\n")

asyncio.run(main())
What's happening:
  • The program prints a session URL that you visit to authorize Google Analytics.
  • After authorization, the chat begins.
  • Each message you type is processed by the agent using Runner.run().
  • The responses are printed to the console, and conversations are saved locally using SQLite.
  • Typing exit, quit, or q cleanly ends the chat.

Complete Code

Here's the complete code to get you started with Google Analytics and OpenAI Agents SDK:

import asyncio
import os
from dotenv import load_dotenv

from composio import Composio
from composio_openai_agents import OpenAIAgentsProvider
from agents import Agent, Runner, HostedMCPTool, SQLiteSession

load_dotenv()

api_key = os.getenv("COMPOSIO_API_KEY")
user_id = os.getenv("USER_ID")

if not api_key:
    raise RuntimeError("COMPOSIO_API_KEY is not set. Create a .env file with COMPOSIO_API_KEY=your_key")

# Initialize Composio
composio = Composio(api_key=api_key, provider=OpenAIAgentsProvider())

# Create Tool Router session
session = composio.create(
    user_id=user_id,
    toolkits=["google_analytics"]
)
mcp_url = session.mcp.url

# Configure agent with MCP tool
agent = Agent(
    name="Assistant",
    model="gpt-5",
    instructions=(
        "You are a helpful assistant that can access Google Analytics. "
        "Help users perform Google Analytics operations through natural language."
    ),
    tools=[
        HostedMCPTool(
            tool_config={
                "type": "mcp",
                "server_label": "tool_router",
                "server_url": mcp_url,
                "headers": {"x-api-key": api_key},
                "require_approval": "never",
            }
        )
    ],
)

print("\nComposio Tool Router session created.")

chat_session = SQLiteSession("conversation_openai_toolrouter")

print("\nChat started. Type your requests below.")
print("Commands: 'exit', 'quit', or 'q' to end\n")

async def main():
    try:
        result = await Runner.run(
            agent,
            "What can you help me with?",
            session=chat_session
        )
        print(f"Assistant: {result.final_output}\n")
    except Exception as e:
        print(f"Error: {e}\n")

    while True:
        user_input = input("You: ").strip()
        if user_input.lower() in {"exit", "quit", "q"}:
            print("Goodbye!")
            break

        result = await Runner.run(
            agent,
            user_input,
            session=chat_session
        )
        print(f"Assistant: {result.final_output}\n")

asyncio.run(main())

Conclusion

This was a starter code for integrating Google Analytics MCP with OpenAI Agents SDK to build a functional AI agent that can interact with Google Analytics.

Key features:

  • Hosted MCP tool integration through Composio's Tool Router
  • SQLite session persistence for conversation history
  • Simple async chat loop for interactive testing
You can extend this by adding more toolkits, implementing custom business logic, or building a web interface around the agent.

How to build Google Analytics MCP Agent with another framework

ChatGPT logo

ChatGPT

Use Google Analytics MCP with ChatGPT

Antigravity logo

Antigravity

Use Google Analytics MCP with Antigravity

Claude Agent SDK logo

Claude Agent SDK

Use Google Analytics MCP with Claude Agent SDK

Claude Code logo

Claude Code

Use Google Analytics MCP with Claude Code

Claude Cowork logo

Claude Cowork

Use Google Analytics MCP with Claude Cowork

Codex logo

Codex

Use Google Analytics MCP with Codex

Cursor logo

Cursor

Use Google Analytics MCP with Cursor

OpenClaw logo

OpenClaw

Use Google Analytics MCP with OpenClaw

Hermes logo

Hermes

Use Google Analytics MCP with Hermes

CLI logo

CLI

Use Google Analytics MCP with CLI

Google ADK logo

Google ADK

Use Google Analytics MCP with Google ADK

LangChain logo

LangChain

Use Google Analytics MCP with LangChain

Vercel AI SDK logo

Vercel AI SDK

Use Google Analytics MCP with Vercel AI SDK

Mastra AI logo

Mastra AI

Use Google Analytics MCP with Mastra AI

LlamaIndex logo

LlamaIndex

Use Google Analytics MCP with LlamaIndex

CrewAI logo

CrewAI

Use Google Analytics MCP with CrewAI

OpenCode logo

OpenCode

Use Google Analytics MCP with OpenCode

VS Code logo

VS Code

Use Google Analytics MCP with VS Code

FAQ

What are the differences in Tool Router MCP and Google Analytics MCP?

With a standalone Google Analytics MCP server, the agents and LLMs can only access a fixed set of Google Analytics tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Google Analytics and many other apps based on the task at hand, all through a single MCP endpoint.

Can I use Tool Router MCP with OpenAI Agents SDK?

Yes, you can. OpenAI Agents SDK fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Google Analytics tools.

Can I manage the permissions and scopes for Google Analytics while using Tool Router?

Yes, absolutely. You can configure which Google Analytics scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do.

How safe is my data with Composio Tool Router?

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Google Analytics data and credentials are handled as safely as possible.

Used by agents from

Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai
Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai
Context
Letta
glean
HubSpot
Agent.ai
Altera
DataStax
Entelligence
Rolai

Never worry about agent reliability

We handle tool reliability, observability, and security so you never have to second-guess an agent action.

Get started for freeGet a demo↗