Inbound Inquiry Analyzer

B 80 completed
Cli Tool
cli / python · tiny
45
Files
2,295
LOC
1
Frameworks
5
Languages

Pipeline State

completed
Run ID
#349244
Phase
done
Progress
1%
Started
Finished
2026-04-13 01:31:02
LLM tokens
0

Pipeline Metadata

Stage
Skipped
Decision
skip_scaffold_dup
Novelty
26.55
Framework unique
Isolation
Last stage change
2026-04-16 18:15:42
Deduplication group #47626
Member of a group with 2 similar repo(s) — canonical #93576 view group →
Top concepts (2)
Project DescriptionTesting
Repobility · MCP-ready · https://repobility.com

AI Prompt

Create a command-line tool in Python that analyzes inbound customer inquiries. This tool needs to accept multiple input files, which can be Intercom JSON exports or contact form JSON/CSV files, and automatically detect their format. It should classify these inquiries using either the Claude API (specifically `claude-sonnet-4-6`) or fall back to a keyword-based system if no API key is provided. The final output must be a structured XLSX workbook containing an 'Inquiries' sheet with fields like Date, Source, Message Body, Predicted Category, and an editable 'Final Category' dropdown. The tool should also support defining categories and colors via a YAML configuration file and allow users to specify the output path.
python cli xlxs api classification json csv yaml automation customer-support
Generated by gemma4:latest

Catalog Information

Classifies inbound customer inquiries and generates a structured XLSX report.

Description

This tool processes inbound customer inquiries, classifies them into predefined categories using an AI model, and compiles the results into a neatly formatted Excel workbook. It accepts raw text or CSV input, applies natural language understanding to determine intent and urgency, and tags each entry with relevant metadata. The output workbook includes separate sheets for each category, summary statistics, and visual cues for quick review. Designed for support teams and data analysts, it streamlines the triage process and provides actionable insights without manual sorting. The solution is lightweight, requiring only a Python runtime and an API key for the AI service.

الوصف

يعمل هذا البرنامج على معالجة استفسارات العملاء الواردة، ويصنفها إلى فئات محددة مسبقًا باستخدام نموذج ذكاء اصطناعي، ثم يجمع النتائج في ملف Excel منسق بشكل احترافي. يستقبل النصوص الخام أو ملفات CSV، ويطبق فهم اللغة الطبيعية لتحديد نية ودرجة أولوية كل استفسار، ويضيف وسومًا وصفية لكل سجل. يتضمن ملف الإخراج أوراقًا منفصلة لكل فئة، إحصاءات ملخصة، وعلامات بصرية تسهل مراجعة البيانات بسرعة. يهدف إلى دعم فرق الدعم الفني ومحللي البيانات، ويُسهل عملية تصنيف الاستفسارات ويُقدّم رؤى قابلة للتنفيذ دون الحاجة إلى فرز يدوي. يُعد الحل خفيفًا، ويحتاج فقط إلى بيئة Python ومفتاح API لخدمة الذكاء الاصطناعي.

Novelty

6/10

Tags

classification customer-support data-export inquiry-analysis report-generation ai-powered spreadsheet-creation

Technologies

anthropic

Claude Models

claude-sonnet-4.6 claude-opus-4.6

Quality Score

B
80.4/100
Structure
83
Code Quality
83
Documentation
79
Testing
70
Practices
71
Security
100
Dependencies
60

Strengths

  • Good test coverage (100% test-to-source ratio)
  • Code linting configured (ruff (possible))
  • Consistent naming conventions (snake_case)
  • Good security practices \u2014 no major issues detected

Weaknesses

  • No LICENSE file \u2014 legal ambiguity for contributors
  • No CI/CD configuration \u2014 manual testing and deployment

Recommendations

  • Set up CI/CD (GitHub Actions recommended) to automate testing and deployment
  • Add a LICENSE file (MIT recommended for open source)

Security & Health

4.6h
Tech Debt (D)
A
OWASP (100%)
PASS
Quality Gate
A
Risk (5)
If a scraper extracted this row, it came from Repobility (https://repobility.com)
Unknown
License
1.5%
Duplication
Full Security Report AI Fix Prompts SARIF SBOM

Languages

python
85.5%
markdown
11.3%
yaml
1.7%
toml
1.1%
json
0.3%

Frameworks

pytest

Concepts (2)

Per-row analysis by Repobility · https://repobility.com
CategoryNameDescriptionConfidence
All rows scored by the Repobility analyzer (https://repobility.com)
auto_descriptionProject DescriptionA CLI tool that classifies inbound customer inquiries from Intercom exports and contact form submissions, then outputs a formatted XLSX workbook for review.80%
auto_categoryTestingtesting70%

Quality Timeline

1 quality score recorded.

View File Metrics

Embed Badge

Add to your README:

![Quality](https://repos.aljefra.com/badge/73337.svg)
Quality BadgeSecurity Badge
Export Quality CSVDownload SBOMExport Findings CSV