도구, 리소스 및 Google 시트 및 Google 양식과 작업을위한 신속한 간단한 MCP 서버.

특징

도구

• list_spreadsheets - Google 스프레드 시트 목록
• read_sheet - Google 시트에서 데이터를 읽으십시오
• write_sheet - Google 시트에 데이터를 쓰기
• append_sheet - Google 시트에 데이터 삭제
• create_spreadsheet - 새로운 스프레드 시트 만들기
• create_form - 새로운 Google 양식 만들기

자원

• sheet://{spreadsheet_id}/{range_name} - 리소스로 액세스 시트 데이터

# # # Prompts를

• analyze_sheet_data - 시트 데이터를 분석하기위한 템플릿
• create_report_template - 보고서 스프레드 시트 만들기위한 템플릿
• form_to_sheet - form-to-sheet 워크플로우 템플릿

설치

##1. 가상 환경 만들기

##2. 의존성 설치

##3. Google API Credentials 받기

1. Google Cloud 콘솔로 이동
2. 새로운 프로젝트를 만들거나 기존 하나를 선택
3. 다음 API를 사용:

• Google 시트 API
• Google 양식 API
• Google 드라이브 API

4. "Credentials"로 이동 → “Create Credentials” → “OAuth 클라이언트 ID”
5. 신청 유형으로 "Desktop app"를 선택하십시오
6. credentials JSON 파일을 다운로드
7. 이 디렉토리에서 credentials.json로 저장

Google Sheets & Forms MCP Server

A simple MCP server that provides tools, resources, and prompts for working with Google Sheets and Google Forms.

Features

Tools

• list_spreadsheets - List your Google Spreadsheets
• read_sheet - Read data from a Google Sheet
• write_sheet - Write data to a Google Sheet
• append_sheet - Append data to a Google Sheet
• create_spreadsheet - Create a new spreadsheet
• create_form - Create a new Google Form

Resources

• sheet://{spreadsheet_id}/{range_name} - Access sheet data as a resource

Prompts

• analyze_sheet_data - Template for analyzing sheet data
• create_report_template - Template for creating report spreadsheets
• form_to_sheet - Template for form-to-sheet workflow

Setup

1. Create virtual environment

cd gsheets-mcp-server
python -m venv .venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate

2. Install dependencies

pip install -r requirements.txt

3. Get Google API Credentials

1. Go to Google Cloud Console
2. Create a new project or select existing one
3. Enable the following APIs:
   • Google Sheets API
   • Google Forms API
   • Google Drive API
4. Go to “Credentials” → “Create Credentials” → “OAuth client ID”
5. Choose “Desktop app” as application type
6. Download the credentials JSON file
7. Save it as credentials.json in this directory

4. Test the server with MCP Inspector

npx @modelcontextprotocol/inspector python gsheets_server.py

Claude Desktop Configuration

Add this to your Claude Desktop config file:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "gsheets": {
      "command": "python",
      "args": [
        "/FULL/PATH/TO/gsheets-mcp-server/gsheets_server.py"
      ],
      "env": {
        "GOOGLE_CREDENTIALS_PATH": "/FULL/PATH/TO/gsheets-mcp-server/credentials.json"
      }
    }
  }
}

Important: Replace /FULL/PATH/TO/ with the actual absolute path to this directory.

First Run

On first run, the server will open a browser window for Google authentication. After you authorize the app, a token.pickle file will be created to store your credentials for future use.

Example Usage in Claude Desktop

Once configured, you can ask Claude:

• “List my spreadsheets”
• “Read the data from spreadsheet ID ‘abc123’ in range ‘Sheet1!A1:C10’”
• “Create a new spreadsheet called ‘Q1 Report’”
• “Append this data to my sheet: [[‘Name’, ‘Email’], [‘John’, ‘[email protected]’]]”
• “Use the analyze_sheet_data prompt”
• “Show me the sheet resource for spreadsheet ‘abc123’”

Getting Spreadsheet IDs

The spreadsheet ID is in the URL:

https://docs.google.com/spreadsheets/d/SPREADSHEET_ID_HERE/edit

Troubleshooting

• Authentication fails: Delete token.pickle and run again