Automated EDI Email Processing and Order Management

This n8n workflow automates the entire process of handling EDI order emails received via Gmail. It starts by triggering on new emails containing ‘EDI’ in the subject, then extracts and parses the EDI message content using a custom JavaScript function. The workflow identifies the order type and separates return orders from outbound orders, storing parsed data into designated Google Sheets for record-keeping. It includes steps to decode complex EDI segments, flatten the structured data into a tabular format, and store each line item with associated order details. Practical applications include streamlining order processing, reducing manual data entry, and integrating EDI communications with your inventory or sales systems.