# Google Data Studio

```json
{
  "name": "Google Data Studio",
  "slug": "google_data_studio",
  "url": "https://composio.dev/toolkits/google_data_studio",
  "markdown_url": "https://composio.dev/toolkits/google_data_studio.md",
  "logo_url": "https://logos.composio.dev/api/google_data_studio",
  "categories": [
    "data & analytics"
  ],
  "is_composio_managed": false,
  "updated_at": "2026-08-09T06:42:23.473Z"
}
```

![Google Data Studio logo](https://logos.composio.dev/api/google_data_studio)

## Description

Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Google Data Studio MCP or direct API to search report assets, inspect ownership, manage sharing permissions, and audit dashboard access through natural language.

## Summary

Google Data Studio is Google's business intelligence platform for building dashboards and reports.
Use it to turn data into shareable insights across teams and organizations.

## Categories

- data & analytics

## Toolkit Details

- Tools: 5

## Images

- Logo: https://logos.composio.dev/api/google_data_studio

## Authentication

- **Oauth2**
  - Type: `oauth2`
  - Description: Oauth2 authentication for Google Data Studio.
  - Setup:
    - Configure Oauth2 credentials for Google Data Studio.
    - Use the credentials when creating an auth config in Composio.

## Suggested Prompts

- Find shared marketing reports in organization
- List dashboards owned by analytics team
- Audit permissions for finance reports

## Supported Tools

| Tool slug | Name | Description |
|---|---|---|
| `GOOGLE_DATA_STUDIO_ADD_MEMBERS_TO_ASSET_ROLE` | Add Members to Asset Role | Ensure one or more members belong to a mutable asset role and verify each requested membership after the write. |
| `GOOGLE_DATA_STUDIO_GET_ASSET_PERMISSIONS` | Get Asset Permissions | Get every populated permission role and the current concurrency etag for one Google Data Studio asset. |
| `GOOGLE_DATA_STUDIO_REPLACE_ASSET_PERMISSIONS` | Replace Asset Permissions | Replace all four mutable permission-role memberships for a Google Data Studio asset, preserving owners and rejecting stale etags. Every mutable role is required; pass an empty list to clear that role. |
| `GOOGLE_DATA_STUDIO_REVOKE_ASSET_MEMBER_PERMISSIONS` | Revoke Asset Member Permissions | Remove one or more members from every removable role on a Google Data Studio asset and verify whether each was removed or already absent. |
| `GOOGLE_DATA_STUDIO_SEARCH_ASSETS` | Search Assets | Search accessible Google Data Studio reports or data sources and return one page of asset metadata. |

## Supported Triggers

None listed.

## Installation and MCP Setup

### Path 1: SDK Installation

#### Path 1, Step 1: Install Composio

Install the Composio SDK
```python
pip install composio_openai
```

```typescript
npm install @composio/openai
```

#### Path 1, Step 2: Initialize Composio and Create Tool Router Session

Import and initialize Composio client, then create a Tool Router session
```python
from openai import OpenAI
from composio import Composio
from composio_openai import OpenAIResponsesProvider

composio = Composio(provider=OpenAIResponsesProvider())
openai = OpenAI()
session = composio.create(user_id='your-user-id')
```

```typescript
import OpenAI from 'openai';
import { Composio } from '@composio/core';
import { OpenAIResponsesProvider } from '@composio/openai';

const composio = new Composio({
  provider: new OpenAIResponsesProvider(),
});
const openai = new OpenAI({});
const session = await composio.create('your-user-id');
```

#### Path 1, Step 3: Execute Google Data Studio Tools via Tool Router with Your Agent

Get tools from Tool Router session and execute Google Data Studio actions with your Agent
```python
tools = session.tools
response = openai.responses.create(
  model='gpt-4.1',
  tools=tools,
  input=[{
    'role': 'user',
    'content': 'Find all Google Data Studio reports shared with my organization and summarize their owners and permissions'
  }]
)
result = composio.provider.handle_tool_calls(
  response=response,
  user_id='your-user-id'
)
print(result)
```

```typescript
const tools = session.tools;
const response = await openai.responses.create({
  model: 'gpt-4.1',
  tools: tools,
  input: [{
    role: 'user',
    content: 'Find all Google Data Studio reports shared with my organization and summarize their owners and permissions'
  }],
});
const result = await composio.provider.handleToolCalls(
  'your-user-id',
  response.output
);
console.log(result);
```

### Path 2: MCP Server Setup

#### Path 2, Step 1: Install Composio

Install the Composio SDK for Python or TypeScript
```python
pip install composio claude-agent-sdk
```

```typescript
npm install @composio/core ai @ai-sdk/openai @ai-sdk/mcp
```

#### Path 2, Step 2: Initialize Client and Create Tool Router Session

Import and initialize the Composio client, then create a Tool Router session for Google Data Studio
```python
from composio import Composio
from claude_agent_sdk import ClaudeSDKClient, ClaudeAgentOptions

composio = Composio(api_key='your-composio-api-key')
session = composio.create(user_id='your-user-id')
url = session.mcp.url
```

```typescript
import { Composio } from '@composio/core';

const composio = new Composio({ apiKey: 'your-api-key' });
const session = await composio.create('your-user-id');
console.log(`Tool Router session created: ${session.mcp.url}`);
```

#### Path 2, Step 3: Connect to AI Agent

Use the MCP server with your AI agent (Anthropic Claude or Mastra)
```python
import asyncio

options = ClaudeAgentOptions(
    permission_mode='bypassPermissions',
    mcp_servers={
        'tool_router': {
            'type': 'http',
            'url': url,
            'headers': {
                'x-api-key': 'your-composio-api-key'
            }
        }
    },
    system_prompt='You are a helpful assistant with access to Google Data Studio tools.',
    max_turns=10
)

async def main():
    async with ClaudeSDKClient(options=options) as client:
        await client.query('Audit sharing permissions for all finance dashboards in Google Data Studio')
        async for message in client.receive_response():
            if hasattr(message, 'content'):
                for block in message.content:
                    if hasattr(block, 'text'):
                        print(block.text)

asyncio.run(main())
```

```typescript
import { openai } from '@ai-sdk/openai';
import { experimental_createMCPClient as createMCPClient } from '@ai-sdk/mcp';
import { generateText } from 'ai';

const client = await createMCPClient({
  transport: {
    type: 'http',
    url: session.mcp.url,
    headers: {
      'x-api-key': 'your-composio-api-key',
    },
  },
});

const tools = await client.tools();
const { text } = await generateText({
  model: openai('gpt-4o'),
  tools,
  messages: [{
    role: 'user',
    content: 'Audit sharing permissions for all finance dashboards in Google Data Studio'
  }],
  maxSteps: 5,
});

console.log(`Agent: ${text}`);
```

## Why Use Composio?

### 1. AI Native Google Data Studio Integration

- Supports both Google Data Studio MCP and direct API based integrations
- Structured, LLM-friendly schemas for reliable Asset API execution
- Rich coverage for searching reports, finding dashboards, and managing sharing permissions

### 2. Managed Auth

- Built-in OAuth handling with automatic token refresh and lifecycle management
- Central place to manage, scope, and revoke Google Data Studio access
- Per user and per environment credentials instead of hard-coded OAuth tokens

### 3. Agent Optimized Design

- Tools are tuned for real agent workflows like asset lookup, access review, and report discovery
- Comprehensive execution logs so you always know what ran, when, and on whose behalf

### 4. Enterprise Grade Security

- Fine-grained RBAC so you control which agents and users can access Google Data Studio
- Scoped, least privilege access to Google Data Studio assets and permissions
- Full audit trail of agent actions to support security reviews and compliance

## Use Google Data Studio with any AI Agent Framework

Choose a framework you want to connect Google Data Studio with:

- [ChatGPT Work](https://composio.dev/toolkits/google_data_studio/framework/chatgpt)
- [Claude Cowork](https://composio.dev/toolkits/google_data_studio/framework/claude-cowork)

## Related Toolkits

- [Excel](https://composio.dev/toolkits/excel) - Microsoft Excel is a robust spreadsheet application for organizing, analyzing, and visualizing data. It's the go-to tool for calculations, reporting, and flexible data management.
- [21risk](https://composio.dev/toolkits/_21risk) - 21RISK is a web app built for easy checklist, audit, and compliance management. It streamlines risk processes so teams can focus on what matters.
- [Abstract](https://composio.dev/toolkits/abstract) - Abstract provides a suite of APIs for automating data validation and enrichment tasks. It helps developers streamline workflows and ensure data quality with minimal effort.
- [Addressfinder](https://composio.dev/toolkits/addressfinder) - Addressfinder is a data quality platform for verifying addresses, emails, and phone numbers. It helps you ensure accurate customer and contact data every time.
- [Agentql](https://composio.dev/toolkits/agentql) - Agentql is a toolkit that connects AI agents to the web using a specialized query language. It enables structured web interaction and data extraction for smarter automations.
- [Agenty](https://composio.dev/toolkits/agenty) - Agenty is a web scraping and automation platform for extracting data and automating browser tasks—no coding needed. It streamlines data collection, monitoring, and repetitive online actions.
- [Ambee](https://composio.dev/toolkits/ambee) - Ambee is an environmental data platform providing real-time, hyperlocal APIs for air quality, weather, and pollen. Get precise environmental insights to power smarter decisions in your apps and workflows.
- [Ambient weather](https://composio.dev/toolkits/ambient_weather) - Ambient Weather is a platform for personal weather stations with a robust API for accessing local, real-time, and historical weather data. Get detailed environmental insights directly from your own sensors for smarter apps and automations.
- [Anonyflow](https://composio.dev/toolkits/anonyflow) - Anonyflow is a service for encryption-based data anonymization and secure data sharing. It helps organizations meet GDPR, CCPA, and HIPAA data privacy compliance requirements.
- [Api ninjas](https://composio.dev/toolkits/api_ninjas) - Api ninjas offers 120+ public APIs spanning categories like weather, finance, sports, and more. Developers use it to supercharge apps with real-time data and actionable endpoints.
- [Api sports](https://composio.dev/toolkits/api_sports) - Api sports is a comprehensive sports data platform covering 2,000+ competitions with live scores and 15+ years of stats. Instantly access up-to-date sports information for analysis, apps, or chatbots.
- [Apify](https://composio.dev/toolkits/apify) - Apify is a cloud platform for building, deploying, and managing web scraping and automation tools called Actors. It lets you automate data extraction and workflow tasks at scale—no infrastructure headaches.
- [Autom](https://composio.dev/toolkits/autom) - Autom is a lightning-fast search engine results data platform for Google, Bing, and Brave. Developers use it to access fresh, low-latency SERP data on demand.
- [Beaconchain](https://composio.dev/toolkits/beaconchain) - Beaconchain is a real-time analytics platform for Ethereum 2.0's Beacon Chain. It provides detailed insights into validators, blocks, and overall network performance.
- [Big data cloud](https://composio.dev/toolkits/big_data_cloud) - BigDataCloud provides APIs for geolocation, reverse geocoding, and address validation. Instantly access reliable location intelligence to enhance your applications and workflows.
- [Bigpicture io](https://composio.dev/toolkits/bigpicture_io) - BigPicture.io offers APIs for accessing detailed company and profile data. Instantly enrich your applications with up-to-date insights on 20M+ businesses.
- [Bitquery](https://composio.dev/toolkits/bitquery) - Bitquery is a blockchain data platform offering indexed, real-time, and historical data from 40+ blockchains via GraphQL APIs. Get unified, reliable access to complex on-chain data for analytics, trading, and research.
- [Brightdata](https://composio.dev/toolkits/brightdata) - Brightdata is a leading web data platform offering advanced scraping, SERP APIs, and anti-bot tools. It lets you collect public web data at scale, bypassing blocks and friction.
- [Builtwith](https://composio.dev/toolkits/builtwith) - BuiltWith is a web technology profiler that uncovers the technologies powering any website. Gain actionable insights into analytics, hosting, and content management stacks for smarter research and lead generation.
- [Byteforms](https://composio.dev/toolkits/byteforms) - Byteforms is an all-in-one platform for creating forms, managing submissions, and integrating data. It streamlines workflows by centralizing form data collection and automation.

## Frequently Asked Questions

### Do I need my own developer credentials to use Google Data Studio with Composio?

Yes, Google Data Studio requires you to configure your own OAuth credentials. Once set up, Composio handles token storage, refresh, and lifecycle management for you. In practice, you can create the auth configuration with auth_configs.create(), connect users with connected_accounts.link(), and expose tools through mcp.create() or a Tool Router session.

### Can I use multiple toolkits together?

Yes! Composio's Tool Router enables agents to use multiple toolkits. [Learn more](https://docs.composio.dev/tool-router/overview).

### Is Composio secure?

Composio is SOC 2 and ISO 27001 compliant with all data encrypted in transit and at rest. [Learn more](https://trust.composio.dev).

### What if the API changes?

Composio maintains and updates all toolkit integrations automatically, so your agents always work with the latest API versions.

---
[See all toolkits](https://composio.dev/toolkits) · [Composio docs](https://docs.composio.dev/llms.txt)
