EDI Message Parsing: Gmail Emails to Google Sheets
Automates detection and parsing of EDI messages from Gmail emails with 'EDI' in subject, extracting structured data via JavaScript and logging to Google Sheets for easy processing.
This n8n workflow streamlines Electronic Data Interchange (EDI) message handling for small and medium businesses lacking direct EDI integrations. It triggers on incoming Gmail emails containing 'EDI' in the subject, uses a JavaScript Code Node to parse the unstructured EDI content into structured data like purchase orders, invoices, or shipping notices, and outputs the results to a Google Sheet for review and further action.
Key benefits include eliminating manual data entry, reducing errors in
- Platform
- n8n
- Category
- Finance & Accounting
- Price
- $14.99
- Creator
- Viktor Guerrero
- EDI
- Gmail
- Google Sheets
- Supply Chain
- Logistics
- Invoice Processing
- Automation
- Data Parsing
- JavaScript
- Transportation
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Finance & Accounting workflows
- Automate Invoice Creation and Delivery with AI$9.99
- Automated Multi-Modal Expense Tracking via Telegram$24.99
- Automate Invoice Processing and Notifications with AI and Google Drive$14.99
- Automate Invoice Processing from Telegram to SAP with OCR and Google Sheets$14.99
- Compare Multi-Period Financial Data from Google Sheets with DeepSeek AI Analysis$14.99
- Automate Invoice Processing and Validation with OCR, AI, and Google Sheets$14.99
More from Viktor Guerrero
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.