Google Sheets MCP Server

This MCP server provides tools to interact with Google Sheets, allowing you to read, write, and update data in your spreadsheets.

Prerequisites

• Python 3.8 or higher
• Google Cloud Platform account
• A Google Sheet that you want to interact with

Installation

1. Clone this repository:

git clone 
cd mcp-server-demo

2. Install the required packages:

pip install google-auth-oauthlib google-auth-httplib2 google-api-python-client

3. Download and place credentials.json:

Setting up Google Cloud Platform Credentials

1. Go to the Google Cloud Console

2. Create a new project or select an existing one

3. Enable the Google Sheets API:

4. Create credentials:

5. Create and download the key:

6. Save the credentials:

7. Share your Google Sheet:

Running the Server

1. Install the MCP server:

uv run mcp install main.py

2. The server will start and be ready to accept commands.

Adding to Cursor

To add this MCP server to Cursor, follow these steps:

1. Open Cursor

2. Go to Cursor -> Preferences -> Cursor Settings -> MCP -> Add new global MCP Server

3. Add the following configuration to your Cursor config file:

{
  "mcpServers": {
    "GoogleSheets": {
      "command": "python",
      "args": [
        "main.py"
      ]
    }
  }
}

4. Restart Cursor for the changes to take effect

Screenshots

Available Tools

List Spreadsheets

/tool list_spreadsheets

Lists all spreadsheets shared with the service account.

Get Spreadsheet Info

/tool get_spreadsheet_info "spreadsheet_id"

Gets information about a specific spreadsheet.

Get Sheet Content

/tool get_sheet_content "spreadsheet_id"

Retrieves the content of a specific sheet.

Generate Sheet Data

/tool generate_sheet_data "spreadsheet_id"  number_of_records

Generates realistic data based on the sheet's attributes.

Add Data to Sheet

/tool add_data_to_sheet "spreadsheet_id"  "data_string"

Adds pre-generated data to a sheet.

Update Sheet Record

/tool update_sheet_record "spreadsheet_id"  "identifier" "updates"

Updates a record in the sheet based on id or name matching.

Data Formats

For Adding Data

The data string can be in one of these formats:

1. List of lists format: `[["value1", "value2"], ["value3", "value4"]]`

2. CSV format:

value1,value2
value3,value4

For Updates

Provide the changes in format: `column1=value1 column2=value2`

Example: `age=25 email=xyz@example.com phone=1234567890`

Security Notes

1. Never commit `credentials.json` to version control

2. Keep your credentials secure

3. Only share your Google Sheet with necessary service accounts

4. Regularly rotate your credentials

Troubleshooting

Common Issues

1. Authentication Errors

2. Permission Errors

3. Data Format Errors

Support

If you encounter any issues or have questions, please:

1. Check the error messages in the logs

2. Verify your setup following the instructions above

3. Ensure all prerequisites are met

4. Contact aryanpandit17032002@gmail.com