N8N Order Quote Automation
Budget: $250 – $750 USD
I need a complete n8n workflow, backed by a small web-dashboard, that handles every order message arriving through WhatsApp, Telegram, and Outlook Mail.
Workflow logic
• Read two Excel files stored in our cloud workspace. One file maps regions we serve to fixed prices; the second lists dealers who can cover out-of-area regions.
• When a new order arrives the flow must:
– Detect the customer’s region from the message.
– If the region is covered directly, return a quote that shows the price and the service-area name plus an estimated delivery time.
– If the region is not covered, locate matching dealers, add a configurable markup percentage to each dealer’s price, automatically forward the request to those dealers, and send the marked-up quote back to the customer.
- It must support multiple languages. It must respond by distinguishing based on the selected language.
Dashboard requirements
• Live transaction log searchable by date, channel, and order ID.
• Settings panel where I can upload refreshed Excel lists, adjust the markup percentage, toggle individual channels, and pause/activate the entire flow without touching n8n directly.
Technical expectations
The n8n instance may run on our existing Docker stack. You are free to choose a lightweight front-end framework (React, Vue, or plain HTML/JS) for the dashboard as long as it authenticates against our internal user table. Webhooks, IMAP polling, the n8n WhatsApp/Telegram nodes, and a custom JavaScript function node for price logic will likely be involved; please optimise for maintainability.
Acceptance criteria
1. End-to-end tests prove that orders on all three channels receive the correct quote path within 30 seconds.
2. Dashboard updates (new Excel files or markup change) reflect in live traffic without redeploying.
3. Clear written hand-over: flow export (.json), dashboard source code, and a short README for environment variables and build commands.
Workflow logic
• Read two Excel files stored in our cloud workspace. One file maps regions we serve to fixed prices; the second lists dealers who can cover out-of-area regions.
• When a new order arrives the flow must:
– Detect the customer’s region from the message.
– If the region is covered directly, return a quote that shows the price and the service-area name plus an estimated delivery time.
– If the region is not covered, locate matching dealers, add a configurable markup percentage to each dealer’s price, automatically forward the request to those dealers, and send the marked-up quote back to the customer.
- It must support multiple languages. It must respond by distinguishing based on the selected language.
Dashboard requirements
• Live transaction log searchable by date, channel, and order ID.
• Settings panel where I can upload refreshed Excel lists, adjust the markup percentage, toggle individual channels, and pause/activate the entire flow without touching n8n directly.
Technical expectations
The n8n instance may run on our existing Docker stack. You are free to choose a lightweight front-end framework (React, Vue, or plain HTML/JS) for the dashboard as long as it authenticates against our internal user table. Webhooks, IMAP polling, the n8n WhatsApp/Telegram nodes, and a custom JavaScript function node for price logic will likely be involved; please optimise for maintainability.
Acceptance criteria
1. End-to-end tests prove that orders on all three channels receive the correct quote path within 30 seconds.
2. Dashboard updates (new Excel files or markup change) reflect in live traffic without redeploying.
3. Clear written hand-over: flow export (.json), dashboard source code, and a short README for environment variables and build commands.