mcp-google-spreadsheet
23
The project is a tool that allows AI assistants to interact with Google Spreadsheet and Google Drive by implementing operations like listing, copying, and renaming files and sheets. Its functionality is secured to operate only within a designated folder.
MCP Google Spreadsheet
This project is a tool implemented as a Model Context Protocol (MCP) server for operating Google Spreadsheet and Google Drive. It enables AI assistants to manage files on Google Spreadsheet and Google Drive.
Features
Google Drive Operations
- List files
- Copy files
- Rename files
Google Spreadsheet Operations
- List sheets
- Copy sheets
- Rename sheets
- Get sheet data
- Add rows
- Add columns
- Update cells
- Batch update cells
Prerequisites
- Go 1.24 or higher
- Google Cloud Platform project with API enabled:
- Google Drive API
- Google Sheets API
Installation
Install via Go command to include in $GOPATH/bin. Ensure the appropriate environment variables are set for operation.
Security
- Access is limited to files within the specified folder ID
- Prevents directory traversal attacks
- Verifies existence of specified files in the folder