Google Sheets MCP Server

Google Sheets data access for AI clients through a Python-based integration bridge.

Data last scanned today · Reviewed today

4520 tools★ 962PythonMIT

Overview

Google Sheets MCP Server facilitates direct communication between your AI assistant and Google Sheets. Built with Python, it allows users to perform automated data interactions by configuring credentials through Google Cloud Platform, ideally via a service account.

Our verdict

With a security score of 45/100, this server is classified as high risk. Security-critical components such as OAuth support and read-only mode have not yet been editorially reviewed, meaning users should exercise caution regarding how the tool handles sensitive spreadsheet permissions. This project is community-maintained and intended for users comfortable managing their own cloud credentials and API configurations.

Zero direct dependencies reduce the supply-chain attack surface
MIT license provides permissive usage terms
Supports rapid deployment via uvx

OAuth and read-only mode implementations lack security review
Not maintained by the official Google vendor
Missing explicit homepage documentation link

Tools

Tool	Description	Risk
list_spreadsheets	Lists spreadsheets in the configured Drive folder or accessible by the user.	low
create_spreadsheet	Creates a new spreadsheet.	medium
get_sheet_data	Reads data from a range in a sheet/tab.	low
get_sheet_formulas	Reads formulas from a range in a sheet/tab.	low
update_cells	Writes data to a specific range.	medium
batch_update_cells	Updates multiple ranges in one API call.	medium
add_rows	Adds (inserts) empty rows to a sheet/tab at a specified index.	medium
list_sheets	Lists all sheet/tab names within a spreadsheet.	low
create_sheet	Adds a new sheet/tab to a spreadsheet.	medium
get_multiple_sheet_data	Fetches data from multiple ranges across potentially different spreadsheets in one call.	low

Compatibility

Client	Local	Docker	Remote	Read-only
ChatGPT
Claude Desktop
Cursor
VS Code
Windsurf

Frequently asked questions

›What authentication methods are supported by this server?

The server supports Google Service Accounts, which are recommended, as well as OAuth 2.0 and direct credential injection via environment variables.

›How can I reduce the number of tokens used by this server?

By default, the server exposes 19 tools consuming approximately 13,000 tokens. You can reduce this by using tool filtering via the --include-tools command-line argument or the ENABLED_TOOLS environment variable to load only necessary tools.

›What is the recommended way to install and run this server?

The server can be run directly using uvx with the command uvx mcp-google-sheets@latest. It is recommended to use the @latest tag to ensure you are running the most recent version with all current features and bug fixes.

›Are there specific environment variables I must set to use the server?

Yes, you generally need to provide the path to your credentials via SERVICE_ACCOUNT_PATH and define the DRIVE_FOLDER_ID where your sheets are located.