Automatically generate Dialogflow intents from chat logs

Link to tool

In this article I will explain how to use BotFlo Autotrain to automatically extract Dialogflow intents from your chat logs. 

Prepare the chat logs in CSV format

The CSV format is simple. You will have two columns – ID and Text. The ID column must be unique and can be a reference to any internal identifier. The second column has the text of the user message. 

1 Log in to BotFlo if you haven’t done so already

2 From the menu, select FAQ Bots > Automatically extract intents from chat logs

3 Upload the CSV file you created. At the moment, Autotrain can process only 500 rows at a time (it is a very compute intensive process, and I don’t want to overload the server)

4 If your CSV file input is OK, you will see a message on the next page with a green check mark. Click on the Autotrain button.

5 You will be prompted to save the CSV file. 

6 Download and open this CSV file. It will look like below.

7 You can delete all except the first 4 Columns and you will have a CSV file that you can use directly inside the Basic FAQ Bot Generator.

Notes about the CSV format

The first 4 columns are the same as the regular 4 Column CSV format

Column 5 is SentID – which is the ID you used for the corresponding user message in the chat log CSV file

Column 6 is SentenceText – which is the full sentence from the chat log CSV file. Note that the “Query” field (Column 3) will usually have only a phrase extracted from this sentence, and not the entire sentence. 

Column 7 is Unique – which is a boolean value (0 or 1) which indicates whether there is only a single row in the CSV file corresponding to the IntentID. The ones which can be clustered into non-unique values (i.e. all the 0s) are in the first part of the CSV file, while those which could not be clustered (all the 1s) are at the second part of the CSV file.