open-index/open-npm huggingface dataset:
npm package: @iflow-mcp/mkummer225-google-sheets-mcp
Description: MCP server for interacting with Google Sheets
Author: Cardinal Machine Intelligence
Latest version: 0.0.1

# Google Sheets MCP

A Model Context Protocol (MCP) connector for Google Sheets that allows AI agents to interact with spreadsheets directly.

## Demo

https://github.com/user-attachments/assets/cc4729d9-4e6e-437b-848b-6da9a09418c3

## Setup

1. Clone this repository:
```bash
git clone https://github.com/mkummer225/google-sheets-mcp
cd google-sheets-mcp
```


2. Install dependencies:
`npm install`


3. Build:
`npm run build`


4. Create OAuth credentials in Google Cloud Platform:
   - Create a new project in [Google Cloud Console](https://console.cloud.google.com/)
   - Enable the [Google Sheets API](https://console.cloud.google.com/marketplace/product/google/sheets.googleapis.com)
   - Configure the OAuth consent screen
   - Create OAuth client ID credentials (Desktop application) with an appropriate redirect URI (ex: http://localhost:3000/oauth2callback)
   - Download the credentials and save as `gcp-oauth.keys.json` in the `dist` subdirectory


5. Start the MCP server (you'll automatically be prompted to authenticate/re-authenticate your Google account when necessary):
`npm run start`


## Usage

Sample config:
```json
{
    "mcpServers": {
    "google-sheets-mcp": {
      "command": "node",
      "args": [
        "/{path_to_dir}/google-sheets-mcp/dist/index.js"
      ]
    }
  }
}
```

Then you should be able to simply specify your spreadsheetId or ask your agent to create a new one for you.

## Available Actions

| Action | Description |
|--------|-------------|
| `refresh_auth` | Re-authenticate your Google Account when credentials expire |
| `list_sheets` | List all sheets/tabs in a Google Spreadsheet |
| `create_sheet` | Create a new sheet/tab in a Google Spreadsheet |
| `create_spreadsheet` | Create a new Google Spreadsheet |
| `read_all_from_sheet` | Read all data from a specified sheet |
| `read_headings` | Read the column headings from a sheet |
| `read_rows` | Read specific rows from a sheet |
| `read_columns` | Read specific columns from a sheet |
| `edit_cell` | Edit a single cell in a sheet |
| `edit_row` | Edit an entire row in a sheet |
| `edit_column` | Edit an entire column in a sheet |
| `insert_row` | Insert a new row at specified position |
| `insert_column` | Insert a new column at specified position |
| `rename_sheet` | Rename a sheet/tab in a spreadsheet |
| `rename_doc` | Rename a Google Spreadsheet |


## License

MIT
npm package: @iflow-mcp/model-hub-mcp
Description: MCP server for fetching AI models from OpenAI, Anthropic, and Google
Latest version: 0.1.7

# model-hub-mcp

[日本語版 README](./README.ja.md)

An MCP (Model Context Protocol) server that fetches AI model information from OpenAI, Anthropic, and Google.

## Features

- **Multi-provider Support**: Supports three providers - OpenAI, Anthropic, and Google AI
- **List Models**: Retrieve a list of available models from each provider
- **Get Model Details**: Fetch detailed information about specific models
- **Unified Retrieval**: Batch fetch model information from all configured providers

## Quick Start (npx)

```bash
# Run with environment variables
OPENAI_API_KEY=your_key npx @akiojin/model-hub-mcp
```

Note: The package will be downloaded from npm on first run.

## Installation

### Global Installation

```bash
npm install -g @akiojin/model-hub-mcp
```

### Local Installation

```bash
npm install @akiojin/model-hub-mcp
```

## Configuration

1. Copy `.env.example` to `.env`:

```bash
cp .env.example .env
```

1. Set API keys for each provider in the `.env` file:

```bash
OPENAI_API_KEY=your_openai_api_key_here
ANTHROPIC_API_KEY=your_anthropic_api_key_here
GOOGLE_API_KEY=your_google_api_key_here
```

Note: You can leave API keys empty for providers you don't plan to use.

## Build

Compile TypeScript code:

```bash
npm run build
```

## Usage

This MCP server is not meant to be run directly. It should be configured in your MCP client configuration.

See the "MCP Client Configuration Examples" section below for setup instructions.

## Available Tools

### list_models

Retrieve a list of available models from a specific provider.

Parameters:

- `provider`: "openai" | "anthropic" | "google"

### get_model

Fetch detailed information about a specific model.

Parameters:

- `provider`: "openai" | "anthropic" | "google"
- `model_id`: Model ID (e.g., "gpt-4", "claude-3-opus", "gemini-pro")

### list_all_models

Batch fetch model information from all configured providers.

## MCP Client Configuration Examples

### Claude Code

You can easily add this MCP server to Claude Code using the following command:

```bash
claude mcp add model-hub -s user \
  -e GOOGLE_API_KEY=$GEMINI_API_KEY \
  -e OPENAI_API_KEY=$OPENAI_API_KEY \
  -e ANTHROPIC_API_KEY=$ANTHROPIC_API_KEY \
  -- npx -y @akiojin/model-hub-mcp
```

This command assumes you have environment variables set in your shell:

- `$GEMINI_API_KEY` - Your Google AI API key
- `$OPENAI_API_KEY` - Your OpenAI API key
- `$ANTHROPIC_API_KEY` - Your Anthropic API key

### Using npx

```json
{
  "mcpServers": {
    "model-hub": {
      "command": "npx",
      "args": ["@akiojin/model-hub-mcp"],
      "env": {
        "OPENAI_API_KEY": "your_openai_api_key",
        "ANTHROPIC_API_KEY": "your_anthropic_api_key",
        "GOOGLE_API_KEY": "your_google_api_key"
      }
    }
  }
}
```

## License

MIT