Google Sheets & FormsBLOCK

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:
4. Google Sheets API
5. Google Forms API
6. Google Drive API
7. Go to "Credentials" → "Create Credentials" → "OAuth client ID"
8. Choose "Desktop app" as application type
9. Download the credentials JSON file
10. 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-