Skip to directory

About Google Sheets MCP

Google Workspace remote MCP server for Google Sheets. This service is in Google's Developer Preview.

Connection and setup
Hosting
Google-managed remote
Transport
Streamable HTTP
Endpoint
https://sheetsmcp.googleapis.com/mcp/v1
Authentication
OAuth 2.0. Configure the consent screen and an OAuth client marked “Use this client for an AI-powered agent”; grant only the listed product scopes and sign in with the Google account that should be accessible.

Requirements

  • Membership in the Google Workspace Developer Preview Program.
  • A Google Cloud project, with the relevant Workspace API and its MCP service enabled.
  • A supported remote MCP client and a Google account with access to the target Workspace data.
  • OAuth 2.0 consent configuration with these scopes: https://www.googleapis.com/auth/drive.readonly, https://www.googleapis.com/auth/drive.file, https://www.googleapis.com/auth/spreadsheets.readonly, https://www.googleapis.com/auth/spreadsheets.

Setup steps

  1. Join the Google Workspace Developer Preview Program and select/create a Google Cloud project.
  2. Enable Google Sheets API and the matching MCP service in that project.
  3. Configure Google Auth Platform consent and add the scopes shown in Requirements.
  4. Create an OAuth 2.0 client for an AI agent; use the redirect URI required by your MCP client.
  5. Add this server URL to the client: https://sheetsmcp.googleapis.com/mcp/v1
  6. Authenticate with the intended Google account, grant the requested scopes, refresh the tool list, and verify the listed operations.
Tools 6

Six tools read spreadsheet data/metadata or update cells, formulas, spreadsheets and dimensions. Writes change user data; verify spreadsheet/range.

  • get_values

    Officially listed get_values tool.

    01
  • get_spreadsheet

    Officially listed get_spreadsheet tool.

    02
  • update_spreadsheet

    Officially listed update_spreadsheet tool.

    03
  • update_values

    Officially listed update_values tool.

    04
  • update_formulas

    Officially listed update_formulas tool.

    05
  • insert_dimension

    Officially listed insert_dimension tool.

    06
Limitations and notes
  • Developer Preview
Original sources

Documentation checked 2026-10-28. Connection has not been runtime tested.

Similar tools