Google Sheets (OAuth) MCP for AI Agents. Manage, read, and update your spreadsheets through conversation.

Q: How do I get the title and tab names using sheets.info?

The sheets.info tool retrieves detailed metadata about your spreadsheet, including its full title, timezone, locale settings, and a list of every sheet tab within it.

Q: What's the difference between sheets.write and sheets.append?

sheets.write overwrites any existing data in the target range. Use sheets.append if you want to add new rows of information without destroying the historical data at the bottom.

Q: Can I read multiple ranges at once with sheets.batchread?

Yes, that's exactly what sheets.batchread is for. You provide a comma-separated list of A1 notation strings, and the tool retrieves all of them efficiently in one go.

Q: If I want to create a new spreadsheet, which tool do I use?

Use sheets.create. This tool generates a brand-new Google Sheet file for you, providing both the unique ID and an immediate edit link so you can start populating it right away.

Q: How do I read data from a specific cell range?

You use sheets.read. Just remember to format your request using A1 notation, like 'SheetName!A1:D10', and the tool retrieves the values for you.

Google Sheets (OAuth) connects your AI agent directly to Google Sheets data. You can manage entire spreadsheets—creating new files, reading specific data ranges, and updating cells—all through natural conversation. This lets you handle complex reporting, audit project trackers, or manipulate financial models without ever opening the browser UI.

Claude

ChatGPT

Cursor

Gemini

Windsurf

VS Code

JetBrains

Vercel

See Vinkius in Action

Give Claude and any AI agent real-world access

Create New Spreadsheets

Generates a brand-new Google Sheet file with a title you specify.

Read Specific Data Ranges

Retrieves content from exact cell coordinates using A1 notation, making it easy to read data like 'SheetName!A1:D10'.

Batch Read Multiple Ranges

Reads data from several different ranges in a single request, which is faster than reading them one by one.

Overwrite Cell Values

Writes new values to specific cells in an existing range, replacing whatever was there before.

Append New Rows

Adds data as entirely new rows to the bottom of a sheet without touching any previous information.

Clear Cell Content

Wipes out values in a specific range, leaving behind formatting and formulas intact.

Ask an AI about this

Waiting for input…

AI Agent

What AI agents can do with Google Sheets (OAuth) MCP With 7 Tools

Use these seven tools to perform any operation on your Google Sheet data, from reading specific metrics using sheets.read to initializing a whole new document with sheets.create.

Make your AI actually useful.

Add this MCP to Claude, Cursor, or Windsurf and your AI stops guessing. It gets real tools to look things up, take action, and handle the stuff you keep doing by hand.

Start using Google Sheets (OAuth) MCP

Sheets.info

Gets metadata like the spreadsheet title, locale, timezone, and list of all tabs with their dimensions.

Sheets.read

