Spreadsheet to DialogFlow/ChatGpt Demo Chat Bot
Budget: $8 – $15 USD
We wish to create a demo FAQ Chat Bot but also give possibility to users to write Keywords in order to find their answer.
We would like to do only the 4 lines of the excel attached.
The idea is once we finalize the Spreadsheet format, to be able to add extra lines in the Spreadsheet and import it in the Chat Bot in 1 click.
So, when a customer opens the chat, it should greed him with a text:
"Hello,
I am XXX, a bot.
Do you need help with:
Here it should provide the “General category” from the list in Column A
After the customer picks the category it should provide “ Sub Category 1” the the list in Column B
After the customer picks the sub category 1 it should provide “ Sub Category 2” the the list in Column C
We would like when a user writes a keyword, to reply with the Subcategory/Answer that appears on the right of each keyword found in the excel.
But we would like to see when we type the keyword “LOST PASWORD” how to reply with the previous category/subcategory."
!!!!!!!!The lost password has nothing to do with changing the password in the server.!!!!!!!!!!!!!!
It is just an example to show that you can have duplicate keyword in the excel.
When a user put a question with a keyword which belongs to many categories, to provide to user the question that belongs one category above, in order to avoid any misunderstanding.
So for example if a user write "forgot password", the bot should put 2 buttons: 'Web Check In' and 'Already and Affiliate' ?
Like that if user click:
- 'Web Check In', the answer will be 'If you cannot find your log in details and you do not have the e-mail sent to you upon registering'
- 'Already and Affiliate', the answer will be 'In case you lost your password for the check in, will got to the following page and put your email'
Finally, we would like to study the Json backup files generated by dialog flow, in order to be able to convert the total final excel, directly to Json files.
We are open to any other technology (chat gpt, watson etc...) to achieve the demo project and once we are convinced you can do it to give you all the project.
We would like to do only the 4 lines of the excel attached.
The idea is once we finalize the Spreadsheet format, to be able to add extra lines in the Spreadsheet and import it in the Chat Bot in 1 click.
So, when a customer opens the chat, it should greed him with a text:
"Hello,
I am XXX, a bot.
Do you need help with:
Here it should provide the “General category” from the list in Column A
After the customer picks the category it should provide “ Sub Category 1” the the list in Column B
After the customer picks the sub category 1 it should provide “ Sub Category 2” the the list in Column C
We would like when a user writes a keyword, to reply with the Subcategory/Answer that appears on the right of each keyword found in the excel.
But we would like to see when we type the keyword “LOST PASWORD” how to reply with the previous category/subcategory."
!!!!!!!!The lost password has nothing to do with changing the password in the server.!!!!!!!!!!!!!!
It is just an example to show that you can have duplicate keyword in the excel.
When a user put a question with a keyword which belongs to many categories, to provide to user the question that belongs one category above, in order to avoid any misunderstanding.
So for example if a user write "forgot password", the bot should put 2 buttons: 'Web Check In' and 'Already and Affiliate' ?
Like that if user click:
- 'Web Check In', the answer will be 'If you cannot find your log in details and you do not have the e-mail sent to you upon registering'
- 'Already and Affiliate', the answer will be 'In case you lost your password for the check in, will got to the following page and put your email'
Finally, we would like to study the Json backup files generated by dialog flow, in order to be able to convert the total final excel, directly to Json files.
We are open to any other technology (chat gpt, watson etc...) to achieve the demo project and once we are convinced you can do it to give you all the project.