How elyes-ghouma/automated-email-order-processing works
Vectorys Automated Planification turns Gmail messages into logistics orders, using a local LLM to classify intent and extract structured data, then processing Excel attachments and producing Sage WMS output. Operators use the Streamlit interface to monitor runs, maintain client and stocker data, and correct or reprocess uncertain cases. The sampled code shows the UI launching the processing routine and parts of AI analysis, order handling, and Excel generation; several workflow links and capabilities are supported only by the README, so those edges cite it.
Main entry points: functions.py Order handling · main.py Streamlit dashboard · parametres.json Processing configuration · templates Prompt and form templates
Components 18
Email Intake
- Mail retrieval
functions.py - Mail and attachments
functions.py
Order Processing
- AI agent setup
functions.py - Mail classification
functions.py - Client matching
functions.py - Excel extraction
functions.py - Order handling
functions.py - Sage form generation
functions.py - Prompt and form templates
templates
Operations Interface
- Streamlit dashboard
main.py - Manual correction
main.py
Local Data
- Processing configuration
parametres.json - Orders and files
functions.py - Mail and JSONL registers
functions.py
Other components
- Operator
- Gmail inbox
- Ollama model
- Sage WMS
Connections 20
- Operator → Streamlit dashboard: runs and reviews
README.md - Streamlit dashboard → Mail retrieval: launches processing
main.py - Gmail inbox → Mail retrieval: provides messages
README.md - Mail retrieval → Mail and attachments: retrieves attachments
README.md - Mail and attachments → Mail classification: provides mail content
README.md - AI agent setup → Ollama model: invokes model
functions.py - Prompt and form templates → AI agent setup: configures prompts
README.md - Mail classification → Client matching: matches client
functions.py - Mail classification → Order handling: provides extracted data
README.md - Mail and attachments → Excel extraction: supplies attachment
README.md - Excel extraction → Order handling: provides order data
README.md - Order handling → Sage form generation: generates output
functions.py - Sage form generation → Sage WMS: creates WMS files
README.md - Order handling → Manual correction: flags uncertain cases
README.md - Manual correction → Order handling: corrects and reprocesses
README.md - Order handling → Orders and files: stores orders
README.md - Mail retrieval → Mail and JSONL registers: records mail data
README.md - Streamlit dashboard → Mail and JSONL registers: reads and edits records
main.py - Streamlit dashboard → Processing configuration: updates settings
main.py - Order handling → Processing configuration: reads processing settings
functions.py