What changed
- Daily CSV sales files are collected from FTP and processed without anyone opening them
- Dashboards and reports are ready rather than rebuilt each morning
- Announcements reach internal users through a dedicated portal instead of email chains
Zoho Creator
Where they started
Sales data arrived daily as CSV files. Someone opened them, processed them and rebuilt the same reports before anyone could act on the numbers. Separately, internal announcements went out as email chains with no single place to find them.
What we built
An automated data pipeline that fetches the daily CSV files from FTP, processes them, and generates interactive dashboards and reports without human involvement.
Alongside it, custom landing pages for internal announcements and updates, so communication has an address rather than living in inboxes.