🧠 Langflow Support Ticket Report Challenge – crypto333198

This repository contains my submission for the Langflow Practical Certification Challenge.

🚀 Overview

This project automates a monthly support ticket summary report using Langflow:

• Loads support tickets from a CSV file
• Uses OpenAI GPT-3.5 to classify each ticket's sentiment
• Calculates:
  • Total ticket count
  • Average response time
  • Sentiment breakdown
• Generates a report in markdown format
• Sends it via email using Composio

🛠 Files

File	Description
LangflowChallenge_crypto333198.json	Main Langflow flow (importable)
ticket_report.py	Standalone Python script to simulate processing
tickets.csv	Sample input data (optional demo)
sample_sentiment_graph.png	Visualization of ticket sentiments (optional)

📦 Technologies Used

• Langflow (visual LLM workflows)
• OpenAI GPT-3.5 Turbo (for sentiment analysis)
• Composio (email integration)
• Python (Pandas, Matplotlib)

🧪 How to Use

1. Import the .json flow into Langflow
2. Upload your tickets.csv
3. Add your OpenAI key and Composio credentials
4. Run the flow — an email gets sent with the report!

🧑‍💻 Author

Shrushti Wakchaure
Discord: crypto333198
Email: shrushtiwakchaure@gmail.com

---

Submitted for the July 2025 Langflow Certification Challenge 🚀