BI and reporting Official

Google Sheets MCP server

Remote endpoint sheetsmcp.googleapis.com/mcp/v1. Checked September 2026.

Spreadsheets are where a team keeps its order exports, ad spend trackers, inventory counts, budgets, and hand-built reports, and Google's Sheets server reads a range of cells and writes values, formulas, and new rows back under the signed-in user's Google permissions. The Drive server reads a spreadsheet as a file instead, and cannot edit cells.

Google Sheets MCP options

Every fact in a row comes from the publisher's own documentation.

Ways to reach Google Sheets data from an assistant
Option	Audience	Reads or changes	Sign-in	Setup
Google Sheets MCP server `https://sheetsmcp.googleapis.com/mcp/v1` Google	Developers	Remote server that reads cell values and spreadsheet metadata and can update values and formulas, insert rows or columns, and apply batch structural updates, with the signed-in user's Google permissions; needs a Google Cloud project, your own OAuth client, and Workspace Developer Preview membership. Can write	OAuth sign-in	Setup guide (opens in a new tab)
Google Drive MCP server, remote `https://drivemcp.googleapis.com/mcp/v1` Google	Merchants	Remote server, also listed in Claude's connector directory as made by Google: searches Drive and reads file content including Sheets, and can create or copy files; it reads spreadsheets as files rather than editing cells. Can write	OAuth sign-in	Setup guide (opens in a new tab)

Connect Google Sheets to your assistant

Each card lists the servers whose setup guide covers that assistant.

Connect Google Sheets to Claude

Google Sheets's setup guides also name Antigravity.

Tools each server exposes

Listed as each publisher documents them. A write tool can change something in the account.