Customer Service Co-Pilot App - ChatGPT AI

Подписаться 1,8 тыс.

50% 1

In this project, we're creating a Customer Service Co-Pilot App designed to assist Coffee Store Managers with online customer engagement and care using ChatGPT AI. The app is powered by customer reviews stored in a Google Sheet.
Our data source is Google Sheets, and we've developed a custom function template connected to a Chatflow built with Flowise/Langchain hosted on a Replit server. When activated, this Chatflow interfaces with the OpenAI Language Model.
We've built three specific Chatflows to streamline the process:
Sentiment Analysis: This Chatflow analyzes customer reviews to gauge sentiment, helping managers understand customer feelings.
Brief Summary: This Chatflow automatically generates concise summaries of customer reviews, saving time and effort.
Drafting Replies: Our third Chatflow assists in crafting personalized responses to customer reviews, improving customer interaction.
Udemy course available with discounted instructor link for a limited time.
www.udemy.com/...

Опубликовано:

1 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 5

@mado.madeleine Год назад

That's super helpful! Thank you for sharing 🙏🏽

@GilbertMizrahi Год назад

Derek, Interesting approach. However, since you are using Apps Script this case could be simpler / more powerful creating the functions that call the OpenAI GPT-3.5 directly from the Apps Scrips files. For the purpose of showing how to use Flowise is great. I have a question: let's say that instead of an LLM chain, you want a conversational chain. Is there a way to use a prompt template in that case? It seems that when using a conversation chain you can optionally use it with a document, but I don't see how to use a prompt template.

@derekcheung2598 Год назад

Hi Gilbert, you're right I wanted to show a no-code method to do this. Additionally, I also didn't want to include my OpenAI API key in a Google Sheet app code.