Weekly Report Checker

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

# Install the package
pip install -e .

# Install in Claude Desktop
./install_server.sh
# or
mcp install mcp_server.main --name "週報檢查器"

Usage

# Run in development mode
./run_server.sh
# or
mcp dev mcp_server.main

# Run directly
python -m mcp_server.main
# or
weekly-report-server

Example Client

Run the example client:

python example_usage.py

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

Install Server

HTTP connection URL

security – no known vulnerabilities

license - not found

quality - confirmed to work

How are these scores calculated?

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.

Tools

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

Weekly Report MCP Server
tobecrazy
-
security
F
license
-
quality
A simple MCP server that allows users to write and save weekly reports to text files in a dedicated reports directory.
Last updated -
Python
Cloud Monitoring API Server
ag2-mcp-servers
-
security
F
license
-
quality
An MCP server that provides access to Google Cloud Monitoring API, enabling interaction with cloud resources monitoring data through natural language commands.
Last updated -
Python
Google Cloud MCP Server
andyl25
A
security
F
license
A
quality
An MCP server that enables querying and interacting with Google Cloud services including Logging, Spanner, Monitoring, and Cloud Trace through natural language.
Last updated -
17
549
1
TypeScript
Google Sheets API MCP Server
ag2-mcp-servers
-
security
F
license
-
quality
An MCP server that enables interaction with Google Sheets through natural language, allowing users to create, read, update, and manage spreadsheet data via the Google Sheets API v4.
Last updated -
Python

View all related MCP servers