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_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.