home / mcp / weekly report checker mcp server
Provides status, statistics, and membership data for weekly Google Sheet submissions via MCP endpoints.
Configuration
View docs{
"mcpServers": {
"kaneyxx-weekly-report-mcp": {
"command": "python",
"args": [
"-m",
"mcp_server.main"
]
}
}
}This MCP server lets you monitor weekly report submissions stored in a Google Sheet. It exposes endpoints to see who hasn’t submitted, view individual statuses, review overall statistics, and list all team members who are expected to submit. You can run the server locally for development or deploy it as a reusable MCP service in your environment.
You interact with the Weekly Report Checker MCP Server through an MCP client. Use the available resources to check missing submissions, fetch a specific person’s status, view aggregate statistics, or list all team members who should submit reports. Each resource is accessible with a dedicated endpoint, enabling you to build dashboards or automations that track weekly reporting compliance.
Key endpoints you’ll use include accessing who hasn’t submitted reports, getting statistics, listing all team members, and querying a single person’s status. Use these to drive reminders, reports, or notifications for your team.
{
"steps": [
"Prerequisites: Python 3.10 or higher, a Google Sheets service account JSON file named service_account.json, and access to the 週報 Google Sheet.",
"Install the package in editable mode:",
"pip install -e .",
"Install the MCP server tooling (optional for Claude Desktop):",
"./install_server.sh",
"mcp install mcp_server.main --name \"週報檢查器\"",
"Run the server in development mode:",
"./run_server.sh",
"or",
"mcp dev mcp_server.main",
"Run directly without MCP wrapper:",
"python -m mcp_server.main",
"or",
"weekly-report-server"
]
}Security and access: The server relies on a Google Sheets service account to read the 週報 sheet. Ensure the service account has access to the sheet and keep the service_account.json file securely stored in your environment.
Environment and prerequisites: Place the service account JSON at the expected path and ensure Python 3.10+ is installed. You will typically run the server from your project directory and expose it to your MCP network using your chosen runtime (docs below show common options).
Troubleshooting tips: If the server fails to start, verify Python version, confirm the Google Sheet URL and sheet access, and check that service_account.json is present. If you see API or network errors, confirm your environment variables (if used) and ensure the sheet name 週報 is correct in the configuration.
Check which team members have not submitted their weekly reports.
Check the submission status for a specific person.
Retrieve overall submission statistics and trends.