Weekly Report Checker MCP Server

Name: Weekly Report Checker MCP Server
Author: kaneyxx

@kaneyxx

Repository

About Weekly Report Checker MCP Server

An MCP server that checks weekly report submissions in a Google Sheet

#weekly-report #mcp-server #google-sheets

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "weekly-report-mcp": {
      "command": "python",
      "args": [
        "-m",
        "mcp_server.main"
      ]
    }
  }
}

Tools

Check missing reports

Check a specific person's report

Get submission statistics

Overview

What is Weekly Report Checker MCP Server?

A Model Context Protocol (MCP) server that checks weekly report submissions in a Google Sheet ("週報"). It is intended for teams that need to track who has or hasn’t submitted their weekly reports.

How to use Weekly Report Checker MCP Server?

Install the package with pip install -e . and optionally register it in Claude Desktop using ./install_server.sh or mcp install mcp_server.main --name "週報檢查器". Run in development mode with ./run_server.sh or mcp dev mcp_server.main, or directly with python -m mcp_server.main. An example client is provided in example_usage.py.

Key features of Weekly Report Checker MCP Server

Checks who hasn’t submitted their weekly reports
Provides detailed status for a specific person
Shows submission statistics
Lists all team members who should submit reports
Exposes resources and tools via MCP

Use cases of Weekly Report Checker MCP Server

Automating weekly report submission tracking in a code‑friendly way
Querying submission status for a single team member
Getting an overview of team submission compliance
Integrating with Claude Desktop for natural‑language report checks

FAQ from Weekly Report Checker MCP Server

What prerequisites are needed to run the server?

Python 3.10 or higher, a Google Sheets service account JSON file (service_account.json), and access to the "週報" Google Sheet.

How do I install and configure the server?

Install the package with pip install -e . and optionally install it in Claude Desktop using the provided install_server.sh script or the mcp install command.

What resources and tools does the server expose?

Resources include weekly-report://status, weekly-report://stats, weekly-report://all-members, and weekly-report://person/{name}. Tools include check_missing_reports, check_person_report, and get_submission_stats.

How do I run the server in development mode?

Use ./run_server.sh or mcp dev mcp_server.main. For direct execution, run python -m mcp_server.main or the weekly-report-server command.

Where does the data come from and what authentication is required?

Data is read from a Google Sheet named "週報". Authentication uses a service account JSON file (service_account.json) placed in the project directory.