Weekly Report MCP

🚀 Weekly Report Checker MCP Server

An MCP (Model Context Protocol) server for checking the submission status of weekly reports in Google Sheets.

🚀 Quick Start

The Weekly Report Checker MCP Server is designed to streamline the process of monitoring weekly report submissions in Google Sheets. It offers a range of features to help you manage and track report submissions effectively.

✨ Features

• Check who has not submitted their weekly reports.
• Get detailed report status information for specific individuals.
• View submission statistics.
• List all team members who are supposed to submit reports.

📦 Installation

Prerequisites

• Python 3.10 or higher.
• Google Sheets service account JSON file (service_account.json).
• Access to the "週報" Google Sheet.

Installation Steps

# Install the package
pip install -e .

# Install on Claude Desktop
./install_server.sh
# Or
mcp install mcp_server.main --name "週報檢查器"

💻 Usage Examples

Basic Usage

# Run in development mode
./run_server.sh
# Or
mcp dev mcp_server.main

# Run directly
python -m mcp_server.main
# Or
weekly-report-server

Example Client

To run the example client:

python example_usage.py

📚 Documentation

API Reference

Resources

• weekly-report://status - Get people who haven't submitted their reports.
• weekly-report://stats - Get submission statistics.
• weekly-report://all-members - Get all team members who should submit reports.
• weekly-report://person/{name} - Get the report status of a specific person.

Tools

• check_missing_reports - Check for missing reports.
• check_person_report - Check the report of a specific person.
• get_submission_stats - Get submission statistics.