If you have been using Dialogflow ES for a while, you might have noticed that it can be quite tedious to create large FAQ chatbots because the interface gets slower as you keep adding more intents.
Bulk upload intents from a spreadsheet
One of the easiest ways to create a large FAQ chatbot is to type everything into a spreadsheet file and then convert it into an agent ZIP file which you can import directly into Dialogflow. You could already do this using the CSV to ZIP file converter in my BotFlo app.
This approach has many benefits – it is much faster, it is easier to get a quick overview of your bot training phrases and it is also better suited for collaborative editing.
Dialogflow Messenger custom payload
The big downside to this approach is that it is very hard to type the rich responses for suggestion chips, clickable hyperlinks etc (which need to be specified in JSON format) into a CSV file.
I have recently figured out a workaround – remove all whitespace from the JSON (it is still valid when you do that) and add this compressed (minified) JSON into the spreadsheet cell. The Dialogflow agent ZIP file also accepts this minified JSON as a payload.
How to generate the custom payload JSON
In addition, you can use the visual editor for generating the custom payload JSON in BotFlo. This automatically creates a minified (i.e. compressed) version of the custom payload JSON which you can copy and paste directly into the spreadsheet. You can see an example below.