Maheshnath09/MCP-Server-based-Ai-Automation-hub

🤖 MCP Server based Ai Automation Hub

Your central command center for Notion & Google Workspace automation.

automation-hub is a powerful Model Context Protocol (MCP) server built with Python. It bridges the gap between your AI assistant and your productivity tools, allowing you to manage tasks, calendars, spreadsheets, and emails seamlessly.

🚀 Features

📝 Notion Integration

• add_notion_task: Create new pages/tasks in your Notion database with due dates and descriptions.
• get_notion_tasks: Retrieve and filter tasks directly from your database.

📅 Google Calendar

• create_calendar_event: Schedule meetings and reminders instantly.
• get_upcoming_events: Check your schedule for the next few days.

📊 Google Sheets

• add_google_sheet_row: Log data, expenses, or notes into any Google Sheet.
• read_google_sheet: Read data ranges for analysis.

📧 Gmail

• send_gmail: Send emails programmatically.
• get_unread_emails: Fetch summaries of your unread messages.

🛠️ Prerequisites

Before you begin, ensure you have the following:

1. Python 3.10+ installed.
2. uv package manager (recommended) or pip.
3. Google Cloud Project with the following APIs enabled:
   • Google Sheets API
   • Google Calendar API
   • Gmail API
4. Notion Integration created and shared with your database.

⚙️ Setup Guide

1. Clone & Install

Navigate to the project directory and install dependencies:

cd ai-automation-hub
uv sync

2. Configure Environment (.env)

Create a .env file in the root directory and add your Notion credentials:

NOTION_API_KEY=secret_your_notion_integration_token
NOTION_DATABASE_ID=your_database_id

3. Google Credentials (credentials.json)

Download your OAuth 2.0 Client ID JSON file from Google Cloud Console and save it as credentials.json in the root folder.

Note: The first time you run the server, a browser window will open asking you to log in to your Google account. This will generate a token.json file for future authentications.

🏃‍♂️ Usage

Run the MCP server using uv:

uv run src/main.py

Once running, you can connect this server to any MCP-compliant client (like Claude Desktop, Cursor, etc.) to give your AI superpowers! 🦸‍♂️

🧪 Testing

We've included an integration test script to verify everything is working:

uv run src/test_integration.py

This will:

1. ✅ Add a test task to Notion.
2. ✅ Fetch tasks from Notion.
3. ✅ Read upcoming Calendar events.
4. ✅ Create a test event on your Calendar.
5. ✅ Check for unread Gmails.

� Docker Support

You can also run automation-hub using Docker.

1. Build the Image

docker build -t automation-hub .

2. Run the Container

You need to mount your credentials and .env file into the container.

docker run -i --rm \
  -v ${PWD}/.env:/app/.env \
  -v ${PWD}/credentials.json:/app/credentials.json \
  -v ${PWD}/token.json:/app/token.json \
  automation-hub

Note: Ensure token.json exists before running in Docker, or run locally first to authenticate. The container runs in non-interactive mode by default for MCP, so interactive auth won't work inside Docker easily.

�📜 License

MIT License. Built with ❤️ for automation enthusiasts.