How to integrate Google Analytics MCP with OpenAI Agents SDK

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.

Google Analytics logoGoogle Analytics
Oauth2

Google Analytics tracks and reports website traffic, user behavior, and conversions. It helps marketers optimize performance and understand customer journeys.

67 Tools

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.

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

Step by step09 STEPS
1

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
2

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
3

Install dependencies

npm install @composio/openai-agents @openai/agents dotenv

Install the Composio SDK and the OpenAI Agents SDK.

4

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.

5

Import dependencies

import 'dotenv/config';
import { Composio } from '@composio/core';
import { OpenAIAgentsProvider } from '@composio/openai-agents';
import { Agent, hostedMcpTool, run, OpenAIConversationsSession } from '@openai/agents';
import * as readline from 'readline';
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.
6

Set up the Composio instance

dotenv.config();

const composioApiKey = process.env.COMPOSIO_API_KEY;
const userId = process.env.USER_ID;

if (!composioApiKey) {
  throw new Error('COMPOSIO_API_KEY is not set. Create a .env file with COMPOSIO_API_KEY=your_key');
}
if (!userId) {
  throw new Error('USER_ID is not set');
}

// Initialize Composio
const composio = new Composio({
  apiKey: composioApiKey,
  provider: new OpenAIAgentsProvider(),
});
What's happening:
  • dotenv.config() loads your .env file so COMPOSIO_API_KEY and USER_ID are available as environment variables.
  • Creating a Composio instance using the API Key and OpenAIAgentsProvider class.
7

Create a Tool Router session

// Create Tool Router session for Google Analytics
const session = await composio.create(userId as string, {
  toolkits: ['google_analytics'],
});
const mcpUrl = 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.
8

Configure the agent

// Configure agent with MCP tool
const agent = new 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({
      serverLabel: 'tool_router',
      serverUrl: mcpUrl,
      headers: { 'x-api-key': composioApiKey },
      requireApproval: '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 object includes the Composio API key for secure authentication with the MCP server.
  • requireApproval: 'never' means the agent can execute Google Analytics operations without asking for permission each time, making interactions smoother.
9

Start chat loop and handle conversation

// Keep conversation state across turns
const conversationSession = new OpenAIConversationsSession();

// Simple CLI
const rl = readline.createInterface({
  input: process.stdin,
  output: process.stdout,
  prompt: 'You: ',
});

console.log('\nComposio Tool Router session created.');
console.log('\nChat started. Type your requests below.');
console.log("Commands: 'exit', 'quit', or 'q' to end\n");

try {
  const first = await run(agent, 'What can you help me with?', { session: conversationSession });
  console.log(`Assistant: ${first.finalOutput}\n`);
} catch (e) {
  console.error('Error:', e instanceof Error ? e.message : e, '\n');
}

rl.prompt();

rl.on('line', async (userInput) => {
  const text = userInput.trim();

  if (['exit', 'quit', 'q'].includes(text.toLowerCase())) {
    console.log('Goodbye!');
    rl.close();
    process.exit(0);
  }

  if (!text) {
    rl.prompt();
    return;
  }

  try {
    const result = await run(agent, text, { session: conversationSession });
    console.log(`\nAssistant: ${result.finalOutput}\n`);
  } catch (e) {
    console.error('Error:', e instanceof Error ? e.message : e, '\n');
  }

  rl.prompt();
});

rl.on('close', () => {
  console.log('\n👋 Session ended.');
  process.exit(0);
});
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 run().
  • The responses are printed to the console.
  • 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 'dotenv/config';
import { Composio } from '@composio/core';
import { OpenAIAgentsProvider } from '@composio/openai-agents';
import { Agent, hostedMcpTool, run, OpenAIConversationsSession } from '@openai/agents';
import * as readline from 'readline';

const composioApiKey = process.env.COMPOSIO_API_KEY;
const userId = process.env.USER_ID;

if (!composioApiKey) {
  throw new Error('COMPOSIO_API_KEY is not set. Create a .env file with COMPOSIO_API_KEY=your_key');
}
if (!userId) {
  throw new Error('USER_ID is not set');
}

// Initialize Composio
const composio = new Composio({
  apiKey: composioApiKey,
  provider: new OpenAIAgentsProvider(),
});

async function main() {
  // Create Tool Router session
  const session = await composio.create(userId as string, {
    toolkits: ['google_analytics'],
  });
  const mcpUrl = session.mcp.url;

  // Configure agent with MCP tool
  const agent = new 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({
        serverLabel: 'tool_router',
        serverUrl: mcpUrl,
        headers: { 'x-api-key': composioApiKey },
        requireApproval: 'never',
      }),
    ],
  });

  // Keep conversation state across turns
  const conversationSession = new OpenAIConversationsSession();

  // Simple CLI
  const rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout,
    prompt: 'You: ',
  });

  console.log('\nComposio Tool Router session created.');
  console.log('\nChat started. Type your requests below.');
  console.log("Commands: 'exit', 'quit', or 'q' to end\n");

  try {
    const first = await run(agent, 'What can you help me with?', { session: conversationSession });
    console.log(`Assistant: ${first.finalOutput}\n`);
  } catch (e) {
    console.error('Error:', e instanceof Error ? e.message : e, '\n');
  }

  rl.prompt();

  rl.on('line', async (userInput) => {
    const text = userInput.trim();

    if (['exit', 'quit', 'q'].includes(text.toLowerCase())) {
      console.log('Goodbye!');
      rl.close();
      process.exit(0);
    }

    if (!text) {
      rl.prompt();
      return;
    }

    try {
      const result = await run(agent, text, { session: conversationSession });
      console.log(`\nAssistant: ${result.finalOutput}\n`);
    } catch (e) {
      console.error('Error:', e instanceof Error ? e.message : e, '\n');
    }

    rl.prompt();
  });

  rl.on('close', () => {
    console.log('\nSession ended.');
    process.exit(0);
  });
}

