Save sales export cleanup as a reusable skill
What it does
Hermes Agent examines messy sales exports, identifies common issues across files, decides on cleaning rules, and produces a merged report. It then saves this process as a reusable skill. When reused on future exports, the skill applies the same rules consistently, ensuring reports match across quarters.
The method doesn't run faster the second time, but the consistency is the real value.
Why it's worth it
Repeating the same cleanup each quarter is tedious, and explaining the rules each time introduces inconsistency. A saved skill acts as a recipe: point it at new files with the same structure, and it applies the same method every time.
That consistency matters most for reports that need to match across quarters or years.
Clean messy exports into a report and save the process as a reusable skill.
Step by step
Paste it into Hermes Agent and swap the highlighted parts for your own details.
Before you start Have your messy export files ready.
Get Hermes Agent to:
- Examine [my number] sales exports from [these files or folder], noting which columns are messy and why (duplicates, formatting, missing values).
- Decide on the cleaning rules: which columns to keep, how to merge duplicate records, and what to aggregate (by date, region, category, or total).
- Clean all the files using your rules, remove duplicates, and merge them into one report for [quarter].
- Show me the final report and wait for approval before saving anything.
- Save the cleanup process as a reusable skill so I can run it again next quarter.
- If the skill format check fails, run /learn to fix the format.
- Confirm the skill is saved and send me the exact prompt I can paste to reuse it with next quarter's files.
Expected resultOne clean report for the quarter, and a reusable skill saved for future exports.

