Google Sheets API -- simple interface to read/write data and manage sheets
Google Sheets API -- simple interface to read/write data and manage sheets
The following examples are meant to give you an idea of just some of the things you can do
Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.
Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.
| Tool | What it does |
|---|---|
| cell | based API - read, write, bulk-updates, formatting |
| row | based API - read, update, delete (based on the old v3 row-based calls) |
| export | download sheet/docs in various formats |
{
"mcpServers": {
"google-spreadsheet": {
"command": "npx",
"args": ["-y", "google-spreadsheet"],
"env": {
"GOOGLE_PRIVATE_KEY": "your-value"
}
}
}
}Add to claude_desktop_config.json, then restart Claude Desktop.
| Variable | Description | Required |
|---|---|---|
| GOOGLE_PRIVATE_KEY | Credential the server authenticates with. | Yes |
Store entities, relations and observations in a local knowledge graph with the reference Memory MCP server.
A structured scratchpad for hard problems — stepwise reasoning with revisions, branches and visible logic.
Symbol-level code navigation, refactoring and memory for coding agents — the IDE brain your assistant has been missing.
Stop letting your assistant hallucinate n8n node parameters — this server hands it the real schemas, templates and validation.
Chat with your second brain — search, read and write vault notes through the Local REST API.
Enables AI assistants to securely interact with Azure DevOps through a standardized protocol.