Weekly Report Checker

Integrations

  • Provides tools for checking weekly report submissions in a Google Sheet, including identifying missing reports, viewing specific person's report status, and analyzing submission statistics.

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 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
-
security - not tested
F
license - not found
-
quality - not tested

An MCP server that monitors and provides analytics on weekly report submissions in a Google Sheet, allowing users to check missing submissions, view statistics, and track individual reporting status.

  1. Features
    1. Prerequisites
      1. Installation
        1. Usage
          1. Example Client
            1. API Reference
              1. Resources
              2. Tools
            ID: 9tpzw2rsm2