This is a simple MCP server to demonstrate task management\ This uses a google sheet as database\ \
- Clone this project\
\
- Go to your project folder\
\
- Create virtual envrionment\
python3 -m venv venv\\
- Acticate virtual environment for mac\
source venv/bin/activate \\ for windows\
venv\\\\Scripts\\\\activate\\
- Setup service account in your google account\
Activate google drive and google sheets apis\ \ Download add googleserviceaccount.json to root folder\ \
- Create a google sheet by name "MyTasks" and share it with service account\
\
- Intall dependencies\
\
uv add google-auth google-auth-oauthlib gspread mcp oauth2client\\
- Add the MCP configuration to Claude Desktop\
{\
"mcpServers": {\
"my_tasks": {\
"command": "uv",\
"args": [\
"--directory",\
"/path to your project/mcp_server/",\
"run",\
"main.py"\
]\
}\
}\
}\