Weekly Report Checker MCP Server

An MCP (Model Context Protocol) server that checks weekly report submissions in a Google Sheet.

Features

• Check who hasn't submitted their weekly reports

• Get detailed information about a specific person's report status

• View submission statistics

• Get a list of all team members who should submit reports

Related MCP server: Cloud Monitoring API Server

Prerequisites

• Python 3.10 or higher

• A Google Sheets service account JSON file (service_account.json)

• Access to the "週報" Google Sheet

Installation

# Install the package
pip install -e .

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

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

Run the example client:

python example_usage.py

API Reference

Resources

• weekly-report://status - Get who hasn't submitted reports

• weekly-report://stats - Get submission statistics

• weekly-report://all-members - Get all team members

• weekly-report://person/{name} - Get a specific person's status

Tools

• check_missing_reports - Check missing reports

• check_person_report - Check a specific person's report

• get_submission_stats - Get submission statistics