‘Sub800’ is a UK-based business that helps firms find and rent ready-to-use office spaces in London. The company receives broker emails daily, and the team types each one into the system manually, which is slow and causes mistakes. The client asked us to develop a system that reads these emails, collects details and creates leads automatically.
‘Sub800’ wanted a system that reads enquiry emails in Outlook, collects the client and property details, and creates leads without manual efforts. We built the whole solution for them, from the first idea to a working system.
Our developers used Microsoft Power Automate, Excel, web scraping and AI on Azure Foundry. The system picks out genuine enquiries, checks listing pages for missing details and marks the lead source as Valve or Broker. Anything unavailable is marked “Missing” and a follow-up email is drafted. Complete leads go into the customer system, and an Excel report is emailed to the team.
The main challenge was that emails had no fixed format and each detail followed its own rules. We solved it by combining AI reading with clear checking rules and testing it on many real emails. Our customer advocate kept communication clear, and our project manager delivered on time. Today, ‘Sub800’ saves hours of manual work, has more accurate records and can focus more on its customers.
Power Automate, Microsoft Azure
RPA Solution for real estate firm ‘Platinum Realty LLC’ in USA
View Details