Dialogflow Tutorials: Integrate Dialogflow Chatbot with Google Spreadsheets - Part 2

In the last video tutorial about integrating Dialogflow with Google spreadsheets, we have shown you how to read data from a spreadsheet using APIs.

In this video tutorial, we will show you how to write data into a Google Spreadsheet using Dialogflow.

Here are some great resources on how to build your own professional chatbot:
1. Build a chatbot with DialogFlow, NodeJS and Slack

2. Build Chatbot Interactions

3. Build Better Chatbots: A Complete Guide to Getting Started with Chatbots

4. Voicebot and Chatbot Design: Flexible conversational interfaces with Amazon Alexa, Google Home, and Facebook Messenger

5. Hands-On Chatbots and Conversational UI Development: Build chatbots and voice user interfaces with Chatfuel, Dialogflow, Microsoft Bot Framework, Twilio

[geovilla]

Thank you so much. Great help for my class project. Please make a lesson also on how to edit/delete data from spreadsheet using APIs.

[nikolaibeliaev]

Thanks a lot for your tutorial! It was very helpful for me.

[setransstadia]

i am getting this error at firebase and data is not getting update at google spreadsheet.


Error: No responses defined for platform: DIALOGFLOW_CONSOLE at WebhookClient.send_ at promise.then at process._tickCallback

[dj_chopa]

Hello. I'm having a problem with my action and parameter prompts at 02:47. They are repetitive and don't record the values I input. What could be the problem and how can i solve it? Please help.

[veeraskitchen]

Hi Anshul, Great! video tutorial.I need to link Google Sheets which is going to act as a backend to retrieve data from sheets and display in chatbot when an intent is triggered.

[justbhopal]

Thanks a lot for the tutorial. But after completion of the process screen becomes blank. Please help me to give an acknowledgment after data is saved.

[AndrewLearned]

I followed your tutorials to integrate Twilio, and now this. Is there a way to pass the Twilio "from" phone number to the sheet without having to ask for it in a prompt? I'm sure there is, but haven't been able to figure it out yet...

[richardliful]

Thank you so much for this tutorial, but I have a few questions:
Do I need to install axios in some way for this to work? I have set the intent up with the spreadsheet linked from sheetbest, but when I try to run it with the hard coded data to test if it is adding onto my spreadsheet it does not work. The fulfillment status says : "Webhook call failed. Error: UNAVAILABLE."

[obicimsinema]

Hello, first of all thank you! How many parameters can we have in the fulfillment? Also is it possible to create separate intents with parameters and combine them in the same spreadsheet? I've look at Sheetbest but couldn't find the related code.

[digitalist]

Thanks for this useful video, IS IT POSSIBLE TO GET THE USERS' ID (Sender ID) TOO?
I've used your method and it works fine, BUT I need to have:
1. senders' profile link/Id... 2.I'm getting FB messages. So, knowing the Post/Ad (ID) or anything that shows which Ad/Post they are sending message about is so important for me! I really appreciate it if you reply this message.

[DanielIslasR]

Hello friend, your video is great. I have complete all your instructions but even though sheetbest does mark me the use of an attempt, the data appears empty in my spreadsheet. If it shows that an anonymous user has modified the document, when going to the history of actions, it shows me in blue color the boxes that are supposed to have been written and sent, these fields appear empty. Any idea or suggestion please?

[piotr.widziszewski]

Hey, another great tutorial, thank You ! :)

Could You help me to solve this problem ? I cannot figure out how to code that fullfilment

My case is:
- Bot is asking a questions with two possible answers A and B
- user is answering with A or B

I'd like to build questionnaire counter so if user answer A in Google Spreadsheets "1" appears under "A". If user would answer "A" again then cell value would increase to 2 (1 +1 ). So for eg. after answering 10 times to the question I would have in spreadsheets eg.
A B
7 3

Greetings

P.S.
I found sth like this on stackoverflow, but I don't know how to use that
function increment() {
+ 1);
}

[gorn]

Hi and Thanks for this Tutorial!
But...

I can't add axios because it show me error - 'axos' is not defined. When I added "import axios from 'axios';" I got red description bottom form:

The deployment of your Cloud Function failed:
Function failed on loading user code. Error message: Code in file index.js can't be loaded.
Is there a syntax error in your code?
Detailed stack trace: /srv/index.js:4
import axios from 'axios';


SyntaxError: Unexpected token import

I don't know what to do with it. How add axios to Fullfilment?

[mahammasroor]

How to store data of fallback intent into the spreadsheet?

[shreyasjani]

I want to write parameters from multiple intents to a single row in a spreadsheet but its writing the parameters of each intent in a different row, is there a workaround for this?

[anishbabu]

I followed your tutorial exactly, but the information is not writing to the google sheets. There are no errors or anything. Do you know why this is the case?

[virgilpillay]

This is a great tutorial, but can you please provide me some advice. In the fulfillment it is asking to setup Google cloud billing. I understand that I have to setup the account, but I'm afraid of the costs.
I am making a chatbot to collect information from what'sapp users, and that information will be stored in Google sheets.

Can you please advise me if this will be free on the cloud platform or if I will have to pay.

Please help me 🙏

[dayoabegunde]

@Axle Web Technologies. Thanks for this tutorial but after following through, User entities were not been recorded on the googlesheet after removing the hand coded entries and try to use the entries from users. But whenever i switch back to the hand coded entries it works again. Please can you help out

[piotr.widziszewski]

Hey, would You mind answering this two questions?
1. Is it hard to code Dialogflow chatbot who would filter through web pages and send back results to user? For example You are trying to find cheapest hotel or flight and You would have to check several pages and filter by city, $ and hotel ***.
Instead You Ask chatbot: please search 4**** hotel in NY under 1000$. And then Bot would respond with links to offers.

2. Would You do some example tutorial in near future?

[leolov]

Hi, really good and informative video. However, is there a google spreedsheet API offered by Google that we can use to achieve the same end result? (instead of using 3rd party apis by linking our sheet to them)