2025 · Operations & reporting
ERP order analytics and reporting automation (n8n)
A scheduled workflow that pulls orders from a custom ERP API, filters processing orders into Airtable, calculates weekly order totals and revenue in JavaScript, and posts a performance summary to Discord.
- Year
- 2025
- Industry
- Operations & reporting
- Platform
- n8n workflow automation
- Client region
- International
- Status
- Delivered to client
The brief
What the client needed
Order data lived in the ERP but nobody had a quick weekly view. Someone had to export, filter and total orders manually before every review.
What we delivered
Shipped to the client
- Scheduled HTTP integration with a custom ERP API
- Filtering of processing orders into structured Airtable records
- JavaScript step calculating weekly order counts and revenue
- Automatic performance summary posted to Discord
Key features
Real-time tracking
Processing orders captured on a schedule.
Structured storage
Clean records in Airtable for analysis.
Automated reporting
Weekly totals delivered without exports.
Technology
Next step
Tell Us Your Problem. We'll Help You Build the Solution.
Tell us what you are working on. You will get a considered reply from an engineer — with questions, a suggested approach or an honest “we are not the right fit”.