My_tasks_mcp
About
Mytasksmcp is a simple MCP server for task management that uses a Google Sheet as its database. It is intended for users who want to manage tasks through a chat interface (e.g., Claude Desktop) while storing data in a familiar spreadsheet format.
Details
- Author
- vijaynaikd
- Downloads
- 138
- Categories
- Other
Jump to
- Uses a Google Sheet as the backend database.
- Provides task management capabilities via the MCP protocol.
- Simple setup with a service account for authentication.
- Designed to work with Claude Desktop or other MCP hosts.
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
My_tasks_mcpCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Clone the repository, create and activate a Python virtual environment, then set up a Google service account with Drive and Sheets APIs enabled. Download the service account JSON file as googleserviceaccount.json and place it in the project root. Create a Google Sheet named “MyTasks” and share it with the service account email. Install dependencies with uv add google-auth google-auth-oauthlib gspread mcp oauth2client. Finally, add the MCP server configuration to your Claude Desktop app using the command uv with the arguments shown in the README, pointing to the project’s main.py.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"my_tasks_mcp": {
"my_tasks": {
"command": "uv",
"args": [
"--directory",
"/path to your project/mcp_server/",
"run",
"main.py"
]
}
}
}
}McpServers
{
"my_tasks": {
"command": "uv",
"args": [
"--directory",
"/path to your project/mcp_server/",
"run",
"main.py"
]
}
}This is a simple MCP server to demonstrate task management
This uses a google sheet as database
1. Clone this project
2. Go to your project folder
3. Create virtual envrionment
python3 -m venv venv
4. Acticate virtual environment for mac
source venv/bin/activate
for windows
venv\Scripts\activate
5. Setup service account in your google account
Activate google drive and google sheets apis
Download add googleserviceaccount.json to root folder
6. Create a google sheet by name "MyTasks" and share it with service account
7. Intall dependencies
uv add google-auth google-auth-oauthlib gspread mcp oauth2client
8. Add the MCP configuration to Claude Desktop
{
"mcpServers": {
"my_tasks": {
"command": "uv",
"args": [
"--directory",
"/path to your project/mcp_server/",
"run",
"main.py"
]
}
}
}
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
