Sales-reporting automation for a supermarket chain
The operations team at a retail chain with 3 physical stores and an ecommerce site spent 8 hours a week manually consolidating sales, stock and incident data from four different systems. Data arrived with a 7-day lag and decisions were made on stale information.
We built an automated pipeline with n8n that pulls data from the POS, the ecommerce platform and the ERP, processes it with BigQuery and generates a Looker Studio dashboard refreshed automatically every Monday at 7am.
Zero manual reporting hours. The team recovered a full day each week, now spent on strategic analysis instead of consolidation. The operations director makes decisions on yesterday's data, not last week's.