MCP Gsheets
未申請MCP server for Google Sheets - Read, write and manipulate spreadsheets through Claude Desktop
インストール
claude mcp add mcp-gsheets npx mcp-gsheets@latestAutomationの他のサーバー
ディレクトリ全体を見る未申請リスティング
このMCPサーバーはあなたのものですか？
このリスティングは公開情報から自動的にインデックスされました。申請することで、ページの編集、互換性の設定、成長ツールのアンロックができます。2分以内に完了します。
このサーバーを申請するセキュリティプロファイル
申請済みおよび認証済みのサーバーは毎週の静的スキャンを受け、コードが到達できる範囲（外部サービス、環境変数、シェルコマンド、エージェント設定フォルダ）と既知のアドバイザリを持つ依存関係が表示されます。このリスティングを申請すると利用できます。 セキュリティプロファイルの仕組み
40 件中 40 件
ドキュメントに記載されたツール (40)
プロジェクトのドキュメントに基づきます。サーバーのハンドシェイクは、各ツールの説明や動作を検証するものではありません。
sheets_add_conditional_formatting
Add a conditional formatting rule (gradient or boolean) to a range
sheets_add_table
Create a native Google Sheets table with typed columns and optional dropdown values
sheets_append_values
Append rows after the last row of an existing table. Default insertDataOption is OVERWRITE — set INSERTROWS to push existing rows down
sheets_batch_delete_sheets
Delete multiple sheet tabs in one request
sheets_batch_format_cells
Apply different formats to multiple ranges in one request
sheets_batch_get_values
Read cell values from multiple ranges in one request
sheets_batch_update_values
Write values to multiple ranges in one request
sheets_check_access
Verify that the service account can access a spreadsheet
sheets_clear_values
Clear all values in a range (preserves formatting)
sheets_copy_to
Copy a sheet to a different spreadsheet
sheets_create_chart
Create a bar, line, pie, column or other chart on a sheet
sheets_create_spreadsheet
Create a new Google Sheets file
sheets_delete_chart
Remove a chart from a spreadsheet
sheets_delete_columns
Delete one or more columns using a full-column A1 range
sheets_delete_rows
Delete one or more rows using a full-row A1 range
sheets_delete_sheet
Remove a sheet tab by its numeric sheet ID
sheets_delete_table
Delete a native Google Sheets table by table ID
sheets_duplicate_sheet
Copy a sheet within the same spreadsheet
sheets_format_cells
Apply background colour, font style, alignment and number format to a range
sheets_get_conditional_formatting
Read all conditional formatting rules and banded (alternating-colour) ranges defined on a sheet
sheets_get_formatting_compact
Read cell formatting for a range and return it as compact A1Range→format pairs (run-length encoded). Identical adjacent cells are collapsed into rectangular ranges — reduces output by 90 %+ compared to per-cell data
sheets_get_full_sheet_snapshot
Master one-shot tool — returns all structural and formatting metadata (merges, dimensions, conditional formatting, and optionally cell formatting) in a single API call. Supports fields filter and compactMode to limit response size
sheets_get_merged_cells
Return all merged cell ranges for a sheet, with A1 notation and raw GridRange coordinates
sheets_get_metadata
Get spreadsheet metadata: title, locale, sheets list with IDs, row/column counts
sheets_get_sheet_dimensions
Return column widths, row heights, frozen column/row counts, and hidden flags for every column and row
sheets_get_sheet_formatting
Read raw cell formatting (background colour, font, borders, alignment, number format) for a range without returning cell values
sheets_get_sheet_structure
Lightweight structural metadata only — no per-cell data. Returns dimensions, frozen rows/cols, tab colour, column widths, row heights, hidden columns/rows, and all merges in A1 notation. Single fast API call
sheets_get_tables
Read native tables for a spreadsheet or a specific sheet
sheets_get_values
Read cell values from a single range
sheets_insert_date
Insert a date/datetime value formatted correctly into a cell
sheets_insert_link
Insert a hyperlink formula into a cell
sheets_insert_rows
Insert blank or pre-filled rows at a specific position
sheets_insert_sheet
Add a new sheet tab to an existing spreadsheet
sheets_merge_cells
Merge a range of cells
sheets_unmerge_cells
Unmerge previously merged cells in a range
sheets_update_borders
Set or remove borders on a range (style, width, colour per side)
sheets_update_chart
Modify an existing chart's spec or position
sheets_update_sheet_properties
Rename a sheet, change tab colour, toggle grid lines, etc.
sheets_update_table
Update an existing native Google Sheets table by table ID using an explicit field mask
sheets_update_values
Write values to a single range (overwrites existing content)