gogcli-mcp-sheets
Extended Google Sheets MCP server via gogcli — 35 tools: auth + 8 base Sheets + 22 extra dedicated Sheets tools.
- Source: github.com/chrischall/gogcli-mcp
Requirements
- gogcli installed and authenticated
- Node.js 18 or later
Setup
{
"mcpServers": {
"gogcli-sheets": {
"command": "npx",
"args": ["-y", "gogcli-mcp-sheets"],
"env": {
"GOG_ACCOUNT": "you@gmail.com"
}
}
}
}
Extra Sheets Tools
| Tool | What it does |
|---|---|
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 |
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 |
gog_sheets_number_format |
Set number format |
gog_sheets_read_format |
Read cell formatting |
gog_sheets_resize_columns |
Resize column widths |
gog_sheets_resize_rows |
Resize row heights |
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_set_links |
Set =HYPERLINK() cells in one call (batch) |
gog_sheets_snapshot |
Back up a whole spreadsheet before a risky edit |
gog_sheets_named_ranges_list |
List named ranges |
gog_sheets_named_ranges_get |
Get a named range |
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 |
Plus 5 auth tools and 8 base Sheets tools.