MCP Google Spreadsheet
by kazz187
MCP Google Spreadsheet is a tool implemented as a Model Context Protocol server for operating Google Spreadsheets and Google Drive. It allows AI assistants to interact with Google Spreadsheet and Google Drive files.
Last updated: N/A
What is MCP Google Spreadsheet?
MCP Google Spreadsheet is a server that enables AI assistants to interact with Google Spreadsheets and Google Drive files through the Model Context Protocol. It provides a set of functions to manage files and manipulate spreadsheet data.
How to use MCP Google Spreadsheet?
- Install using
go install github.com/kazz187/mcp-google-spreadsheet@latest. 2. Configure environment variables:MCPGS_CLIENT_SECRET_PATH,MCPGS_TOKEN_PATH,MCPGS_FOLDER_ID. 3. Set up Google API credentials. 4. Run the server. 5. Configure your AI assistant (e.g., Claude, ChatGPT) with the provided MCP configuration.
Key features of MCP Google Spreadsheet
List files in Google Drive
Copy files in Google Drive
Rename files in Google Drive
List sheets in a spreadsheet
Copy sheets within a spreadsheet
Rename sheets within a spreadsheet
Get sheet data
Add rows to a sheet
Add columns to a sheet
Update cells in a sheet
Batch update cells in a sheet
Use cases of MCP Google Spreadsheet
Automating data entry and manipulation in Google Sheets
Generating reports from Google Sheets data using AI assistants
Managing files in Google Drive through AI commands
Integrating Google Sheets and Google Drive with other AI-powered workflows
FAQ from MCP Google Spreadsheet
What are the prerequisites for using this server?
What are the prerequisites for using this server?
Go 1.24 or higher and a Google Cloud Platform project with Google Drive API and Google Sheets API enabled.
How do I install the server?
How do I install the server?
Use the command go install github.com/kazz187/mcp-google-spreadsheet@latest.
What environment variables do I need to configure?
What environment variables do I need to configure?
MCPGS_CLIENT_SECRET_PATH, MCPGS_TOKEN_PATH, and MCPGS_FOLDER_ID.
How do I set up Google API credentials?
How do I set up Google API credentials?
Go to Google Cloud Console, create a project, enable the APIs, create OAuth client ID credentials, and download the client secret.
How do I configure my AI assistant to use this server?
How do I configure my AI assistant to use this server?
Add the provided MCP configuration to your AI assistant's configuration file, ensuring the correct paths to the client secret and token files are specified.