Automated Supplier RFQ System
![](https://assets-global.website-files.com/611049945b03394c7801a1c4/6176b91b4f7a60775335ac59_bso-wht.png)
Challenge
The client had no way to automatically capture, process and allocate UK-wide traffic from their website to their network of product suppliers to swiftly request a quotation.
Solution
We developed a comprehensive platform, based around a complex Google Sheet, which facilitated the matching of incoming enquiries with the client's database of suppliers according to region and compatibility data.
Services provided
Project Description
We developed a spreadsheet driven system which powers an entirely new business unit for the client.
This system receives an input from the clients' website users who submit a Jotform form featuring their delivery address for materials.
The system references a supplier database that details which materials that supplier can deliver and the areas they can deliver to, at a county level.
The system parses key details from the website user's submitted data, matches the request to relevant suppliers based on our lookup logic, and requests a price from each of those providers.
Phase 2 of the system will include capturing structured prices from the suppliers, any relevant price adjustments and sending of the price, in a bespoke pdf quotation to the enquiring user. All maintainable within a simple, well designed Google Sheets backend database.
The system enabled the launch of an entirely new, mostly-automated, business unit within a matter of weeks. Facilitating scale, increasing reach and service provision out of hours.
System walkthrough
![](https://assets-global.website-files.com/607acb3c88d1c87ac7867b71/607acb3d88d1c811fd867b9b_surface-aqdPtCtq3dY-unsplash.jpg)
Grab the tool for your business
Ready to eliminate busyness from your business?
Let's explore the potential savings and growth goals automation could achieve for your company.