Use This MCP server To

Read and update Google Sheets data in real time Automate spreadsheet data entry and modifications Integrate spreadsheet data into AI-driven workflows Generate reports based on live spreadsheet data Sync spreadsheet content with other applications Enable AI agents to query and analyze spreadsheet data

README

Google Sheets MCP

A Model Context Protocol (MCP) connector for Google Sheets that allows AI agents to interact with spreadsheets directly.

Demo

Google_Sheets_MCP-demo.mp4

Setup

Clone this repository:

git clone https://github.com/mkummer225/google-sheets-mcp
cd google-sheets-mcp

Install dependencies: npm install
Build: npm run build
Create OAuth credentials in Google Cloud Platform:
- Create a new project in Google Cloud Console
- Enable the Google Sheets API
- Configure the OAuth consent screen
- Create OAuth client ID credentials (Desktop application) with an appropriate redirect URI (ex: http://localhost:3000/oauth2callback)
- Download the credentials and save as gcp-oauth.keys.json in the dist subdirectory
Start the MCP server (you'll automatically be prompted to authenticate/re-authenticate your Google account when necessary): npm run start

Usage

Sample config:

{
    "mcpServers": {
    "google-sheets-mcp": {
      "command": "node",
      "args": [
        "/{path_to_dir}/google-sheets-mcp/dist/index.js"
      ]
    }
  }
}

Then you should be able to simply specify your spreadsheetId or ask your agent to create a new one for you.

Available Actions

Action	Description
`refresh_auth`	Re-authenticate your Google Account when credentials expire
`list_sheets`	List all sheets/tabs in a Google Spreadsheet
`create_sheet`	Create a new sheet/tab in a Google Spreadsheet
`create_spreadsheet`	Create a new Google Spreadsheet
`read_all_from_sheet`	Read all data from a specified sheet
`read_headings`	Read the column headings from a sheet
`read_rows`	Read specific rows from a sheet
`read_columns`	Read specific columns from a sheet
`edit_cell`	Edit a single cell in a sheet
`edit_row`	Edit an entire row in a sheet
`edit_column`	Edit an entire column in a sheet
`insert_row`	Insert a new row at specified position
`insert_column`	Insert a new column at specified position
`rename_sheet`	Rename a sheet/tab in a spreadsheet
`rename_doc`	Rename a Google Spreadsheet

License

MIT

google-sheets-mcp FAQ

How do I authenticate the Google Sheets MCP server?

You authenticate using OAuth credentials created in Google Cloud Platform with the Google Sheets API enabled.

Can this MCP server handle multiple spreadsheets?

Yes, it can connect to and manage multiple Google Sheets as long as the OAuth credentials have access.

Is real-time data synchronization supported?

Yes, the server allows AI agents to read and write spreadsheet data in real time.

What programming languages or environments can use this MCP server?

Any environment that supports MCP clients can interact with this server, typically via HTTP or WebSocket protocols.

How secure is the data access through this MCP server?

Data access is secured via OAuth 2.0, ensuring only authorized clients can read or modify spreadsheets.

Can I customize which sheets or ranges the AI can access?

Yes, access can be scoped by specifying particular sheets or ranges within the spreadsheet.

Does this server support batch updates to Google Sheets?

Yes, it supports batch operations to efficiently update multiple cells or ranges.

What are the setup requirements for running this MCP server?

You need Node.js, npm, Google Cloud OAuth credentials, and enabled Google Sheets API.