E-commerce Salesforce Connect

Inspiration

Our inspiration stemmed from the desire to create a more seamless and efficient customer service experience for our e-commerce platform. We recognised that managing customer feedback, including product reviews and questions, could be time-consuming and fragmented across different systems. The vision was to centralize this process within our Salesforce CRM, empowering our support team and leveraging the power of AI to provide quicker and more helpful responses. We also aimed to enhance our product listings with more engaging and informative descriptions.

What it does

"E-commerce Salesforce Connect" is a project that integrates our e-commerce website with Salesforce to streamline customer service and enhance product information. Specifically, it:

Captures product reviews and questions submitted on our e-commerce website.
Automatically creates cases in Salesforce from this feedback.
Leverages Salesforce AI to generate responses to reviews and questions within the Salesforce case.
Posts AI-generated responses back to the e-commerce website, providing customers with timely feedback.
Implements a product description generator using Salesforce's Prompt Builder to create more compelling and informative product listings.

How we built it

We built "E-commerce Salesforce Connect" using a combination of Salesforce features and custom development:
Salesforce Scheduler: Configured to regularly poll our e-commerce website's API for new product reviews and questions.
Salesforce Custom Objects: Created "Review" and "Question" objects to store the data fetched from the e-commerce platform.
Salesforce Flows:
1. The "Create Case from Review Flow" and "Create Case from Question Flow" are triggered upon the creation of a new "Website Review" or "Website Question" record, respectively. These flows create a new case in Salesforce, linking it to the relevant review or question.
2. The "Response Generation Flow" is triggered when a new case is created from a review/question. This flow uses Salesforce AI (e.g., Einstein GPT) to generate an appropriate response. The flow then uses a REST API call to send the generated response back to the e-commerce website. The website updates the review/question with the provided response.
REST API Integration: Implemented a secure REST API endpoint on our e-commerce website to receive and display the responses from Salesforce.
Salesforce Prompt Builder: Utilized to design and test effective prompts for generating engaging and accurate product descriptions, which can then be used to update our product listings.

Challenges we ran into

We encountered several challenges during the development process:
API Integration Complexity: Establishing secure and reliable communication via the REST API between the two systems involved troubleshooting authentication and data transfer issues.
Got error on flow, invocable method

Accomplishments that we're proud of

We are proud of several key accomplishments:

Successful End-to-End Integration: We achieved a fully functional integration between our e-commerce platform and Salesforce, automating a significant portion of our customer feedback management.
Effective AI Implementation: We successfully leveraged Salesforce AI to generate helpful and contextually relevant responses to customer inquiries.
Improved Response Times: The automation implemented has demonstrably reduced the time it takes for us to acknowledge and respond to customer feedback.
Centralized Customer View: All customer feedback is now consolidated within Salesforce, providing our support team with a comprehensive view of customer interactions.
Functional Product Description Generator: We developed a tool that allows us to quickly generate improved product descriptions, enhancing our product listings.

What we learned

Through this project, we gained valuable insights into:
The power of integrating different business systems to streamline workflows.
The potential of AI to enhance customer service efficiency and responsiveness.
The importance of careful planning and thorough testing when implementing API integrations.
The iterative nature of working with AI models and the need for continuous prompt refinement.

What's next for E-commerce Salesforce Connect

Our future plans for "E-commerce Salesforce Connect" include:

Sentiment Analysis: Integrating sentiment analysis capabilities to prioritize urgent or negative feedback.
Multi-Language Support: Expanding the AI response generation to support multiple languages.
Personalized Responses: Exploring ways to personalize AI-generated responses based on customer history and preferences.
Train model using more real data.
Feedback Loop Optimization: Continuously monitoring the effectiveness of AI-generated responses and refining the prompts for better accuracy and customer satisfaction.