Weekly Report Checker MCP Server
An MCP server that checks weekly report submissions in a Google Sheet
What is Weekly Report Checker MCP Server?
The Weekly Report Checker MCP Server is an MCP (Model Context Protocol) server designed to check weekly report submissions in a Google Sheet.
How to use Weekly Report Checker MCP Server?
To use the server, install the package and run it in development mode or directly using Python. Ensure you have the necessary prerequisites, including Python 3.10 or higher and a Google Sheets service account JSON file.
Key features of Weekly Report Checker MCP Server?
- Checks who hasn't submitted their weekly reports.
- Provides detailed information about a specific person's report status.
- Displays submission statistics.
- Lists all team members who should submit reports.
Use cases of Weekly Report Checker MCP Server?
- Monitoring weekly report submissions in a team.
- Identifying team members who are lagging in report submissions.
- Analyzing submission statistics for performance reviews.
FAQ from Weekly Report Checker MCP Server?
- What are the prerequisites for using the server?
You need Python 3.10 or higher and a Google Sheets service account JSON file.
- How do I install the Weekly Report Checker MCP Server?
You can install it using pip and run the installation script provided in the documentation.
- Can I run the server directly?
Yes, you can run the server directly using Python or through the provided command.
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
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 reportsweekly-report://stats- Get submission statisticsweekly-report://all-members- Get all team membersweekly-report://person/{name}- Get a specific person's status
Tools
check_missing_reports- Check missing reportscheck_person_report- Check a specific person's reportget_submission_stats- Get submission statistics
