GoogleSheets-mcp-server

GoogleSheets-mcp-server

3.2
cloud_platforms

If you are the rightful owner of GoogleSheets-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A comprehensive Model Context Protocol (MCP) server for interacting with the Google Sheets API. This server provides tools and resources for managing spreadsheets, sheets, values, and developer metadata.

The Google Sheets API MCP Server is designed to facilitate seamless interaction with Google Sheets through a Model Context Protocol. It offers a robust set of tools for managing spreadsheets, including creating, reading, updating, and deleting spreadsheets and sheets. Users can efficiently handle values by reading, writing, appending, and clearing them. Additionally, the server supports operations on developer metadata, allowing for enhanced data management and organization. The server is built to work with OAuth 2.0 authentication, ensuring secure access to Google Sheets data. It requires Node.js 16 or higher and a Google Cloud Platform project with the Google Sheets API enabled. The server is easy to set up and run, with clear instructions for installation and configuration.

Features

  • Create, read, update, and delete spreadsheets
  • Manage sheets within spreadsheets
  • Read, write, append, and clear values
  • Work with developer metadata
  • Access spreadsheet data through MCP resources

Tools

  1. createSpreadsheet

    Create a new spreadsheet

  2. getSpreadsheet

    Get spreadsheet details

  3. batchUpdate

    Apply multiple updates to a spreadsheet

  4. copySheet

    Copy a sheet to another spreadsheet

  5. addSheet

    Add a new sheet to a spreadsheet

  6. deleteSheet

    Delete a sheet from a spreadsheet

  7. updateSheetProperties

    Update sheet properties

  8. getValues

    Get values from a range

  9. updateValues

    Update values in a range

  10. appendValues

    Append values to a range

  11. clearValues

    Clear values from a range

  12. batchGetValues

    Get values from multiple ranges

  13. batchUpdateValues

    Update values in multiple ranges

  14. getDeveloperMetadata

    Get all developer metadata

  15. createDeveloperMetadata

    Create new developer metadata

  16. updateDeveloperMetadata

    Update existing developer metadata

  17. deleteDeveloperMetadata

    Delete developer metadata

Related MCP Servers

View all cloud_platforms servers →
dev-mcp

dev-mcp

4.3

by Shopify

This project implements a Model Context Protocol (MCP) server that interacts with Shopify Dev, supporting various tools to interact with different Shopify APIs.

developer_tools
edgeone-pages-mcp

edgeone-pages-mcp

4.2

by TencentEdgeOne

An MCP service for deploying HTML content, folder, and zip file to EdgeOne Pages and obtaining a publicly accessible URL.

cloud_platforms
mcp-server

mcp-server

3.9

by keboola

Keboola MCP Server connects AI agents and MCP clients to Keboola, enabling data access and transformations without glue code.

cloud_platforms
mcp-atlassian

mcp-atlassian

3.8

by sooperset

Model Context Protocol (MCP) server for Atlassian products (Confluence and Jira). This integration supports both Confluence & Jira Cloud and Server/Data Center deployments.

cloud_platforms
Nx MCP Server

Nx MCP Server

3.8

by nrwl

A Model Context Protocol server implementation for Nx, providing LLMs with deep access to monorepo structures.

cloud_platforms
azure-mcp

azure-mcp

3.8

by Azure

The Azure MCP Server implements the MCP specification to create a seamless connection between AI agents and Azure services.

cloud_platforms
notion-mcp-server

notion-mcp-server

3.7

by makenotion

This project implements an MCP server for the Notion API, allowing integration with LLMs.

databases
hyper-mcp

hyper-mcp

3.7

by tuananh

hyper-mcp is a fast, secure MCP server that extends its capabilities through WebAssembly plugins.

ai_chatbot
mcp-server-kubernetes

mcp-server-kubernetes

3.7

by Flux159

MCP Server that can connect to a Kubernetes cluster and manage it.

os_automation
enrichmcp

enrichmcp

3.7

by featureform

MCPEngine is a production-grade, HTTP-first implementation of the Model Context Protocol (MCP), providing a secure, scalable, and modern framework for exposing data, tools, and prompts to Large Language Models (LLMs) via MCP.

developer_tools
MCP Component Server

MCP Component Server

3.7

by baidubce

The MCP Component Server is a FastMCP server-based implementation that converts AppBuilder Components into FastMCP tools, enabling seamless integration of Baidu cloud AI services into MCP-compatible environments.

cloud_platforms
chroma-mcp

chroma-mcp

3.7

by chroma-core

Chroma MCP Server is an open-source embedding database server that facilitates the integration of LLM applications with external data sources using the Model Context Protocol.

databases
mcp-sse

mcp-sse

3.7

by sidharthrajaram

This document describes an SSE-based MCP server and client setup for weather data retrieval using the Model Context Protocol.

cloud_platforms
cos-mcp

cos-mcp

3.7

by Tencent

Tencent Cloud COS MCP Server allows large models to quickly access Tencent Cloud Storage (COS) and Data Processing (CI) capabilities without coding.

cloud_platforms
mcp-server-azure-devops

mcp-server-azure-devops

3.7

by Tiberriver256

A Model Context Protocol (MCP) server implementation for Azure DevOps, allowing AI assistants to interact with Azure DevOps APIs through a standardized protocol.

cloud_platforms
code-sandbox-mcp

code-sandbox-mcp

3.6

by Automata-Labs-team

A secure sandbox environment for executing code within Docker containers. This MCP server provides AI applications with a safe and isolated environment for running code while maintaining security through containerization.

security
mcp-k8s-go

mcp-k8s-go

3.6

by strowk

Golang-based MCP server connecting to Kubernetes, providing a range of functionalities to interact with Kubernetes resources.

cloud_platforms
ocireg-mcp

ocireg-mcp

3.6

by StacklokLabs

An MCP server that provides tools for querying OCI registries and image references.

cloud_platforms
win-cli-mcp-server

win-cli-mcp-server

3.6

by SimonB97

MCP server for secure command-line interactions on Windows systems, enabling controlled access to PowerShell, CMD, Git Bash shells, and remote systems via SSH.

os_automation
codehooks-mcp-server

codehooks-mcp-server

3.6

by RestDB

This MCP server provides tools for interacting with codehooks.io projects through AI agents like Claude.

developer_tools
mcp

mcp

3.6

by mondaycom

monday.com MCP is an open framework for integrating AI agents with monday.com, providing secure access to structured data and tools for smart decision-making.

cloud_platforms
aws-mcp

aws-mcp

3.6

by RafalWilinski

AWS MCP is a Model Context Protocol server that allows AI assistants to interact with AWS environments using natural language.

cloud_platforms
emcee

emcee

3.6

by loopwork

emcee is a tool that provides a Model Context Protocol (MCP) server for any web application with an OpenAPI specification.

developer_tools
dify-mcp-server

dify-mcp-server

3.6

by YanxingLiu

A simple implementation of an MCP server for using Dify, enabling the invocation of Dify workflows by calling MCP tools.

cloud_platforms
Lambda-MCP-Server

Lambda-MCP-Server

3.6

by mikegc-aws

This project demonstrates a serverless MCP server using AWS Lambda, showcasing streamable HTTP support and integration with Amazon Bedrock.

cloud_platforms
kom

kom

3.6

by weibaohui

`kom` is a tool for Kubernetes operations, providing SDK-level encapsulation of kubectl and client-go.

cloud_platforms
mcp-omnisearch

mcp-omnisearch

3.6

by spences10

A Model Context Protocol (MCP) server that provides unified access to multiple search providers and AI tools.

research_and_data