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
@@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 @@
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？
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 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.
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
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?
Thank you very much for the video and sharing knowledge, great your video
sorry new to coding. how did you connect your google sheets to the script? i dont get it. thanks
how to show value back in dialogflow?
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
Very useful 😊😊
It's not working ! I even copy the whole code from Github and paste (added my sheetdb link) still nothing in the excel.
When i go to Deploy, it say "error happened during cloud functions deployment". Why?
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
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.
@@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 @@
Could you to explain that but with dialogflow CX?
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？
I followed the exact same steps but I'm getting the response that "I'm sorry, I don't recognize this doctor"
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;
@@sheetdb Yes I changed that but still it's showing the same response
@@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.
Is this free of cost?
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
not working for me
the google sheet has to have all the sheets available_doctors, appointments, failed
Nic Very nic can u explain of Google Sheet PMS
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?