Supplier emails become ledger entries, hands-free
A script reads the inbox, checks each order, and posts it to accounting.
- Client
- Wholesale distributor
- Timeline
- 4 weeks
- Scope
- Workflow automation, integration
The problem
Two staff members spent about three hours a day downloading order attachments and retyping them into the accounting system.
What we built
- A watcher checks the shared inbox every 15 minutes and saves each attachment.
- PDFs and CSV files are read into one standard order format.
- Rules check prices, quantities and supplier codes before anything is posted.
- Anything unclear goes to a review queue, and a daily summary is emailed to the owner.
3 hrs → 10 mindaily handling time
94%orders posted automatically
0missed attachments
Built with Node.js, Gmail API, REST, SQLite.