Timesheet Assistant

You can run Timesheet Assistant MCP to generate timesheets from Activity Collector data and submit them to PSI Project Server. This MCP orchestrates data fetching, smart summarization, and automated browser-based submission to SharePoint-based timesheets, helping you streamline time tracking and reporting.

How to use

Install and run the MCP client you prefer, then use the available tools to generate timesheets for your desired period. After generating, fetch tasks from PSI once for the period, select a task from the hierarchical task tree, and submit each day’s entry to PSI. The MCP uses Activity Collector data (GitLab, GitHub, and Calendar) to populate timesheets and then fills the PSI submission form automatically via browser automation.

Key workflows you can perform:

• Generate a daily, weekly, monthly, or custom date range timesheet.
• Retrieve available PSI tasks for the current period (do once per period).
• Associate each day of your timesheet with a chosen PSI task by index.
• Submit the completed timesheet to PSI; the system will automatically fill the SharePoint form.

How to install

Prerequisites: ensure Node.js and npm are installed on your system.

Via npx (Recommended)

npx timesheet-assistant-mcp

Via npm

npm install -g timesheet-assistant-mcp

From source

git clone https://github.com/sharadmathuratthepsi/timesheet-mcp.git
cd timesheet-mcp
npm install
npm run build

Additional sections

Configuration focuses on enabling PSI access and connecting the MCP to your data sources. You can configure PSI credentials and the target PSI Timesheet URL, as well as set up integration with the Activity Collector MCP to fetch activity data. The MCP stores credentials locally with restricted permissions for security.

Security and data handling: credentials are stored locally with restricted permissions, and browser automation uses Puppeteer to interact with the PSI SharePoint page in a controlled session. All data remains on your machine unless you explicitly export or forward it.

Troubleshooting tips:
- If activity data is missing, verify Activity Collector MCP is running and properly configured.
- If PSI submission fails due to a page structure issue, run inspect_psi_page to debug the page layout and adapt the selector paths.
- If the browser crashes, ensure Puppeteer dependencies are installed by running `npm install puppeteer`.

Notes on configuration and usage specifics

To integrate Claude desktop or Code environments, you configure the MCP servers by adding entries that point to the MCP run commands. For example, you can run npx timesheet-assistant-mcp for the timesheet assistant and npx activity-collector-mcp for the activity data collector.

Available tools

generate_timesheet

Generate monthly timesheet data by aggregating activity data from the Activity Collector MCP and formatting it for the target date range.

generate_weekly_timesheet

Create a timesheet covering a calendar week using fetched activity data.

generate_daily_timesheet

Produce a single-day timesheet from the collected activity data.

generate_date_range_timesheet

Assemble a timesheet for a custom date range specified by the user.

configure_psi

Set up and store PSI credentials and the target PSI URL for submission.

get_psi_tasks

Fetch available PSI tasks for the current timesheet period; run once per period to optimize usage.

submit_to_psi

Submit a generated timesheet entry to PSI by selecting a task index and providing a description.

inspect_psi_page

Inspect the SharePoint/PSI submission page to debug form structure and grid cells.