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

Usage

Example Client

Run the example client:

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