Build a Dialogflow chatbot with Google Spreadsheet integration

Подписаться 1,7 тыс.

Просмотров 15 тыс.

50% 1

This time we are going to make a Dialogflow chatbot that will validate some details from the content of a Google Spreadsheet and store it to another tab using SheetDB.
GitHub repo here: github.com/sheetdb/dialogflow...
Corrections:
2:40 - I made a typo in the intent's name which is later duplicated in the code, so everything works fine.
10:10 - That line of code should actually look like this:
`const doctor = agent.parameters.doctor.name;`
🌍 SheetDB website: sheetdb.io
😎 Snippets to use: sheetdb.io/use-cases/submit-t...
✉️ Mail us at support@sheetdb.io

Наука

Опубликовано:

17 апр 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 21

@humbertoromanojr 3 года назад

Thank you very much for the video and sharing knowledge, great your video

@muthukumarpanneerselvam7255 2 года назад

Very useful 😊😊

@vivian_rchen2618 2 года назад

Thank you very much for the video！ But I got no response from dialogflow (if I set the response at the intent page, I'll only get the response from there, not what I typed on index.js ), and googlesheet didn't update a new row. Also, I got "Warning, FIREBASE_CONFIG environment variable is missing. Initializing firebase-admin will fail" from log. Is FIREBASE_CONFIG the main reason causing the error？ How could I do to fix it？

@matimeoq Год назад

Thank you so much for the video! Everything works well, but there is an issue when dialogflow and Sheet DB api use the data in other languages. JSON uses some kind of encoding for other languages except English, so dialogflow does not recognize data

@juanandreslopezcubides5626 2 года назад

Could you to explain that but with dialogflow CX?

@ertieabana4077 2 года назад

how to show value back in dialogflow?

@LocNguyen-ml9od 3 года назад

15:44 I have come to this part. But only see " created" not see the parameter of " created" on sheetdb @@ . pls help, thank for video

@sheetdb 3 года назад

Please email us at support@sheetdb.io or use our support chat at our website: sheetdb.io. We'll try to help you with all the issues you experience.

@LocNguyen-ml9od 3 года назад

@@sheetdb thank you very much.I have 1 more error. Function (appointment) works, but the (fallback) function is not in the code. I followed the video @@

@kenjimr6107 2 года назад

Thanks for the great video. I've implemented it using this video and the code in the overview section. axios.post succeeded, but axios.get failed. Do you know anything about this?

@muhamedkozic9440 Год назад

When i go to Deploy, it say "error happened during cloud functions deployment". Why?

@BusinessBananaShikhe 3 года назад

Nic Very nic can u explain of Google Sheet PMS

@user-yl7os7mg8k 10 месяцев назад

It's not working ! I even copy the whole code from Github and paste (added my sheetdb link) still nothing in the excel.

@meghnasood1807 3 года назад

I followed the exact same steps but I'm getting the response that "I'm sorry, I don't recognize this doctor"

@sheetdb 3 года назад

Have you noticed my correction of one line of the appointment function given in caption at 10:14? It should be: const doctor = agent.parameters.doctor.name;

@meghnasood1807 3 года назад

@@sheetdb Yes I changed that but still it's showing the same response

@sheetdb 3 года назад

@@meghnasood1807 It will be hard to find such a problem at a distance, here's a code you can compare - github.com/sheetdb/dialogflow-example/blob/master/index.js The stars on line 42 are also important. Try to debug it using the url from line 42 and your query, e.g. sheetdb.io/api/v1/23b3197b2c9k7/search?name=*quinn*, should return the details of the doctor.

@SAGARTHAKUR-zn7vq 3 года назад

Is this free of cost?

@sheetdb 3 года назад

The SheetDB trial plan offers 2 spreadsheet APIs and up to 500 requests per month and it never ends, however with one of our subscription plans you'll get much more than just extending those limits. For more info visit sheetdb.io/pricing