Weekly Report Checker MCP Server
by kaneyxx
This is an MCP server designed to check weekly report submissions in a Google Sheet. It provides functionalities to track submissions and retrieve report status.
Last updated: N/A
What is Weekly Report Checker MCP Server?
The Weekly Report Checker MCP Server is a tool that automates the process of checking weekly report submissions stored in a Google Sheet. It leverages the Model Context Protocol (MCP) to provide a structured way to access and manage report data.
How to use Weekly Report Checker MCP Server?
To use the server, you need Python 3.10 or higher and a Google Sheets service account JSON file. After installing the package using pip, you can run the server in development mode or directly using the provided commands. Example client usage is also provided.
Key features of Weekly Report Checker MCP Server
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
Use cases of Weekly Report Checker MCP Server
Tracking employee weekly report submissions
Automating report status updates
Generating reports on submission rates
Identifying team members who consistently miss deadlines
FAQ from Weekly Report Checker MCP Server
What is MCP?
What is MCP?
MCP stands for Model Context Protocol, a framework for building and deploying context-aware applications.
What Google Sheets permissions are required?
What Google Sheets permissions are required?
The service account needs read access to the "週報" Google Sheet.
How do I set up the Google Sheets service account?
How do I set up the Google Sheets service account?
You need to create a service account in the Google Cloud Console, download the JSON key file, and share the Google Sheet with the service account's email address.
What are the available API resources?
What are the available API resources?
The server provides resources to check report status, get statistics, retrieve all team members, and check a specific person's status.
How do I check the status of a specific person's report?
How do I check the status of a specific person's report?
Use the weekly-report://person/{name} resource, replacing {name} with the person's name.