Skip to main content
Glama

Brainstorm MCP

by hellovarun91
GitHub
Python
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Brainstorm MCP

An MCP (Model Context Protocol) server that connects Claude to Google Sheets for enhanced brainstorming and structured data output. This server enables seamless integration between AI-powered conversations and Google Sheets, making it easy to capture, organize, and manipulate brainstorming sessions directly within spreadsheets.

Features

  • Google Sheets Integration: Direct read/write access to Google Sheets from Claude
  • Structured Brainstorming: Organize ideas and outputs in structured spreadsheet format
  • Real-time Collaboration: Leverage Google Sheets' collaborative features for team brainstorming
  • MCP Protocol: Built on the standardized Model Context Protocol for seamless AI integration
  • Flexible Data Management: Create, read, update, and delete spreadsheet data programmatically

Installation

Prerequisites

  • Python 3.8 or higher
  • Google Cloud Platform account with Sheets API enabled
  • Google API credentials (Service Account or OAuth2)

Setup

  1. Clone the repository
    git clone <repository-url> cd brainstorm-mcp
  2. Install dependencies
    pip install -r requirements.txt
  3. Configure Google API credentialsOption A: Service Account (Recommended)
    • Create a service account in Google Cloud Console
    • Download the JSON credentials file
    • Save as credentials.json in the project root
    • Share your Google Sheets with the service account email

    Option B: OAuth2

    • Create OAuth2 credentials in Google Cloud Console
    • Download the client secret JSON file
    • Follow the OAuth2 flow during first run
  4. Start the MCP server
    python server.py

Usage

Basic Operations

The MCP server provides several tools for Google Sheets interaction:

  • Read Sheets: Extract data from existing spreadsheets
  • Write Data: Add new rows and update existing cells
  • Create Sheets: Generate new spreadsheets programmatically
  • Format Data: Apply formatting and structure to sheet content

Example Workflow

  1. Start a brainstorming session with Claude
  2. Use natural language to describe your ideas
  3. Claude automatically structures and saves content to Google Sheets
  4. Collaborate with team members through Google Sheets interface
  5. Continue iterating and refining ideas with AI assistance

MCP Client Configuration

Add this server to your MCP client configuration:

{ "mcpServers": { "brainstorm-mcp": { "command": "python", "args": ["path/to/brainstorm-mcp/server.py"], "env": { "GOOGLE_APPLICATION_CREDENTIALS": "path/to/credentials.json" } } } }

Development

Project Structure

brainstorm-mcp/ ├── server.py # Main MCP server implementation ├── tools/ │ ├── sheets_tools.py # Google Sheets API integration │ ├── image_tools.py # Image processing utilities │ └── __init__.py ├── google_auth.py # Google API authentication ├── requirements.txt # Python dependencies ├── test_sheets.py # Test suite └── README.md

Running Tests

python test_sheets.py

Contributing

  1. Fork the repository
  2. Create a feature branch (git checkout -b feature/amazing-feature)
  3. Commit your changes (git commit -m 'Add amazing feature')
  4. Push to the branch (git push origin feature/amazing-feature)
  5. Open a Pull Request

Known Limitations

  • Column Targeting: Current implementation has limitations with precise column targeting that will be addressed in future updates
  • Batch Operations: Limited support for bulk operations (planned enhancement)
  • Error Handling: Some edge cases in API error handling need refinement

Future Enhancements

Sheet2Figma Integration

  • Figma Plugin Compatibility: Enhanced integration with Sheet2Figma workflows
  • Design Token Support: Direct export of design tokens from sheets to Figma
  • Component Mapping: Automated mapping between sheet data and Figma components

Performance Improvements

  • Column Targeting Fix: Resolve current column targeting limitations
  • Batch Processing: Implement efficient batch operations for large datasets
  • Caching Layer: Add intelligent caching for frequently accessed sheets

Advanced Features

  • Template System: Pre-built templates for common brainstorming formats
  • Data Validation: Enhanced data validation and type checking
  • Workflow Automation: Automated workflows for common brainstorming patterns
  • Multi-format Export: Support for exporting to various formats (CSV, JSON, etc.)

API Reference

Available Tools

  • read_sheet(spreadsheet_id, range): Read data from a specific sheet range
  • write_to_sheet(spreadsheet_id, range, values): Write data to sheet
  • create_spreadsheet(title): Create a new Google Spreadsheet
  • get_sheet_info(spreadsheet_id): Retrieve spreadsheet metadata

License

This project is licensed under the MIT License - see the LICENSE file for details.

Support

For questions, issues, or contributions, please:

  • Open an issue on GitHub
  • Check existing documentation
  • Review the test suite for usage examples

Acknowledgments

This server cannot be installed

-
security - not tested
F
license - not found
-
quality - not tested

How are these scores calculated?

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

An MCP server that connects Claude to Google Sheets for enhanced brainstorming and structured data output, enabling seamless capture, organization, and manipulation of ideas directly within spreadsheets.

  1. Features
    1. Installation
      1. Prerequisites
      2. Setup
    2. Usage
      1. Basic Operations
      2. Example Workflow
      3. MCP Client Configuration
    3. Development
      1. Project Structure
      2. Running Tests
      3. Contributing
    4. Known Limitations
      1. Future Enhancements
        1. Sheet2Figma Integration
        2. Performance Improvements
        3. Advanced Features
      2. API Reference
        1. Available Tools
      3. License
        1. Support
          1. Acknowledgments

            Related MCP Servers

            • Salesforce MCP Server

              tsmztech
              A
              security
              A
              license
              A
              quality
              An MCP server implementation that integrates Claude with Salesforce, enabling natural language interactions with Salesforce data and metadata for querying, modifying, and managing objects and records.
              Last updated -
              7
              615
              75
              TypeScript
              MIT License

            • Choose MCP Server

              keurcien
              -
              security
              F
              license
              -
              quality
              An MCP server for Claude Desktop that allows users to query data from selected Google Cloud datasets by configuring project ID and datasets in the Claude Desktop configuration.
              Last updated -
              Python
              • Apple

            • Salesforce MCP Server

              SurajAdsul
              A
              security
              A
              license
              A
              quality
              An MCP server implementation that integrates Claude with Salesforce, enabling natural language interactions with Salesforce data and metadata for querying, modifying, and managing objects and records.
              Last updated -
              7
              383
              12
              TypeScript
              MIT License
              • Apple
              • Linux

            • Google Drive MCP Server

              rishipradeep-think41
              -
              security
              A
              license
              -
              quality
              This MCP server integrates with Google Drive to allow listing, reading, and searching files, as well as the ability to read and write to Google Sheets.
              Last updated -
              695
              2
              JavaScript
              MIT License

            View all related MCP servers

            New MCP Servers

            MCP directory API

            We provide all the information about MCP servers via our MCP API.

            curl -X GET 'https://glama.ai/api/mcp/v1/servers/hellovarun91/brainstorm-mcp'

            If you have feedback or need assistance with the MCP directory API, please join our Discord server