How to Use the Google Sheets MCP in OpenAI Agents SDK

Q: How do I append new rows in Google Sheets using the OpenAI Agents SDK?

Your OpenAI Agents SDK agent invokes appendsheetvalues with the target Google Sheets ID and the row data array. The server finds the first empty row in the sheet and inserts the OpenAI data without overwriting cells.

Run OpenAI Agents SDK pipelines that write directly to your Google Sheets without leaving your Python runtime.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Google Sheets MCP to OpenAI Agents SDK

Create your Vinkius account to connect Google Sheets to OpenAI Agents SDK and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Google Sheets with OpenAI Agents SDK

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Run structured updates via OpenAI Agents SDK

The `update_sheet_values` tool lets your OpenAI Agents SDK agent write clean, tabular data directly to specified cell ranges during autonomous execution runs. This tool ensures that your OpenAI Agents SDK agent validates the target cells before pushing updates, preventing raw OpenAI payload dumps from corrupting your existing Google Sheets layouts. By using `get_sheet_values` alongside this tool, your OpenAI Agents SDK agent reads existing Google Sheets cell coordinates first to confirm your OpenAI agent isn't overwriting critical formulas. You get predictable, step-by-step Google Sheets modifications via this OpenAI Agents SDK MCP integration.

Batch spreadsheet modifications in a single agent run

The `batch_update_spreadsheet` tool applies multiple structural or formatting changes to your Google Sheets document in a single API call initiated by your OpenAI Agents SDK agent. This mechanism prevents your OpenAI Agents SDK agent from hitting Google's strict rate limits by grouping Google Sheets operations like sheet creation and formatting together. Your OpenAI Agents SDK agent uses `create_spreadsheet` to spin up a new Google Sheets document and immediately runs this batch tool to format the headers. Because the OpenAI Agents SDK handles agent handoffs, one specialized OpenAI agent can build the Google Sheets structure while another populates the rows using `append_sheet_values`.

Clean up and manage sheets dynamically

The `clear_sheet_values` tool wipes specific cell ranges clean when your OpenAI Agents SDK agent needs to reset a Google Sheets working space for fresh import runs. It targets only the Google Sheets coordinates your OpenAI Agents SDK agent specifies, leaving surrounding formulas completely untouched. When your OpenAI Agents SDK agent finishes processing, it uses `delete_sheet` to remove temporary Google Sheets tabs that are no longer needed. This keeps your Google Sheets files organized, ensuring that only validated OpenAI Agents SDK data remains in the final document.

Setup guide

Set up Google Sheets MCP in OpenAI Agents SDK

Prerequisites

Python 3.10+ installed
openai-agents package (pip install openai-agents)
Active Vinkius subscription with a valid endpoint token

1

Install the SDK

Run pip install openai-agents to install the OpenAI Agents SDK. The MCP integration is built-in — no extra dependencies needed.
2

Connect via SSE transport

Use MCPServerSse with your Vinkius endpoint URL. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com. The SDK auto-discovers all Google Sheets tools at runtime.
3

Create your Agent

Pass the MCP to Agent(mcp_servers=[server]). The agent receives Google Sheets tools as native definitions — JSON schemas resolve automatically.
4

Run the agent

Call Runner.run(agent, prompt) to execute. The agent invokes the appropriate Google Sheets tools and returns structured results. Copy the full example on the right to get started.

agent.py

import asyncio
from agents import Agent, Runner
from agents.mcp import MCPServerSse

async def main():
    async with MCPServerSse(
        url="https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    ) as server:
        agent = Agent(
            name="Google Sheets Agent",
            instructions="You have access to Google Sheets tools.",
            mcp_servers=[server],
        )
        result = await Runner.run(agent, "List recent transactions")
        print(result.final_output)

asyncio.run(main())

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Google Sheets. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Google Sheets now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Google Sheets MCP in OpenAI Agents SDK

You pass your Vinkius HTTP endpoint token into the OpenAI Agents SDK streamable parameters. The underlying MCP Server handles the actual Google Sheets OAuth2 credentials, meaning your Python agent code never exposes raw Google API keys.

Yes, you control this by configuring the tool filter list when initializing your OpenAI Agents SDK agent. If you only want your OpenAI agent to read data, you can expose `get_sheet_values` and block Google Sheets write operations like `clear_sheet_values` entirely.

The MCP Server returns a Google Sheets rate limit error code that your OpenAI Agents SDK agent intercepts. You can configure your OpenAI agent to retry the request or switch to `batch_get_values` to fetch multiple Google Sheets ranges in one go.

Your OpenAI Agents SDK agent invokes `append_sheet_values` with the target Google Sheets ID and the row data array. The server finds the first empty row in the sheet and inserts the OpenAI data without overwriting cells.

Your Google Sheets cell values and spreadsheet metadata are processed inside an ephemeral, zero-trust V8 sandbox. Vinkius never stores your sheet contents, and all data transfers between your OpenAI Agents SDK agent and Google are encrypted in transit.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript