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

Google Drive MCP Server
rishipradeep-think41
-
security
A
license
-
quality
This MCP server integrates with Google Drive to allow listing, reading, and searching files, as well as the ability to read and write to Google Sheets.
Last updated -
549
2
JavaScript
MIT License
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 Logging API Server
ag2-mcp-servers
-
security
F
license
-
quality
An MCP server that enables interaction with Google Cloud Logging API, allowing users to write, read, and manage log entries and configurations through natural language.
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

View all related MCP servers

Weekly Report Checker