mcp-google-sheets
If you are the rightful owner of mcp-google-sheets and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcpreview.com.
mcp-google-sheets is a Python-based MCP server that connects MCP-compatible clients to Google Sheets API for automation and data manipulation.
mcp-google-sheets serves as a bridge between MCP-compatible clients and the Google Sheets API, allowing users to interact with Google Spreadsheets through a set of defined tools. This server facilitates powerful automation and data manipulation workflows driven by AI, making it an ideal solution for users looking to integrate spreadsheet functionalities into their applications. The server supports various authentication methods, including Service Accounts and OAuth 2.0, ensuring flexibility and security in accessing Google APIs. With features like CRUD operations, batch processing, and sharing capabilities, mcp-google-sheets is designed to streamline spreadsheet management and enhance productivity.
Features
- Seamless Integration: Connects directly to Google Drive & Google Sheets APIs.
- Comprehensive Tools: Offers a wide range of operations (CRUD, listing, batching, sharing, formatting, etc.).
- Flexible Authentication: Supports Service Accounts, OAuth 2.0, and direct credential injection via environment variables.
- Easy Deployment: Run instantly with uvx or clone for development using uv.
- AI-Ready: Designed for use with MCP-compatible clients, enabling natural language spreadsheet interaction.
Tools
- get_sheet_data: Get data from specific Google spreadsheets
- update_cells: Update cell data in a spreadsheet
- batch_update_cells: Batch update of cell data in multiple ranges
- list_sheets: List all worksheets in a spreadsheet
- list_spreadsheets: List all spreadsheets in shared folders
- create_spreadsheet: Create a new spreadsheet
- create_sheet: Create a new worksheet in an existing spreadsheet