Cut a high-friction multi-team daily process from about four hours of manual work to roughly ten minutes of oversight, reducing double handling.
View workflow details
A single daily stock-update workflow depended on one person spending about four hours manually combining MYOB and supplier changes, building Word/email updates, and preparing marketing import lists for next-day website updates.
Built a Google Sheets and Apps Script system that ingested MYOB exports and supplier stock files, merged updates into a master tracked sheet with audit details, generated day-specific outbound stock email content, and automated end-of-day website update list outputs.
Cut a high-friction multi-team daily process from about four hours of manual work to roughly ten minutes of oversight, reducing double handling.
Partnered with finance, customer service, marketing, warehouse, and operations leadership to map the workflow, implement scripts and sheet logic, maintain process reliability, and support rollout across teams.