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
Copy
Usage
Copy
Example Client
Run the example client:
Copy
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
Copy
This server cannot be installed
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.