Sales-reporting automation for a retail company
−8 hof manual reporting a week
Before8 h
Now0 h
- n8n
- BigQuery
- Looker Studio
The challenge
The operations team at a retail company spent 8 hours a week manually consolidating sales, stock and incident data from different systems. Data arrived with a 7-day lag and decisions were made on stale information.
The solution
We built an automated pipeline with n8n that pulls data from the POS and the ERP every night, processes it in BigQuery and updates a Looker Studio dashboard with the previous day's data. Every Monday at 7am, the team also receives a weekly report.
The result
Zero manual reporting hours. The team recovered a full day each week. The operations director makes decisions on yesterday's data, not last week's.