Importing answers from a spreadsheet directly into your bot is simple. It's a great solution for quickly teaching your bot those frequently asked questions that come in time and time again. It's also a good alternative with which to leverage the expertise of your colleagues who may not necessarily have time to log into GeckoChat themselves.
Answers can currently only be imported from a .CSV file. Let's begin by opening up a spreadsheet.
As we cover in the above video, your .CSV import makes exclusive use of the following 5 columns:
- Answer title (Column A) - The name of the answer you wish to import. No quotation marks are required. e.g:
Admissions - How do I apply?
- Questions (Column B) - The questions you want the bot to look out for in order for this answer to trigger. Quotation marks must wrap each question, and unique questions must be separated by a comma. e.g:
"How do I apply?","Am I able to apply to Gecko U now?","what are the steps for applying?","where do I go to apply","tell me about applying to ur school","i wanna apply but don't know how"
- Answer Message (Column C) - How you want the bot to respond if the questions in Column B come in? With an answer, or a skill? Answer messages must be wrapped in quotation marks. If you want to a series of messages, each message 'block' must be separated by a comma. e.g:
"That's a great question. The good news is that applying to Gecko U is easy!","To begin your journey, be sure to check out geckoengage.com and click 'Apply now'!"
- Skill (Column D) - If want your questions in Column B to trigger a skill rather than an answer, leave Column C blank and instead input the exact name of the skill you'd like to trigger. Note - your skill must already be built for this to work. No quotation marks are required. e.g:
Apply to Gecko
- Tags (Column E) - Tags can help to codify your answers, making them easier to find and manage over time. Tags must be wrapped in quotation marks and separated by a comma. e.g:
There is no cap on the number of questions or tags you can add. Nor is there a limit on the number of answers you can import at any given time. Once your import is complete make sure:
- You save it as a .CSV file.
- All answers are on the same worksheet tab.
Proceed to Bots > Answers > Import Answers. After reviewing your answers, simply confirm or reject any proposed changes and re-train your bot!
Any questions? Feel free to start a live chat with a member of our support team or explore the rest of our academy at your leisure.