Google Sheets MCP Server

Search and inspect Google Sheets, create and edit spreadsheets, scan for data issues, review edit history, and manage comments.

MCP servers#12 · score 66Smithery

What it does

Search and inspect Google Sheets, create and edit spreadsheets, scan for data issues, review edit history, and manage comments.

How to install the Google Sheets MCP Server

Install it with one Smithery CLI line and enter the settings below when asked.

Claude Desktop

npx -y @smithery/cli install googlesheets --client claude

Cursor

npx -y @smithery/cli install googlesheets --client cursor

Remote server address (Streamable HTTP)

https://googlesheets.run.tools

Keys and passwords go only to the provider and your own machine; ListeningMind never receives them.

13 tools

  • Arcade_ListApps See the apps the current caller can act on and whether they are connected. Returns each app's id, name, connected state, and (when connected) the account it is connected as.
  • GoogleSheets_CheckSpreadsheetAccess Check whether this app can already read each of several spreadsheets, in one batched pre-flight call, before attempting to read them.
  • GoogleSheets_CommentOnSpreadsheet Create a comment on a spreadsheet, edit a comment's body, or resolve/reopen it.
  • GoogleSheets_CreateOrEditSpreadsheet Create a new spreadsheet or batch-edit an existing one. Omit spreadsheetid to create; provide it to edit.
  • GoogleSheets_DeleteComment Delete a comment from a spreadsheet. Only the comment's author can delete it (enforced by Google Drive); deleting marks the whole thread (the comment and its replies) as deleted.
  • GoogleSheets_GenerateGoogleFilePickerUrl Generate a URL where the user can grant this app access to spreadsheets. Opens Google's first-party Drive picker, filtered to Google Sheets, where the user browses and selects whic…
  • GoogleSheets_GetSpreadsheetEditHistory Report who edited a spreadsheet and when, from Google Drive revisions. Reports the "who" and "when" only — not which cells changed, and it can't revert.
  • GoogleSheets_InspectSpreadsheet Inspect a Google Sheets spreadsheet's structure or read a range of cells. Use the default 'structure' mode to understand a workbook cheaply before reading.
  • GoogleSheets_ListSpreadsheetComments List a spreadsheet's comment threads, or the full replies of a single comment.
  • GoogleSheets_ReplyToComment Add a reply to an existing comment on a spreadsheet. To resolve or reopen the comment instead, use commentonspreadsheet with a status.
  • GoogleSheets_ScanForDataIssues Deterministically flag 'weird'/bad cells in spreadsheet data. No LLM judgement: the same input always returns the same flags.
  • GoogleSheets_SearchSpreadsheets Searches for spreadsheets in the user's Google Drive based on the titles and content and returns the title, ID, and URL for each matching spreadsheet.
  • GoogleSheets_WhoAmI Get comprehensive user profile and Google Sheets environment information. This tool provides detailed information about the authenticated user including their name, email, profile…

Why it was picked · #12 · score 66

  • Popularity (41%)84
  • Trust (29%)60
  • Member reviewsNot used this week
  • Search demand (18%)77
  • Search and AI Overview presence (12%)0

Source: Smithery · 56,138 uses · monthly searches 720 · First picked 2026-10-20

Trust checks

  • ✓ Verified at the source
  • – In the official MCP Registry
  • – Own homepage
  • ✓ Live endpoint
  • ✓ Clear description

How we pick →

Made it? Add the badge to your README

[![ListeningMind pick](https://daas.listeningmind.ai/badge/mcps/x-mcp-googlesheets.svg)](https://daas.listeningmind.ai/en/catalog/mcps/x-mcp-googlesheets)

How to buy

People

Top up Lima and pay for what you use (1 Lima = $0.077 whole Lima). For now top-ups go through our team. Ask to top up · m-support@listeningmind.com

Agents

Agents connect the provider's way. Paying in ListeningMind Lima opens once the provider registers and links it.

Reviews ·

    No reviews yet.

    Who can review: Any member. Say in one line what you did with it; it is shown after a check. Only the first letter of your name is shown. A new review replaces your earlier one.

    Questions people ask

    What is the Google Sheets MCP Server?

    Search and inspect Google Sheets, create and edit spreadsheets, scan for data issues, review edit history, and manage comments. It is listed on Smithery and ranks #12 (score 66) in ListeningMind.AI's weekly picks.

    How do I install the Google Sheets MCP Server?

    Run npx -y @smithery/cli install googlesheets --client claude in a terminal to add it to Claude Desktop. For Cursor, use --client cursor.

    Do I need an API key?

    The provider lists no required settings.

    Which tools does it provide?

    13 tools: Arcade_ListApps, GoogleSheets_CheckSpreadsheetAccess, GoogleSheets_CommentOnSpreadsheet, GoogleSheets_CreateOrEditSpreadsheet, GoogleSheets_DeleteComment, GoogleSheets_GenerateGoogleFilePickerUrl, GoogleSheets_GetSpreadsheetEditHistory, GoogleSheets_InspectSpreadsheet, GoogleSheets_ListSpreadsheetComments, GoogleSheets_ReplyToComment, GoogleSheets_ScanForDataIssues, GoogleSheets_SearchSpreadsheets.

    How much does it cost?

    Free to connect · provider's own fees apply. The provider may charge for use on its own terms.

    Can I trust it?

    Checks passed: Verified at the source, Live endpoint, Clear description. Skim a server or repository you have not used before connecting it.