Need Help in Building an AI Quotation System for Electronic Components
Hi everyone,
I’m looking to build an AI-powered quotation system for an electronic components trading business and would appreciate advice from anyone experienced with n8n, Gmail, OpenAI, or AI automation.
The main problem is that we already have thousands of previous quotation emails from suppliers/brokers, and many of those emails already contain our final quoted selling price.
I want to automate the process like this:
Customer Email → n8n → Extract MPN & Quantity → Search Existing Quotation Emails → Find Matching Previous Quote → Use Existing Quoted Price → Prepare Our Quotation → Human Approval → Send Email
For example:
Previous quotation:
STM32G031G8U6TR — 50,000 pcs — USD 2.40/pc
New customer enquiry:
STM32G031G8U6TR — 20,000 pcs
The system should find the previous quotation and use USD 2.40/pc.
It should NOT add another margin, because the existing price is already our selling price.
It should also check:
- Exact MPN
- Manufacturer
- Customer quantity vs quoted quantity
- Previous quotation date
- Price validity
- MOQ
- Lead time
- Stock
- Supplier/source
- Multiple previous quotations
If the previous quotation is expired or the quantity is different, it should flag the item for manual confirmation rather than making up a price.
What I want to know
Would n8n + Gmail + OpenAI + a database be the best way to build this?
And what would you recommend for storing/searching thousands of previous quotation emails?
Any practical workflow examples or advice would be greatly appreciated.
Thanks!