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

BotFlo1 was created by Aravind Mohanoor as a website which provided training and tools for non-programmers who were2 building Dialogflow chatbots.

This website has now expanded into other topics in Natural Language Processing, including the recent Large Language Models (GPT etc.) with a special focus on helping non-programmers identify and use the right tool for their specific NLP task.

1 BotFlo was previously called MiningBusinessData. That is why you see that name in many videos

2 And still are building Dialogflow chatbots. Dialogflow ES first evolved into Dialogflow CX, and Dialogflow CX itself evolved to add Generative AI features in mid-2023