Business Order Automation with n8n

Built an end-to-end business automation using n8n that streamlined order management and reporting for a real-life business workflow.

The workflow runs on a schedule trigger, fetches order data from an internal ERP system via HTTP Request, cleans and maps order details, and stores them in Airtable. Conditional logic routes orders based on status — Processing orders go to one table, Booked orders to another. A Code Node then calculates total booked orders and total order value, and a weekly summary report is automatically delivered to Discord — keeping the entire team updated in real time.

This project demonstrates how n8n can connect multiple enterprise tools (ERP → Airtable → Discord) into one seamless, fully automated pipeline — eliminating manual tracking and improving team communication.