main().catch((err) => {
  console.error('Fatal error:', err);
  process.exit(1);
});

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.
TOOLS

Supported Tools

Every Google Analytics action and event your agent gets out of the box.

Archive Custom Dimension

Tool to archive a CustomDimension on a property.

Batch Run Pivot Reports

Tool to return multiple pivot reports in a batch for a GA4 property.

Batch Run Reports

Tool to return multiple analytics data reports in a batch.

Check Compatibility

Tool to list dimensions and metrics compatible with a GA4 report request.

Create Audience Export

Tool to create an audience export for Google Analytics.

Create Audience List

Tool to create an audience list for later retrieval by initiating a long-running asynchronous request.

Create Custom Dimension

Tool to create a CustomDimension for a Google Analytics property.

Create Custom Metric

Tool to create a custom metric in Google Analytics.

Create Expanded Data Set

Tool to create an expanded data set for a property.

Create Recurring Audience List

Tool to create a recurring audience list that automatically generates new audience lists daily based on the latest data.

Create Report Task

Tool to create a report task as a long-running asynchronous request for customized Google Analytics event data reports.

Create Rollup Property

Tool to create a roll-up property.

Get Account

Tool to retrieve a single Account by its resource name.

Get Attribution Settings

Tool to retrieve attribution configuration for a Google Analytics property.

Get Audience

Tool to retrieve a single Audience configuration from a Google Analytics property.

Get Audience Export

Tool to get configuration metadata about a specific audience export.

Get Audience List

Tool to get configuration metadata about a specific audience list.

Get Custom Dimension

Tool to retrieve a single CustomDimension by its resource name.

Get Data Retention Settings

Tool to retrieve data retention configuration for a Google Analytics property.

Get Data Sharing Settings

Tool to retrieve data sharing configuration for a Google Analytics account.

Get Google Signals Settings

Tool to retrieve Google Signals configuration settings for a GA4 property.

Get Key Event

Tool to retrieve a Key Event.

Get Metadata

Tool to get metadata for dimensions, metrics, and comparisons for a GA4 property.

Get Property

Tool to retrieve a single GA4 Property by its resource name.

Get Property Quotas Snapshot

Tool to retrieve all property quotas organized by category (corePropertyQuota, funnelPropertyQuota, realtimePropertyQuota) for a given GA4 property.

Get Recurring Audience List

Tool to get configuration metadata about a specific recurring audience list.

Get Report Task

Tool to get report metadata about a specific report task.

List Account Summaries

Tool 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 Links

Tool to list all AdSenseLinks on a property.

List Audience Exports

Tool to list all audience exports for a property.

List Audience Lists

Tool to list all audience lists for a specified property to help find and reuse existing lists.

List Audiences

Tool to list Audiences on a property.

List BigQuery Links

Tool to list BigQuery Links on a property.

List Calculated Metrics

List Calculated Metrics

List Channel Groups

Tool to list ChannelGroups on a property.

List Conversion Events

Tool to list conversion events on a property.

List Custom Dimensions

List Custom Dimensions

List Custom Metrics

Tool to list CustomMetrics on a property.

List DataStreams

Tool to list DataStreams on a property.

List Display & Video 360 Advertiser Links

Tool to list Display & Video 360 advertiser links on a property.

List DisplayVideo360 Advertiser Link Proposals

Tool to list DisplayVideo360AdvertiserLinkProposals on a property.

List Event Create Rules

Tool to list EventCreateRules configured on a web data stream.

List Expanded Data Sets

Tool to list ExpandedDataSets on a property.

List Firebase Links

Tool to list FirebaseLinks on a property.

List Google Ads Links

Tool to list GoogleAdsLinks on a property.

List Key Events

Tool to list Key Events.

List Measurement Protocol Secrets

Tool to list MeasurementProtocolSecrets under a data stream.

List Property

Tool to list GA4 properties based on filter criteria.

List Recurring Audience Lists

Tool to list all recurring audience lists for a GA4 property.

List Reporting Data Annotations

Tool to list all Reporting Data Annotations for a specific property.

List Report Tasks

Tool to list all report tasks for a Google Analytics property.

List Search Ads 360 Links

Tool to list all SearchAds360Links on a property.

List SKAdNetwork Conversion Value Schemas

Tool to list SKAdNetworkConversionValueSchema configurations for an iOS data stream.

List Subproperty Event Filters

Tool to list all subproperty event filters on a property.

List Subproperty Sync Configs

Tool to list SubpropertySyncConfig resources for managing subproperty synchronization configurations.

Provision Account Ticket

Tool to request a ticket for creating a Google Analytics account.

Query Audience Export

Tool to query a completed audience export.

Query Audience List

Tool to query an audience list.

Query Report Task

Tool to retrieve a report task's content.

Run Funnel Report

Tool to run a GA4 funnel report.

Run Pivot Report

Tool to run a customized pivot report of Google Analytics event data.

Run Realtime Report

Tool to run a customized realtime report of Google Analytics event data.

Run Report

Tool to run a customized GA4 data report.

Send Events

Tool to send event data to Google Analytics 4 using the Measurement Protocol.

Update Property

Tool to update an existing GA4 Property.

Validate Events

Tool to validate Measurement Protocol events before sending them to production.

FAQ

Frequently asked questions

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.

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.

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.

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.

Start with Google Analytics.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Google Analytics tool your agent needs.Free to start.

Start building