Extended Google Sheets MCP server via gogcli — 35 tools: auth + 8 base Sheets + 22 extra dedicated Sheets tools.
{
"mcpServers": {
"gogcli-sheets": {
"command": "npx",
"args": ["-y", "gogcli-mcp-sheets"],
"env": {
"GOG_ACCOUNT": "you@gmail.com"
}
}
}
}
| 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.
共 9 个版本