MCP Google Sheets Connection

The Google Sheets connection exposes 7 tools for searching, reading, writing, appending, renaming, and deleting Google Sheets.

Endpoint

https://mcp.porteden.com/google-sheets

Providers

Google Sheets (via Google Drive)

// Claude Desktop config 
{ 
  "mcpServers": { 
    "porteden-google-sheets": { 
      "url": "https://mcp.porteden.com/google-sheets" 
    } 
  } 
}

Tools (7)

Each tool is labelled with its access level. The user must grant the matching permission at my.porteden.com.

Tool	Access	Description
google_sheets_search	Read	Search Google Sheets across connected drives (pre-filtered to Sheets only).
google_sheets_get_metadata	Read	Get a spreadsheet's title, sheet names, and row/column counts. Call this first to discover sheet names.
google_sheets_read	Read	Read cell values for a range in A1 notation (e.g., Sheet1!A1:C10). Range max 200 characters.
google_sheets_write	Update	Write a 2-D array of values to a range. Max 10,000 cells per call. USER_ENTERED evaluates formulas; RAW stores literally.
google_sheets_append	Create	Append rows to the bottom of a sheet. Up to 5,000 rows per call.
google_sheets_rename	Update	Rename a Sheet file.
google_sheets_delete	Delete	Send a Sheet to trash. Recoverable by the owner.

The google_sheets_write tool supports two value input options:

USER_ENTERED — values are parsed as if typed into the Google Sheets UI (formulas are evaluated, dates are parsed)
RAW — values are stored exactly as provided (no formula evaluation)

Tip

Always call google_sheets_get_metadata first to discover sheet names and dimensions before reading or writing.

"Add these three rows to the sales tracker."

"Show me the first 10 rows of the budget spreadsheet."

"Update cell B5 in the forecast sheet to $12,000."

"Find all spreadsheets shared with the finance team."

Tool	Limit
google_sheets_search	Up to 100 results per page (default 25)
google_sheets_read	Range string max 200 characters
google_sheets_write	Up to 10,000 cells per call
google_sheets_append	Up to 5,000 rows per call

Permissions, quotas, troubleshooting, and FAQ.

File management tools for Google Drive.