Google Sheets API -- simple interface to read/write data and manage sheets
Most knowledge and memory work still happens through a UI a human drives. Google MCP server moves it into the conversation instead. 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
The server publishes 5 tools. What each one is for:
cell — based API - read, write, bulk-updates, formattingrow — based API - read, update, delete (based on the old v3 row-based calls)export — download sheet/docs in various formatsSponsors — The Sponsors tool exposed by this serverContributing — Contributions are welcome, but please follow the existing conventions, use the linter, add relevant tests, and add relevant documentationThe server ships on npm as google-spreadsheet, so your MCP client can launch it on demand — there is no separate build step. Add the server block to your client's configuration, restart it, and the tools register themselves.
Configuration is passed through the environment: GOOGLE_PRIVATE_KEY. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.
This sits in the knowledge and memory group, where several servers overlap in what they claim to do but differ sharply once you actually set them up. Google's toolset — cell, row, export and 2 more — is a fair guide to whether it matches your workflow. It is maintained by GitHub Actions; worth a glance at recent repository activity before you build anything load-bearing on it.
We check each listing at SyncDev against the project's documentation before it goes live — if something here drifts out of date, it is a bug worth reporting.
| 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 |
| Sponsors | The Sponsors tool exposed by this server. |
| Contributing | Contributions are welcome, but please follow the existing conventions, use the linter, add relevant tests, and add relevant documentation. |
{
"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 |
A knowledge graph your assistant keeps between sessions — entities, relations and observations that persist.
Kill hallucinated APIs — version-accurate, up-to-date library documentation injected straight into context.
Your workspace, on speaking terms with AI — search, read and write Notion pages and databases.
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.
Chat with your second brain — search, read and write vault notes through the Local REST API.