Skip to content
MCP server

MCP Google Sheets Import Export

MCP server to read Google Sheets into rows or write rows back with append, replace

Runs locally
Install

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-export

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

How AIPoweredBot checks servers