Having a DataBase in Kore.ai or connecting with Google Sheets


I would like to know if there is a way to have a table with Data inside Kore.ai or if we can connect a bot to Google Sheets.

The requirement is because the user will type a product and we need to return the user all the information about this product that is found in a table.

I have seen in kore.ai you can create a table but it does not let you add information or rows to it, so wanted to know if there is a solution for this.

Thanks in advance

Hello @bruno_toulumsis_carm :smiley:,

Welcome to Kore Community :clap:

As you mentioned, we have Data Tables to save or capture data in tables. To add data to the tables we have service API’s. Determine the data you need and use the API to add it to the table.

Thank you for stopping by!!

Hello Sameera,

Thanks a lot for the response!

I see with this method you can add rows using the chatbot but from what I understand it fills the table one row at the time, is there a way to add multiple rows to the table? Or did I missed something in the link you shared with me?

Hello @bruno_toulumsis_carm ,

The specific API link shared is for simple row of data. We also have an API for bulk data as well. Check out: https://developer.kore.ai/docs/bots/api-guide/data-insert-bulk-api/

Here is the developer document for the full list of available API’s https://developer.kore.ai/docs/bots/api-guide/api-list/

Feel free to test them out.