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@mcphub.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
