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 credentials

   Option 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:

Development

Project Structure

Running Tests

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

• Built on the Model Context Protocol

• Powered by Google Sheets API

• Designed for seamless AI-human collaboration