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.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Weekly Report Checkerwho hasn't submitted their weekly report yet?"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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 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