Built a Custom Chat Box Integrated With the ChatGPT OpenAI API

A chat-based assistant integrated with OpenAI was deployed directly within Salesforce, and it was integrated to retrieve records in real-time and display them in easy-to-read formats.
Customer
Property Management Firm
Country / Region
Porto, Portugal
Industry
Real Estate
Banner - Built a Custom Chat Box Integrated With the ChatGPT OpenAI API Case Study

Highlights

Conversational Salesforce Access
Automated Intent-to-SOQL Conversion
Apex-powered Query Execution
Console Utility Bar Deployment
Client Requirements

Multi-Object Navigation
Users required a tool that delivered specific data, such as active listings, deal stages, agreements, or client records, without requiring manual querying of Salesforce or in-depth knowledge.

Simple Non-Technical Team Navigation
As the object relationships were not well understood by non-Salesforce users, the client sought a method to avoid the typical multi-step navigation process.

A Built-in Assistant
They needed the solution to reside within Salesforce, be visible on any screen, and not demand additional licenses or third-party equipment.

After Requirements - Built a Custom Chat Box Integrated With the ChatGPT OpenAI API Case Study
Challenges

Multi-Object and Variable Records Handling

Property, deal, account, and agreement records were found across real estate data, as well as financial records. Finding one piece of information could result in several pages being opened.

High dependency on SOQL Queries

Even basic things such as “What is the stage of this deal?” needed the assistance of technical human resources since most employees did not know how to write a query; they were not able to find the records.

Difficulty Understanding Where Data is Stored

Sales, leasing, and operations teams were unfamiliar with Salesforce object schemas, making it difficult to identify the correct field or relationship for the data they needed.

Built a Custom Chat Box Integrated With the ChatGPT OpenAI API 1
Built a Custom Chat Box Integrated With the ChatGPT OpenAI API 2
Built a Custom Chat Box Integrated With the ChatGPT OpenAI API 1
Solutions

Natural-Language Interpretation Layer (AI-based)
A special chat interface has been designed with Lightning Web Components. Once a user entered a question, this text was forwarded to the ChatGPT API, which understood this request and created a clean JSON-based structure explaining what information was required to locate.

SOQL Dynamic Execution Controlled by Apex
The Apex backend would then convert the AI-generated instructions into safe and validated SOQL queries. It was done to make sure only the allowed objects and fields were used and yet provide users with open-ended querying possibilities.

AI-Based Records Summarization
Once Salesforce submitted the requested data, the assistant provided the results to ChatGPT. The model showed a brief explanation of what was important rather than showing the raw fields, including deal progress, date of agreement, tenant, property availability, and so on.

Utility Bar Integration
Salesforce added the assistant to its Utility Bar to be opened at any time. No additional licensing was required, and no alterations needed to be made to the current Console app of the client.

In need of simplifying Salesforce for your team? We can assist you in creating a conversational assistant for your workflows.
Technical Architecture
Key Features
Technical Stack
COMPANY

Our client is a reputable property management firm with a wide portfolio of residential and commercial properties in Portugal. To organize listings, dealings, and review agreements and maintain working client relationships, their teams depend greatly on Salesforce. As additional departments started to utilize Salesforce, the amount of data began to increase rapidly, and so did the desire to have a more accessible and less technical approach to data.

Our team no longer has difficulties locating information in Salesforce. Nothing takes us more than a few seconds, and our daily manual labor has become significantly easier thanks to the chat box.

Conclusion

Now property managers can scan listings and availability without switching their displayed screen, salesmen without direct deal progression can see immediate progression, and operations pages can access agreement details within seconds.

The lightweight LWC interface, dynamic Apex execution, and the ability of OpenAI to process languages created a tool that is easy to use and feels like a conversation with an intelligent assistant who is familiar not only with the business aspects but also with the Salesforce world. Consequently, the firm has experienced quicker decision-making, reduced internal bottlenecks, and increased confidence in Salesforce use by non-technical teams.

Benefits
  • Natural-language access to property, deal, and client data.
  • Lower dependency on IT for SOQL queries and data retrieval.
  • Faster responses to clients, tenants, and internal stakeholders.

Build Your Solution With Us

Get in touch to discover tailored strategies that move your business forward.

connect@melonleaf.com

Please enter your business email

Speak With Our Team About Your Next Move

Get in touch with our certified consultants and experts to explore innovative solutions and services. We’ve empowered companies across various domains to transform their business capabilities and achieve their strategic goals.

Latest Case Studies

Send an Email
To : connect@melonleaf.com