Google Sheets Full MCP server

Read from the package source without running it. The installed server may list more.

• add_sheet

  Add a new tab (sheet) to the spreadsheet. Returns the new sheetId.

• append_values

  Append rows to the end of a table. The range is used as the search hint.

• auth_status

  Report the current auth configuration. Two modes: 'oauth' (default, interactive user account) or 'service_account' (GOOGLE_APPLICATION_CREDENTIALS env set, headless). Returns mode, expected file paths, and which files are present. Use to debug setup problems.

• batch_get_values

  Read multiple A1 ranges in one call.

• batch_updatewrite action

  Run a structural batchUpdate on the spreadsheet (add/delete sheets, formatting, merges, freeze, conditional formatting, etc.). 'requests' is the Google Sheets API batchUpdate request array. See https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request.

• batch_update_valueswrite action

  Update multiple A1 ranges in one call. Each item is { range, values }.

• clear_values

  Clear all values from one or more A1 ranges. Pass a single range or use ranges[].

• create_spreadsheetwrite action

  Create a new spreadsheet owned by the authenticated user. Returns the new spreadsheetId and URL.

• delete_columnswrite action

  Delete columns in range [start_index, end_index) (0-based, half-open).

• delete_rowswrite action

  Delete rows in range [start_index, end_index) (0-based, half-open).

• delete_sheetwrite action

  Delete a tab. Pass either sheet_id (gid) or sheet_name.

• duplicate_sheet

  Duplicate a tab within the same spreadsheet. Returns the new sheetId.

• format_cells

  Apply a CellFormat to a range. Pass a partial CellFormat object as 'format' (e.g. { backgroundColor: { red: 1 }, textFormat: { bold: true, fontSize: 12 }, horizontalAlignment: 'CENTER', numberFormat: { type: 'NUMBER', pattern: '#,##0.00' } }). Only the provided keys are updated. See https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/cells#CellFormat.

• get_spreadsheet

  Return spreadsheet metadata: title, list of sheets (tabs) with sheetId/title/index/gridProperties. Use this first when working on an unknown spreadsheet to discover tab names and gids. Set include_grid_data=true to also return cell data (large).

• get_values

  Read values from an A1 range (e.g. 'Sheet1!A1:D100'). Returns a 2D array of cell values.

• insert_columnswrite action

  Insert N empty columns starting at start_index (0-based).

• insert_rowswrite action

  Insert N empty rows starting at start_index (0-based, half-open: rows [start_index, start_index+count) are inserted).

• list_spreadsheets

  List Google Sheets files in the user's Drive (most-recently-modified first). Returns id, name, modifiedTime, webViewLink. Use this when the user mentions a sheet by name without giving the ID.

• merge_cells

  Merge a cell range. merge_type controls how: MERGE_ALL (default), MERGE_COLUMNS (merge each column), MERGE_ROWS (merge each row).

• rename_sheet

  Rename a tab.

• resolve_url

  Parse a Google Sheets URL and extract spreadsheetId and gid (tab id). Convenience helper so the user can paste a URL and the caller can grab the IDs.

• run_sheets_scriptwrite action

  Escape hatch: execute an arbitrary Node.js script with full Google Sheets/Drive access. Use when no dedicated tool covers the operation, or when multiple coordinated calls are needed. The script runs in a fresh Node process with these globals already prepared: `sheets` (Sheets v4 client), `drive` (Drive v3 client), `google` (googleapis namespace), `auth` (OAuth2Client), `spreadsheetId` (string). U

• search_spreadsheets

  Search spreadsheets in the user's Drive by name (substring, case-insensitive) and/or full-text content. At least one of `name_contains` or `full_text` is required. Use this when the user refers to a sheet by part of its title.

• set_borders

  Set borders on a range. Pass per-side Border objects in 'borders' (top/bottom/left/right/innerHorizontal/innerVertical). Each Border = { style: 'SOLID'|'DOTTED'|'DASHED'|'SOLID_MEDIUM'|'SOLID_THICK'|'DOUBLE'|'NONE', color?: { red,green,blue,alpha } }.

• unmerge_cells

  Unmerge all merges within the given cell range.

• update_valueswrite action

  Write a 2D array of values into an A1 range. Use value_input_option='USER_ENTERED' to evaluate formulas, 'RAW' to write literal strings.

• Code scan4 source files scanned25/25
• –Live reliabilityno gateway calls yet and no remote to proben/a
• –Tool poisoningtools not inspected (local package is not executed); not countedn/a
• Auth qualitylocal package, no credentials required12/15
• Maintenancelast push 128 days ago8/15
• Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10

Safety score

82/100

higher than 58% of 1,299 Productivity servers

Tools

26

the typical Productivity server has 7

Tools that change things

38%

typical: 0%. Fewer write tools means less an agent can break

Downloads a week

92

more than 54% of 427 Productivity servers with a package

Google Sheets Full: common questions

Is Google Sheets Full MCP server safe?

Mostly: it is graded B (82/100). Read the Google Sheets Full safety report

How do I install Google Sheets Full?

It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.

Does Google Sheets Full need an API key?

Not as far as the registry entry and our scan can tell: no credentials are declared or required.

Is Google Sheets Full maintained?

The last commit was 165 days ago (2026-05-23). The latest release is v0.2.0.

What can I use instead of Google Sheets Full?

Servers from other publishers that do the same job: Gsheets MCP server, Sheets MCP server and Google Calendar MCP server.

How does Google Sheets Full compare with other Productivity MCP servers?

safety score 82/100 (higher than 58% of 1,299 Productivity servers); tools 26 (the typical Productivity server has 7); tools that change things 38% (typical: 0%. Fewer write tools means less an agent can break). Full comparison.