Reads cell values from a specific Google Sheets range using A1 notation (e.g....

Sheets.batch Read

Efficiently reads data from multiple, distinct ranges in one single API call.

Sheets.write

Writes new data to a specific range of cells, overwriting any existing content there.

Sheets.append

Adds a set of values as completely new rows at the bottom of an existing table.

Sheets.clear

Removes cell content in a given range, but it keeps formatting and formulas structure intact.

Sheets.create

Initializes a brand-new Google Sheet file with a title you name.

Security and governance baked right in.

Pick your AI client below to get set up. Just create a Vinkius account, subscribe, and you're instantly up and running. We handle the entire backend infrastructure, delivering out-of-the-box support for HTTPS Streamable, SSE, and OAuth2—zero messy routing required.

Google Sheets (OAuth) MCP is compatible with Claude

Claude AI

Open Claude Settings

Go to claude.ai, click your profile icon, then navigate to Customize → Connectors.

Add Custom Connector

Click the "+" button and select Add custom connector. Paste your Vinkius endpoint URL:

https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp

Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com. For OAuth-protected servers, expand Advanced settings to add credentials.

Start a conversation

Open a new chat. The Google Sheets (OAuth) integration is available immediately — no restart needed.

Antigravity

Configure Agent Environment

Open your Antigravity agent's workspace configuration or mcp-servers.json file.

Bind the Endpoint

Add the Vinkius endpoint URL to your agent's MCP connections list:

"mcp_servers": {
  "google-sheets-oauth": {
    "serverUrl": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
  }
}

Provide your secure token in place of [YOUR_TOKEN_HERE] to ensure your agent requests are authenticated.

Execute

Start your Antigravity session. The agent will autonomously discover and utilize the Google Sheets (OAuth) tools with full Vinkius guardrails applied.

Google Sheets (OAuth) MCP is compatible with VS Code

VS Code Copilot

⚡

One-Click Install (Recommended)

In your Vinkius Dashboard, simply click the Add to VS Code button for this server. We'll automatically configure your local workspace.

Or configure manually

Open MCP Settings

Open VS Code, press Ctrl/Cmd + Shift + P, and search for GitHub Copilot: MCP Servers.

Add Server Config

Add the Vinkius endpoint configuration to your mcp-servers.json file:

"google-sheets-oauth": {
  "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
}

Ensure you replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com.

LangChain

Install Dependencies

Install the LangChain MCP adapters for your environment:

pip install langchain-mcp-adapters

Connect the Server

Use the SSEClient in LangChain to connect to the Vinkius managed endpoint:

from langchain_mcp_adapters.client import SSEClient

# Connect to Vinkius
client = SSEClient(url="https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp")
tools = client.get_tools()

CrewAI

Define the Tool

Load the Vinkius MCP tools into your CrewAI agents:

from crewai import Agent
from mcp_crewai import MCPTool

# Connect securely to Vinkius
vinkius_tools = MCPTool(url="https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp")

# Assign to Agent
researcher = Agent(
    role='Data Researcher',
    tools=vinkius_tools.get_all()
)

Execute Task

Run your CrewAI process. The agent will autonomously route tasks to the Vinkius managed server.

Choose How to Get Started

Build a custom MCP for your own tools, or connect a ready-made integration from our catalog.

Build Your Own

Turn any API into an MCP. Import a spec, define Agent Skills, or deploy with MCPFusion.

Import from OpenAPI, Swagger, or YAML specs
Create Agent Skills with progressive disclosure
Deploy to edge with MCPFusion framework
Built in DLP, auth, and compliance on each call
Real time usage dashboard and cost metering
Publish to catalog or keep private

Start building

Make Your AI Do More

Start with Google Sheets (OAuth), then connect any of our 5,200+ other servers whenever your AI needs more. One click, no limits.

Use this MCP plus 5,200+ others, all in one place
Add new capabilities to your AI anytime you want
Connections are secured and governed automatically
Track usage and costs across all your servers
Works with Claude, ChatGPT, Cursor, and more
New servers added to the catalog weekly

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.

VINKIUS INFRASTRUCTURE

Cloud Hosted

Managed infra

V8 Isolated

Sandboxed per request

Zero-Trust Proxy

No stored credentials

DLP Enforced

Policy on each call

GDPR Compliant

EU data residency

Token Compression

~60% cost reduction

Your data is protected. See how we built it.

Dealing with Sheets Data Requires Too Many Clicks Solved with Vinkius AI Gateway

Right now, if you need to audit a project tracker or pull financial metrics, the process is manual. You open Google Drive, find the right file, click on the specific tabs, and then manually select ranges using the mouse—all while risking copy-pasting errors between systems.

With this MCP, that clicking disappears. Your agent accepts natural language commands like 'Read the Q3 sales figures from Sheet 2.' The system handles finding the sheet ID, selecting the correct A1 range, and pulling clean data back to you immediately.

Using sheets.batch_read Brings Clarity to Complex Data

Before, if a report required metrics from three different areas (e.g., Sales Tab, Marketing Tab, and Budget Summary), you had to run three separate data pulls or manually combine the ranges into one giant view.

Now, using `sheets.batch_read`, your agent executes all those reads in a single function call. It gives you comprehensive data from multiple sources at once. The process is clean, fast, and eliminates manual consolidation.

Support 24/7 support@vinkius.com ↗

Security Vinkius Trust Center ↗

SLA Service Level Agreement ↗

Report Listing Send Report ↗

spreadsheet

oauth2

batch-processing

data-manipulation

real-time-sync

api-integration

What your AI can actually do with this

Forget copy-pasting data between tabs or having to manually check sheet metadata. With this MCP, your AI agent takes full control of Google Sheets using OAuth2. You can tell it what you need done—whether that's generating a brand new spreadsheet for a forecast or reading specific cell coordinates like 'Sheet1!A5:C10'.

It handles the heavy lifting: retrieving data from multiple ranges simultaneously, writing fresh values to existing cells, or simply adding rows of logged information at the bottom. This level of control means your agent can manage complex data workflows instantly. If you're looking for a comprehensive catalog that makes connecting to services easy, Vinkius hosts this MCP alongside thousands of others, giving your client access to everything it needs.

Built · Hosted · Managed by Vinkius Google Sheets MCP - Read, Write, and Manage Data

Server ID 019eb900-82d7-7208-a05b-3447b5994b69

Vinkius Inspector

Compliance Grade A+

Score 100/100

Report View Report ↗

What Changes When You Connect

Stop copy-pasting data. You can ask your agent to execute sheets.batch_read across ten different tabs simultaneously, pulling all the necessary metrics into one report without you touching a browser tab.

Maintain clean logs effortlessly. Instead of manually adding rows at the bottom, just instruct the agent to use sheets.append, and it handles the data entry while preserving your sheet's integrity.

Audit status trackers instantly. Use sheets.info to pull key metadata—like the timezone or list of tabs—to verify if a project tracker is configured correctly before you start using it.

Correct mistakes safely. Need to clear out old test data? Use sheets.clear to wipe values from a range while making sure the underlying formulas and formatting stay perfectly intact.

Build reports on demand. If you need a fresh file for modeling, simply tell the agent to use sheets.create, getting a new spreadsheet ID and URL instantly ready for population.

See it in action

01 01

The Quarterly Financial Review

A financial analyst needs to combine Q1 sales data, Q2 marketing spend, and current inventory levels into one master sheet. They ask their agent to use sheets.batch_read across three different source sheets, gathering all the disparate ranges into a single, readable output for review.

02 02

Project Status Tracking

A Product Manager needs to verify that every project sheet has been updated with the current week's status. They ask their agent to use sheets.info on all relevant trackers, which confirms the correct titles and tab structures before they compile a report.

03 03

System Logging & Auditing

An operations team member is logging daily system uptime metrics into a central sheet. Instead of opening the sheet and manually entering data, they ask their agent to use sheets.append, which adds the new row details automatically.

04 04

Data Migration Cleanup

A developer needs to reset an old test spreadsheet for a fresh run. They instruct the agent to use sheets.clear on all data ranges, ensuring that only the formatting and formula structure remain so they can start testing immediately.

The honest tradeoffs

What to watch out for, and the recommended way to handle each one.

Using sheets.write when you should append.

Avoid

The user asks to update a log file but uses sheets.write on the whole range, which overwrites all previous entries instead of adding new ones.

Instead

Reading data one cell at a time.

Avoid

Asking for 'A1' then 'B1', then 'C1'. This is inefficient and slow because it requires multiple tool calls when the goal was to read an entire row.

Instead

Manually finding sheet IDs.

Avoid

The user having to open the Google Drive interface, navigate through folders, copy a long URL, and paste it into the chat prompt.

Instead

Confusing read vs. batch_read

Avoid

Trying to pull data from three different ranges (e.g., 'Sheet1!A:B', 'Summary!E:F', 'Audit!A:D') using the singular sheets.read tool, which can only handle one range at a time.

Instead

When It Fits, When It Doesn't

Use this MCP if your data workflow relies on structured formats—anything that lives in rows and columns (finance reports, project trackers, log sheets). The core strength is the ability to perform batch operations: you don't just read one cell; you process ranges. Don't use it if you are trying to manage unstructured text documents or complex code bases; for that, look at a file management tool. Also, note the difference between sheets.write (which overwrites) and sheets.append (which adds). If your goal is logging new events, always ask for appending data; otherwise, you'll lose information.

Questions you might have

How do I get the title and tab names using sheets.info? +

The sheets.info tool retrieves detailed metadata about your spreadsheet, including its full title, timezone, locale settings, and a list of every sheet tab within it.

What's the difference between sheets.write and sheets.append? +

sheets.write overwrites any existing data in the target range. Use sheets.append if you want to add new rows of information without destroying the historical data at the bottom.

Can I read multiple ranges at once with sheets.batch_read? +

Yes, that's exactly what sheets.batch_read is for. You provide a comma-separated list of A1 notation strings, and the tool retrieves all of them efficiently in one go.

If I want to create a new spreadsheet, which tool do I use? +

Use sheets.create. This tool generates a brand-new Google Sheet file for you, providing both the unique ID and an immediate edit link so you can start populating it right away.

How do I read data from a specific cell range? +

You use sheets.read. Just remember to format your request using A1 notation, like 'SheetName!A1:D10', and the tool retrieves the values for you.

Give Claude and any AI agent real-world access

What AI agents can do with Google Sheets (OAuth) MCP With 7 Tools

Sheets.info

Gets metadata like the spreadsheet title, locale, timezone, and list of all tabs with their dimensions.

Sheets.read

Reads cell values from a specific Google Sheets range using A1 notation (e.g....

Sheets.batch Read

Efficiently reads data from multiple, distinct ranges in one single API call.

Sheets.write

Writes new data to a specific range of cells, overwriting any existing content there.

Sheets.append

Adds a set of values as completely new rows at the bottom of an existing table.

Sheets.clear

Removes cell content in a given range, but it keeps formatting and formulas structure intact.

Sheets.create

Initializes a brand-new Google Sheet file with a title you name.

Security and governance baked right in.

Claude AI

Open Claude Settings

Add Custom Connector

Start a conversation

Claude Code

Open your terminal

Add the MCP Server

Start coding

Cursor

One-Click Install (Recommended)

Open Cursor Settings

Add New Server

Use in Composer

Antigravity

Configure Agent Environment

Bind the Endpoint

Execute

VS Code Copilot

One-Click Install (Recommended)

Open MCP Settings

Add Server Config

Windsurf

One-Click Install (Recommended)

Open Windsurf Settings

Add Server Endpoint

LangChain

Install Dependencies

Connect the Server

CrewAI

Define the Tool

Execute Task

Choose How to Get Started

Build Your Own

Make Your AI Do More

Dealing with Sheets Data Requires Too Many Clicks Solved with Vinkius AI Gateway

Using sheets.batch_read Brings Clarity to Complex Data

spreadsheet

oauth2

batch-processing

data-manipulation

real-time-sync

api-integration

What your AI can actually do with this

Here's how it actually works

Who is this actually for?

What Changes When You Connect

The Quarterly Financial Review

Project Status Tracking

System Logging & Auditing

Data Migration Cleanup

The honest tradeoffs

Using sheets.write when you should append.

Reading data one cell at a time.

Manually finding sheet IDs.

Confusing read vs. batch_read

When It Fits, When It Doesn't

Questions you might have