xing5/mcp-google-sheets

Overview

Connects your AI assistant to Google Sheets and Drive so it can create, read, and update spreadsheets on request, useful for anyone who tracks numbers, inventory, or leads in a spreadsheet and wants a faster way to update it. Ask it to pull a range of data, add a new row, or build a new sheet from scratch, all through plain-English requests. A practical fit for small teams whose operational tracking already lives in Sheets.

Best for

Best for
Small teams who track their operations in Google Sheets and want faster updates

Use cases

• Pull a range of data from a spreadsheet into a conversation
• Add or update rows as new information comes in
• Create a new spreadsheet or tab from a plain-English request
• Automate a recurring data entry task without opening Sheets

How to use

Install

uvx mcp-google-sheets@latest

Tools exposed

• SERVICE_ACCOUNT_PATH
• GOOGLE_APPLICATION_CREDENTIALS
• DRIVE_FOLDER_ID
• CREDENTIALS_PATH
• TOKEN_PATH
• CREDENTIALS_CONFIG

Tested with

Claude Desktop

Notes

A Python-based MCP (Model Context Protocol) server that integrates with Google Drive and Google Sheets. It enables creating, reading, and modifying spreadsheets programmatically through the MCP interface, commonly used by AI agents like Claude to interact with spreadsheet data.

884 stars on GitHub. Last updated 2026-05-14. Licensed MIT.

Use cases

• Enable an AI assistant to create and populate spreadsheets dynamically
• Automate data retrieval and updates in Google Sheets via natural language commands
• Integrate spreadsheet operations into custom MCP-based workflows

Pros

• Open-source and widely adopted with 884 GitHub stars
• Straightforward MCP integration for existing AI tools
• Python-based, easy to extend or customize

Cons

• Requires Google Cloud project setup and OAuth credentials
• Limited to Google Sheets, no support for Excel or other spreadsheet formats
• Dependent on network access to Google APIs

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.