Google Sheet

A local MCP server for creating, reading, and updating Google Sheets.

Tools

• sheets_create_spreadsheet - create a new Google spreadsheet
• sheets_get_values - read a range from a sheet
• sheets_update_values - overwrite a range
• sheets_append_values - append rows
• sheets_clear_values - clear a range
• sheets_add_sheet - add a new tab
• sheets_paste_markdown_report - paste a markdown report as one line per row

Setup

1. Enable the Google Sheets API for the Google Cloud project.
2. Enable the Google Drive API if you want to create new spreadsheets.
3. Fill .env with your OAuth client values.
4. Generate a Sheets-scoped refresh token:

npm run auth

Open the printed Google URL, approve access, then copy the printed SHEETS_REFRESH_TOKEN into .env.

5. Install and build:

npm install
npm run build

Codex config

[mcp_servers.google-sheets]
command = "node"
args = ["/Users/sandeshsonabakhilari/Desktop/my-mcp/google-sheets-mcp/dist/index.js"]

The MCP reads credentials from /Users/sandeshsonabakhilari/Desktop/my-mcp/google-sheets-mcp/.env.

Example

Create a spreadsheet:

{
  "title": "Gmail Reports",
  "sheetTitle": "Read Mail Priority"
}

Paste a report:

{
  "spreadsheetId": "...",
  "range": "Read Mail Priority!A1",
  "markdown": "# Report...",
  "clearFirst": true
}