How to integrate your google sheets with dialogflow agent(without inline editor)

Поделиться
HTML-код
  • Опубликовано: 27 окт 2024

Комментарии • 18

  • @NewbieNodejsDev
    @NewbieNodejsDev  3 года назад +4

    1. Creating a spreadsheet 0:35
    2. Getting shareable link 3:00
    3. Using sheetdb.io to convert sheet to api 3:47
    4. Creating Dialogflow agent 6:37
    5. Sheetdb docs 16:00
    6. Understanding API calling 16:45
    7. Coding in Part 2 -- ruclips.net/video/iLi7BHTpmnA/видео.html

    • @SAGARTHAKUR-zn7vq
      @SAGARTHAKUR-zn7vq 3 года назад +1

      Is using dialog flow free of cost?

    • @NewbieNodejsDev
      @NewbieNodejsDev  3 года назад +2

      @@SAGARTHAKUR-zn7vq Yes bro it is free of cost if you do it the way i am doing i.e. without inline editor. To use inline editor you need to pay. (If using inline editor, the content is hosted in Firebase automatically, if we use inline editor then we have to host and our code).

  • @anikroy7697
    @anikroy7697 3 года назад +2

    Awesome explanation man. Really helpful!

    • @NewbieNodejsDev
      @NewbieNodejsDev  3 года назад +2

      Tell me what tutorial or video you want next. Really happy to help you and others.That really thanks for watching means a lot to me

  • @yashbansal7266
    @yashbansal7266 2 года назад

    I have watched your video, really good explanation,I just want to ask that how should I add data in spreadsheet

  • @hardikvegad3508
    @hardikvegad3508 Год назад

    can we put our code in github and use it every time as an API in google dialogflow

  • @automatewithrezwan
    @automatewithrezwan 3 года назад +2

    i want to collect the data that i collect from the parameters to a google sheet. Is that possible?

    • @NewbieNodejsDev
      @NewbieNodejsDev  3 года назад +3

      Sure sir you can use the Post method in sheetdb.io and send data that you got from the user using the chatbot and save it in google sheets. And really thanks for watching! If you any further doubts or problems do let us know

    • @automatewithrezwan
      @automatewithrezwan 3 года назад +2

      thanks to you too

  • @mic.l4757
    @mic.l4757 3 года назад +1

    Trying to public a sheet converted to DB is that safe??

    • @NewbieNodejsDev
      @NewbieNodejsDev  3 года назад +1

      It is safe because only someone with the link can do anything to your sheets. So as long as your sheets link is safe, your DB is safe. But still this is not the proper way of storing data. If you have a small application then it is fine or else you will have to use mysql or nosql for better functionality

  • @ruchasawarkar6005
    @ruchasawarkar6005 3 года назад +1

    Can we extract two rows corresponding to same name?

    • @NewbieNodejsDev
      @NewbieNodejsDev  3 года назад +2

      Yes you can. You will get a list of all the rows with the same name.

  • @JOBMAJHA
    @JOBMAJHA 3 года назад +1

    can i make quiz bot using spreadsheet

  • @sakshambhardwaj601
    @sakshambhardwaj601 2 года назад

    is there a way to write the date(lets suppose the name here) to the spreadsheet/ database?

    • @NewbieNodejsDev
      @NewbieNodejsDev  2 года назад

      You can create an intent and use the @sys.date entity and then save it to the database as I did in this video