gogcli-mcp-sheets

[!WARNING] AI-developed project. This codebase was built and is actively maintained by Claude Code. Review all code and tool permissions before use.

Extended Google Sheets MCP server via gogcli. Includes auth tools plus 55 additional dedicated Sheets tools for tab management, formatting, named ranges, Connected Sheets, and more.

Requirements

• gogcli installed and authenticated
• Node.js 22+

brew install gogcli
gog auth add [email protected] --services sheets

Installation

npm install -g gogcli-mcp-sheets

Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "gogcli-sheets": {
      "command": "gogcli-mcp-sheets",
      "env": {
        "GOG_ACCOUNT": "[email protected]"
      }
    }
  }
}

Claude Code

claude mcp add gogcli-sheets -- gogcli-mcp-sheets

Extra Sheets Tools (59)

Plus 8 auth tools and 8 base Sheets tools (get, update, append, clear, metadata, create, find-replace, run) — 75 in all.

| Tool | Description | |------|-------------| | gog_sheets_add_tab | Add a new sheet tab | | gog_sheets_delete_tab | Delete a sheet tab | | gog_sheets_rename_tab | Rename a sheet tab | | gog_sheets_copy | Copy a sheet to another spreadsheet | | gog_sheets_export | Export as CSV, TSV, XLSX, PDF, ODS, or HTML | | gog_sheets_freeze | Freeze rows and/or columns | | gog_sheets_insert | Insert rows or columns | | gog_sheets_merge | Merge cells | | gog_sheets_unmerge | Unmerge cells | | gog_sheets_format | Apply cell formatting (bold, color, etc.) | | gog_sheets_number_format | Set number format (currency, percent, date, etc.) | | gog_sheets_read_format | Read cell formatting | | gog_sheets_resize_columns | Resize column widths or auto-fit | | gog_sheets_resize_rows | Resize row heights or auto-fit | | gog_sheets_named_ranges_list | List named ranges | | gog_sheets_named_ranges_get | Get a named range by name or ID | | gog_sheets_named_ranges_add | Create a named range | | gog_sheets_named_ranges_update | Update a named range | | gog_sheets_named_ranges_delete | Delete a named range | | gog_sheets_notes | Read cell notes | | gog_sheets_update_note | Add or update cell notes | | gog_sheets_links | List hyperlinks in a range | | gog_sheets_links_set | Set =HYPERLINK() cells in one call (batch) | | gog_sheets_snapshot | Back up a whole spreadsheet before a risky edit | | gog_sheets_datasource_list | List Connected Sheets data sources (BigQuery / Looker) with sheet + execution status | | gog_sheets_datasource_describe | Full data-source spec, including its query, status and refresh schedules | | gog_sheets_datasource_table_list | List anchored data-source tables (extracts) and their A1 anchors | | gog_sheets_datasource_table_describe | Describe the extract anchored at an A1 cell | | gog_sheets_datasource_table_read | Read a bounded number of rows out of an extract | | gog_sheets_datasource_add | Add a BigQuery Connected Sheets data source (custom SQL or a native table) | | gog_sheets_datasource_update | Repoint a data source's SQL, table or billing project | | gog_sheets_datasource_refresh | Re-run a data source so its sheet and extracts pick up current data | | gog_sheets_datasource_delete | Delete a data source, its linked sheet, and unlink dependent objects | | gog_sheets_list_tabs | List tabs in a spreadsheet (sheetId, title, index, gridProperties) | | gog_sheets_copy_paste | Copy a range's values/formulas/format to another range (tiles to fill down/across). | | gog_sheets_validation_get | Read data-validation rules (dropdowns, checkboxes, conditions) on a range. | | gog_sheets_validation_set | Set a data-validation rule on a range: dropdowns, checkboxes, number/date conditions, or custom formulas. | | gog_sheets_validation_clear | Remove all data-validation rules from a range. | | gog_sheets_delete_dimension | Delete a row or column span, table-aware: intersecting tables are shrunk and their remaining data preserved. | | gog_sheets_batch_update | Update values in multiple ranges atomically with one Sheets API request. | | gog_sheets_reorder_tab | Move a tab to a specific 0-based position. | | gog_sheets_chart_list | List embedded charts in a spreadsheet. | | gog_sheets_chart_get | Get a chart's full definition (spec + position) by chart ID. | | gog_sheets_chart_create | Create an embedded chart from a JSON ChartSpec. | | gog_sheets_chart_update | Replace a chart's spec by chart ID. | | gog_sheets_chart_delete | Delete a chart by chart ID. | | gog_sheets_table_list | List Google Sheets tables in a spreadsheet. | | gog_sheets_table_get | Get a Google Sheets table by table ID. | | gog_sheets_table_create | Create a Google Sheets table over a range with typed columns. | | gog_sheets_table_append | Append data rows to a table. | | gog_sheets_table_clear | Clear all data rows from a table. | | gog_sheets_table_delete | Delete a Google Sheets table. By default preserves the table's cell values and formulas (emulates "Convert to range"); set keep_data=false to also wipe the data. | | gog_sheets_banding_list | List alternating-color banded ranges. | | gog_sheets_banding_set | Apply alternating colors to a range. | | gog_sheets_banding_clear | Remove alternating-color banding by ID or for a whole sheet. | | gog_sheets_filter_set | Set a basic filter on a range; replacing an existing filter requires replace=true. | | gog_sheets_conditional_format_list | List conditional formatting rules. | | gog_sheets_conditional_format_add | Add a conditional formatting rule to a range (boolean or gradient). | | gog_sheets_conditional_format_clear | Remove conditional formatting rules from a sheet. |

License

MIT