google-sheets-mcp-server

lionharrt/google-sheets-mcp-server

3.1

If you are the rightful owner of google-sheets-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 dayong@mcphub.com.

The Google Sheets MCP Server is a Model Context Protocol server that integrates Google Sheets with HTTP+Streamable transport, designed for Dify and other MCP clients.

Tools

Functions exposed to the LLM to take actions

get_sheet_data

Read data from spreadsheet ranges

update_cells

Update specific cell ranges

create_spreadsheet

Create new spreadsheets

list_spreadsheets

List available spreadsheets

add_rows

Append rows to sheets

list_sheets

List sheets within a spreadsheet

create_sheet

Add new sheet tabs

health_check

Server health monitoring

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources