Google Sheets

httpnone★ 69productivity

Integrate with Google Sheets to read, write, and manage spreadsheet data.

Install

How to run this server

[ { "cmd": "npx mcp-gsheets@latest", "imports": [] } ]

server path: google-sheets-4

Tools

What this server exposes

read_spreadsheet

Read data from a Google Sheets spreadsheet

write_spreadsheet

Write data to a Google Sheets spreadsheet

batch_update

Perform batch operations on a Google Sheets spreadsheet

format_cells

Apply formatting to cells in a Google Sheets spreadsheet

create_chart

Create a chart in a Google Sheets spreadsheet

conditional_formatting

Apply conditional formatting rules to a Google Sheets spreadsheet

Configuration

Environment & auth

authnone

envGOOGLE_PROJECT_ID

envGOOGLE_SERVICE_ACCOUNT_KEY

envGOOGLE_PRIVATE_KEY

envTEST_SPREADSHEET_ID

envSPREADSHEET_ID

Resources