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
Usage
Example Client
Run the example client:
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
This server cannot be installed
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
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.
Related MCP Servers
- -securityFlicense-qualityAn MCP server that provides tools and resources for managing a coding project's todo list, allowing users to view, add, update, and delete todo items with details like priority, status, and tags.Last updated -1Python
- AsecurityFlicenseAqualityAn MCP server implementation that enables interaction with the Unstructured API, providing tools to list, create, update, and manage sources, destinations, and workflows.Last updated -3928
- -securityAlicense-qualityAn MCP server for interacting with Google's Chronicle Security Operations suite, enabling users to search security events, get alerts, look up entities, list security rules, and retrieve IoC matches.Last updated -5PythonApache 2.0
- -securityFlicense-qualityA simple MCP server that allows users to write and save weekly reports to text files in a dedicated reports directory.Last updated -Python