Googlesheet MCP

This is a Google Sheets MCP server project that provides tools for interacting with Google Sheets, including functions for reading, writing, and updating spreadsheet data.

Developer tools Cloud platform #Spreadsheet interaction #Data management #Google services .Python

rating : 2 points

downloads : 12

update time : 2025-04-29

What is the Google Sheets MCP Server?

This is a middleware service that connects your application to Google Sheets. It provides a set of tools that allow you to manipulate spreadsheet data without directly dealing with the complexity of the Google API.

How to use the Google Sheets MCP Server?

Interact with your Google Sheet through simple commands. First, you need to set up Google Cloud credentials, and then send instructions via Cursor or the command - line tool.

Use cases

Suitable for scenarios where data needs to be stored in Google Sheets, such as data collection, report generation, team collaboration, etc. Particularly suitable for applications that require automated processing of tabular data.

Main features

List spreadsheetsView all accessible Google Sheets files

Read spreadsheet dataGet content from a specified spreadsheet

Generate mock dataAutomatically generate test data based on the table structure

Write dataAdd new data rows to the table

Update dataModify existing records in the table

Advantages and limitations

Advantages

No need to directly deal with the complex Google API

Provides a simple command - line interface

Supports multiple data formats (CSV/JSON)

Can be seamlessly integrated with the Cursor editor

Limitations

Requires Google Cloud account setup

Requires manual sharing of spreadsheets with the service account

Batch operation performance is limited by the Google API

How to use

Set up Google Cloud credentials

Create a service account in the Google Cloud console and download the credential file

Install dependencies

Install the necessary Python libraries

Configure Cursor

Add the server to Cursor's MCP configuration

Share the spreadsheet

Share your Google Sheet with the service account email

Start using

Run commands in Cursor to interact with the spreadsheet

Usage examples

Data collection applicationAutomatically save form data submitted by users to Google Sheet

Report generationRead data from the database and generate formatted reports

Data updateUpdate customer contact information based on ID

Frequently Asked Questions

Why do I get a 'Permission denied' error?

How to view the email address of the service account?

Which data formats are supported?

How to specify the row to be updated when updating records?

Why don't my changes appear immediately?

Related resources

Google Sheets API Documentation

Official API reference documentation

Google Cloud Console

Manage service accounts and APIs

MCP Protocol Description

Cursor's MCP protocol documentation

Example Project Repository

Contains complete example code

🚀 Google Sheets MCP Server

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

🚀 Quick Start

This MCP server offers seamless interaction with Google Sheets, enabling you to effortlessly read, write, and update data. Follow the steps below to get started.

✨ Features

Read, write, and update data in Google Sheets.
Provide a set of commands to operate on spreadsheets.

📦 Installation

Prerequisites

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

Steps

Clone this repository:

git clone <your-repository-url>
cd mcp-server-demo

Install the required packages:

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

Download and place the credentials.json file:
- Download the credentials.json file from your Google Cloud Console.
- Place the credentials.json file in the same directory as main.py.
- Ensure the file name is exactly credentials.json.

Configure Google Cloud Platform Credentials

Go to Google Cloud Console.
Create a new project or select an existing one.
Enable the Google Sheets API:
- Go to "APIs & Services" > "Library".
- Search for "Google Sheets API".
- Click "Enable".
Create credentials:
- Go to "APIs & Services" > "Credentials".
- Click "Create Credentials" > "Service Account".
- Fill in the service account details:
  - Name: Choose a descriptive name.
  - ID: Automatically generated.
  - Description: Optional description.
- Click "Create and Continue".
- For the role, select "Editor" (or an appropriate role as needed).
- Click "Continue" and then "Done".
Create and download the key:
- In the service account list, click on your newly created account.
- Go to the "Keys" tab.
- Click "Add Key" > "Create new key".
- Select the "JSON" format.
- Click "Create".
- The JSON file will be downloaded automatically.
Save the credentials:
- Rename the downloaded JSON file to credentials.json.
- Place it in the mcp-server-demo directory.
Share your Google Sheet:
- Open your Google Sheet.
- Click the "Share" button.
- Add the service account email (found in the client_email field of the credentials.json file).
- Give it "Editor" access.

Install the MCP Server

Download the MCP server:

git clone https://github.com/YOUR_REPO/mcp-server.git
cd mcp-server

Install the dependencies:

pip install -r requirements.txt

Start the MCP server:

python server.py

💻 Usage Examples

Command List

List all commands:

mcp list-commands

Get table data:

mcp get-table --spreadsheet_id YOUR_SPREADSHEET_ID --sheet_name YOUR_SHEET_NAME

Add a new record:

mcp add-record --spreadsheet_id YOUR_SPREADSHEET_ID --sheet_name YOUR_SHEET_NAME --data "value1,value2\nvalue3,value4"

Update a record:

mcp update-record --spreadsheet_id YOUR_SPREADSHEET_ID --sheet_name YOUR_SHEET_NAME --identifier RECORD_IDENTIFIER --updates "column1=value1\ncolumn2=value2"

📚 Documentation

Security Considerations

Credential Management:
- Exclude credentials.json from version control systems.
- Rotate your credentials regularly.
- Only share your Google Sheet with necessary service accounts.
Permission Control:
- Ensure the service account email has been added as an editor to the sheet.
- Verify the validity and security of the credentials.json file.
Data Protection:
- Regularly back up important data.
- Use HTTPS to transmit sensitive information.
- Comply with relevant privacy regulations and policies.

Troubleshooting

Common Issues

Authentication Errors:
- Ensure the service account email has been added as an editor to the sheet.
- Verify the validity and integrity of the credentials.json file.
- Check if the Google Sheets API is enabled in your Google Cloud project.
Permission Errors:
- Confirm that the service account has the correct permissions.
- Verify if the sheet has been shared with the service account email.
- Check if the sheet ID is correct.
Data Format Errors:
- Ensure the data format conforms to the expected structure.
- Check if the sheet has the required columns (id or name).
- Verify that the number of data columns matches the sheet.