🎫 Customer TicketResolver MCP

A smart and streamlined MCP tool that automates the end-to-end process of customer ticket handling — from ticket creation to resolution and response. This system integrates a customer-facing UI, internal company dashboard, Google Sheets, SMTP mailer, and MCP Inspector — enabling intelligent ticket resolution with minimal human intervention.

🚀 Project Highlights

• 📩 Customer Support Ticket UI
• 📊 Ticket Logging to Google Sheets via API
• 🧑‍💻 Company Dashboard for Ticket Review & Analysis
• 📬 Automated Customer Email Responses via SMTP
• 🛠 Packaged as an MCP Tool
• 🔍 Exposed via MCP Inspector for Monitoring & Access

🔁 Workflow Overview

A[Customer UI] --> B[Ticket Submission]
B --> C[Log Ticket to Google Sheet (via API)]
C --> D[Company UI Reviews Tickets]
D --> E[Analyze Ticket Content]
E --> F[Auto Email Response via SMTP]
F --> G[Tool Registered & Exposed via MCP Inspector]

Customer UI

Company UI

Updating Google Sheets

Automatic Email: