How to quickly create a large Dialogflow Messenger bot

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.

Link to the tool

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.


About this website

I created this website to provide training and tools for non-programmers who are building Dialogflow chatbots.

I have now changed my focus to Vertex AI Search, which I think is a natural evolution from chatbots.

Note

BotFlo was previously called MiningBusinessData. That is why you see that watermark in many of my previous videos.