005 · Automation · 2024
Nightshift
Automated 22 hours of weekly manual reporting down to zero.
- Stack
- NodeCronPostgresSlack API
[The bottleneck]
Weekly reporting was assembled by hand from five exports. It took most of a person, it was always late, and it was wrong often enough that people had stopped reading it.
[What I built]
A scheduled pipeline that pulls each source, validates it against expected shape and volume, and refuses to publish rather than publishing something wrong. Failures page a human; successes are silent.
[The result]
Reporting arrives on time without anyone touching it, and it is trusted again because the pipeline fails loudly instead of quietly producing nonsense.