Count Before You Automate: Tallying Repeated Request Types From an Inbox Export in Python

说明与用途

Python脚本快速统计邮箱导出中的请求类型，生成包含类别和示例的CSV，帮助自动化审计。

问题

Owners need accurate counts of recurring request types before automating, but guesses are unreliable.

结果

The script outputs a CSV with categories, counts, and example subjects, enabling a data‑driven audit of request types.

工作流

• Export mailbox or label as .mbox or CSV
• Run Python script that categorises subjects using regex rules
• Collect counts and sample subjects per category
• Iterate on rules to reduce 'other' bucket
• Prepare tally CSV, examples, and notes for audit

证据

Every automation conversation eventually hits the question "how often does this actually happen?" Owners guess. Guesses are usually wrong in both directions.

来源

If you are preparing for an AI workflow audit with real request counts you can answer that question in an afternoon with an export of your inbox and a short script. Everything runs locally.

来源

The script below handles mbox; adapting it for CSV is a few lines.

来源

This is the important part. The other category is where you discover requests nobody thought to name. Read a sample, add a rule, run again. Two or three passes usually get "other" small.

来源

The tally CSV. Five examples per category, including one that went badly. A note on which categories need a human decision (prices, refunds, complaints).

来源