EDI Message Parsing: Gmail to Google Sheets

This n8n workflow simplifies Electronic Data Interchange (EDI) processing for small and medium businesses lacking direct EDI system integrations. It triggers on Gmail emails with 'EDI' in the subject, extracts raw EDI content (often from attachments or body), and uses a JavaScript code node to parse it into structured data like purchase orders, invoices, or shipping notices.

The workflow begins with a Gmail Trigger node monitoring inboxes. Incoming emails are filtered for EDI indicators, followed by parsing logic that handles common EDI formats (e.g., EDIFACT or ANSI X12). Parsed data—such as sender details, transaction types, quantities, and dates—is then formatted and appended to a Google Sheet, enabling easy review, reporting, and integration with other tools.

Benefits include massive time savings on manual data entry, reduced errors in supply chain operations, and scalability for handling growing email volumes. Ideal use cases: logistics firms receiving supplier orders via email, manufacturers tracking shipments, or retailers processing vendor invoices. Tags from creator highlight Supply Chain Management, Logistics, Transportation, and Data Transmission—perfect for sustainable, efficient automation.