How to integrate Google Analytics MCP with OpenAI Agents SDK

Connect OpenAI Agents SDK to Google Analytics MCP. Show all google analytics accounts i manage, get detailed info for a specific account, and more using natural language, with authentication handled for you.

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.

82 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 run standard and realtime reports, build funnel and pivot reports, manage audiences, create custom dimensions and metrics, and review properties 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.

For exact tool slugs and parameter tables, see the tool catalog in the Composio docs.

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

Runs multiple analytics data reports for one GA4 property in a single request.

Check Compatibility

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

Create Audience

Create an Analytics audience from explicit membership filter clauses.

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 Channel Group

Create a custom GA4 channel group with ordered traffic grouping rules.

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 Data Stream

Create a web, Android, or iOS data stream under a GA4 property.

Create Event Create Rule

Create a rule that emits a destination event when source-event conditions match.

Create Expanded Data Set

Create an expanded data set for a Google Analytics 360 property using specified dimensions and metrics.

Create Key Event

Create a key event definition for a Google Analytics property.

Create Property

Create an ordinary GA4 property under an Analytics account.

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.

Delete Key Event

Permanently delete a deletable key event from a Google Analytics 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 Redaction Settings

Retrieve client-side data redaction settings for a GA4 web data stream.

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 Data Stream

Retrieve one Google Analytics data stream by its resource name.

Get Global Site Tag

Retrieve the immutable installation snippet for a GA4 web data stream.

Get Google Signals Settings

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

Get Key Event

Retrieve a Key Event by its resource name.

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 Access Bindings

List principals and roles granted on an Analytics account or property.

List Account Summaries

Tool to retrieve summaries of all Google Analytics accounts accessible by the caller.

List Accounts (v1beta)

List Google Analytics accounts accessible to the caller using the v1beta API.

List AdSense Links

Lists a page of AdSense links for a Google Analytics 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

List audience configurations for a Google Analytics property; audiences created before 2020 may not be supported.

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

Lists deprecated conversion event resources configured for a Google Analytics 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 Event Edit Rules

List event edit rules configured on a GA4 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

List key event definitions for a Google Analytics property.

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

List a page of recurring audience lists for a GA4 property, with a continuation token when more results are available.

List Reporting Data Annotations

List a page of Reporting Data Annotations for a specific GA4 property, optionally filtering the results.

List Report Tasks

List a page of report tasks for a Google Analytics property, including task definitions and execution status.

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

List a page of subproperty event filters on a property, including filters that route events to subproperties.

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

Run a customized GA4 event-data report for a property using dimensions, metrics, filters and date ranges or a cohort specification.

Send Events

Send GA4 web-stream events using the Measurement Protocol and an API secret.

Delete Property

Move a Google Analytics property to the Trash Can and return its deletion state.

Update Data Retention Settings

Update selected data retention settings for a Google Analytics property.

Update Data Stream

Update a stream's display name, web default URI, or both.

Update Property

Tool to update an existing GA4 Property.

Validate Events

Validate Measurement Protocol events for a web stream before sending them to production, checking event structure and parameters.

FAQ

Frequently asked questions

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