Some time back, I created a tool called the Dialogflow CSV Importer which could take a CSV file and convert it into a Dialogflow agent ZIP file with a single click.
It got a lot of positive reviews such as these:
Aravind’s CSV Upload tool is extremely helpful for non-coders or those more comfortable working from a spreadsheet interface to quickly create an intelligence Dialogflow bot with context. - Deborah K
Thank you Aravind for this mighty little tool. This is amazing! It simply converts a ton of work hours into few seconds.
It’s a life saver! Thanks again! - Muhammad H
As a non-technical user, entering content in Dialogflow was repetitive and time-consuming at best. Lather, rinse, repeat…and repeat….and repeat. Aravind’s CSV importer is a game changer. With it, you can build and store your core content in a spreadsheet or table where it is easily updated and reviewed in a commonly viewed interface. Then, when you’re ready, you can batch update or import the entire thing – saving you tons of time! Worth every penny! Highly recommended! - Randy R
Bot Generators software is worth the price of the bundle alone. - Micheal G
But it also had many limitations.
Since it was a desktop app, there were quite a few features I couldn't even implement. For example, converting the agent ZIP file from Dialogflow back into CSV (because the format is very complex, and changes very often).
So I have now released a web based version of the Dialogflow CSV Importer.
And it includes a free demo, which you can first try out and then decide if it does the job.
The tool is still in Beta and will be until end of Jan 2020. In fact, when you log in, you will notice that there isn't even a Logout button yet.
But the app works as before. And it has all the features of the desktop app already.
And the Logout button will also be added soon. 🙂
Here are the steps to turn your CSV file into a Dialogflow agent ZIP file.
First sign up for Airtable
2 Make a copy of the base
Then go to this Airtable base and make a copy into your own Airtable account
3 Modify and download one of the CSV formats
You will notice that there are 3 formats.
First you need to understand the difference between the 4, 8 and 10 column formats. (Described at the bottom of this article in the section "Understanding the different CSV column formats").
Then you can make the updates in your own table and download the CSV.
4 Login to the CSV Importer web app
You can access the app here.
Note: It is running on a free Heroku account for now, so it might take a while to load the page. After the page loads for the first time, the app should be pretty fast.
You first need to login using your Google account.
5 Select the language from the dropdown list
Then select the language of your agent from the dropdown list once you log in.
You can use only one language per agent at the moment, but this is something which we will update soon. (Do you need multiple languages in the same agent? Leave a comment below this article)
6 Select the CSV file
First select the appropriate CSV file from your local machine by clicking on the "Choose File" button
7 Upload the CSV file
Now click on the Upload button.
You will be able to see a Preview of all the data from the CSV file.
7 Download agent ZIP file
On the same page, you will also see a button at the top named Download. Clicking on the button will download the agent's ZIP file to your local machine.
8 Use Dialogflow's Restore ZIP
Now you can use Dialogflow's Restore ZIP feature to restore the agent ZIP file.
9 Test the agent
You should be able to test the agent inside the Dialogflow simulator. For example, if you used the sample CSV file from Step 2, you will get the following response in the simulator.
For trial users, you can have up to 5 rows per intent, and a max of 100 rows per CSV file. This limitation is removed for paid users.
How to upgrade to paid version
If you are happy with the trial, you can upgrade to the paid app which doesn't have any of the limitations imposed by the trial app.
While the web app is in Beta, you need to buy any course priced at $29 or more from my course website, and then send me an email requesting access to the CSV Importer web app.
When you purchase the course, you will get a confirmation email. Just reply back to that email asking for access. In the email, tell me the GMail address you would like to use for the web app.
Understanding the different CSV column formats
Do you have any thoughts? Feature requests? Bug reports? Suggestions for UX improvements?
Please leave a comment below. (All comments are moderated, so it might be a few hours before they show up).
- Client Question: Can I use GPT2 for my Dialogflow bot?
- Weekly Free Mini Courses
- 15 things all Dialogflow bot makers should know
- Autogenerating FAQ bot from training text
- A MUST read article on Dialogflow training phrase quality
- Using Collect.chat for preNLU bots
- Reader Question: How to get some sample training data for Dialogflow?
- Getting the top 3 (or top N) intents in Dialogflow: An experiment
- Dialogflow Regexp (regular expression) entity
- Using Dialogflow for educational bots