MCP Google Sheets Import Export
MCP server to read Google Sheets into rows or write rows back with append, replace
MCP Google Sheets Import Export is a freemium MCP server for mcp data access. It runs locally on your machine and is started by your AI client.
- Pricing
- Freemium
- Platforms
- API, CLI, Self-hosted
- Runs
- Locally
- Version
- 1.0.2
- Listing updated
Similar MCP servers
Install
Run in a terminal
claude mcp add mcp-google-sheets-import-export --env APIFY_TOKEN='<APIFY_TOKEN>' -- npx -y @mambalabsdev/mcp-google-sheets-import-exportAdd to claude_desktop_config.json
{
"mcpServers": {
"mcp-google-sheets-import-export": {
"command": "npx",
"args": [
"-y",
"@mambalabsdev/mcp-google-sheets-import-export"
],
"env": {
"APIFY_TOKEN": "<APIFY_TOKEN>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"mcp-google-sheets-import-export": {
"command": "npx",
"args": [
"-y",
"@mambalabsdev/mcp-google-sheets-import-export"
],
"env": {
"APIFY_TOKEN": "<APIFY_TOKEN>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"mcp-google-sheets-import-export": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@mambalabsdev/mcp-google-sheets-import-export"
],
"env": {
"APIFY_TOKEN": "<APIFY_TOKEN>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"mcp-google-sheets-import-export": {
"command": "npx",
"args": [
"-y",
"@mambalabsdev/mcp-google-sheets-import-export"
],
"env": {
"APIFY_TOKEN": "<APIFY_TOKEN>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"mcp-google-sheets-import-export": {
"command": "npx",
"args": [
"-y",
"@mambalabsdev/mcp-google-sheets-import-export"
],
"env": {
"APIFY_TOKEN": "<APIFY_TOKEN>"
}
}
}
}Using several servers? Build one config file with the MCP config generator.
Configuration
APIFY_TOKENApify API token from https://console.apify.com/account/integrationsRequired
About MCP Google Sheets Import Export
This server gives an MCP client a single tool for moving data between Google Sheets and Apify. Reads return one row per sheet row, keyed by the header row, while write modes push items from an Apify dataset or a list of rows into a tab.
Writes can add rows after the last row, replace a tab's contents, or upsert by a key column so existing rows are overwritten in place and new ones are appended. New columns are added to the header as they appear. Access uses your own Google service account key or OAuth token, and a sheet shared as anyone with the link can be read without a credential.
The processing runs on an Apify actor; the package starts the run, waits for it, and returns the dataset rows. It suits people building lead lists or data pipelines who want an assistant to keep a spreadsheet in sync with scraped or generated data.
Tools this server provides (1)
Taken from the project documentation; the running server may differ.
- google_sheets_import_export
- Reads a Google Sheet into rows or writes rows to it in append, replace, or upsert mode.
What it does
- Read sheets as rows
- Returns each sheet row as an object keyed by the header row, with an optional A1 range.
- Append, replace, or upsert
- Supports three write modes, including upsert that updates rows matching a key column.
- Automatic header expansion
- New columns are added to the sheet header as new fields appear in the data.
- Own Google credentials
- Authenticates with your service account key or your own OAuth token and refresh token.
- Formula-safe writes
- Raw value input stores text beginning with an equals sign as plain text by default.
- Apify-backed execution
- Runs the work as an Apify actor and returns the resulting dataset rows to the client.
Good for
- Import a shared Google Sheet into an assistant as JSON for analysis
- Append scraped leads to an existing spreadsheet while matching its columns
- Update contact rows by email and add any new ones in one pass
- Replace a tab's contents with fresh export results from an Apify run
Pricing
Freemium
Pay-per-event on Apify; per-block charges for rows read and written, plus a per-run start fee
MCP Google Sheets Import Export FAQ
Do I need a Google credential to read a sheet?
No. A sheet shared as anyone with the link reads without a credential. Write modes need a service account key or an OAuth token.
What do I need to run the server?
Node.js 18 or newer and an Apify API token set as APIFY_TOKEN.
How is data written when a row already exists?
In upsert mode, rows whose key column value is already in the sheet are overwritten in place and the rest are added.
How is usage billed?
Usage is billed per event on Apify to your Apify account, with per-block charges for rows written and read plus a small per-run start fee.
Is MCP Google Sheets Import Export free?
MCP Google Sheets Import Export has a free plan, with paid plans for more usage or features.
How do I add MCP Google Sheets Import Export to Claude Code?
Run this command in your terminal: claude mcp add mcp-google-sheets-import-export --env APIFY_TOKEN='<APIFY_TOKEN>' -- npx -y @mambalabsdev/mcp-google-sheets-import-export
What are the best alternatives to MCP Google Sheets Import Export?
The closest alternatives to MCP Google Sheets Import Export are Google Sheets Import and Export for Apify, Google Sheets MCP Server and Excel MCP.
Where this comes from
- Description: written from the project's README and its MCP Registry entry.
- Install steps: from the official MCP Registry entry.