How can we help?
< All Topics

How to push data collected by the bots to Google Sheets?

To store data on Google Sheets follow the below-mentioned steps:

Step 1: Create a Google Sheet

Login to your Google Sheet account and create a new sheet. Give it a name for future reference.

Step 2: Go to Integrations

Login to your botbaba account and click on Integrations under the three vertical dots.

Step 3: Go to Other Integrations

Scroll down and go to Other Integrations. Click on the Connect button next to Google Sheet.

Step 4: Select the Google account with the sheet

After you click on the Connect button, you will be asked to select a Google account on which you created the sheet. Select the right google account and give the required permission.

Step 5: Choose the Spreadsheet

Choose the spreadsheet and worksheet on which you want the data to be saved and click on Save button.

Step 6: Connect blocks with headers

Now that you have integrated Google sheets with your bot, the next thing to do is to connect the blocks with headers.

Blocks are the boxes in your bot builder which contain the questions for the data you want to receive from the user. For example, EComName, EComProducts are two blocks.

Headers are, in simple terms, heading for each row where data for a particular question has been received from various users.

For example, in the below situation; name, age and email address are headers for column A, B and C respectively.

Each block must be connected with a specific header to push data collected by the bots to Google sheets accordingly. For example, data collected by EComName block must go to header ‘Name’.

To do this, scroll down to Google sheets integration and select a block from which you want to collect data.

Now, add an appropriate header for the block. For example, for EComName block, the header will be Name, for EComPhone, the header will be Phone number, and so on.

Write down the header under the header column. You can connect as many blocks with headers by clicking on the ‘+’ sign.

Step 7: To add Variables to google Sheet Click on Variable

Enter Variable and Header

Click On Save

That’s It! That is how you can add Variables and other data to google sheet.

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Previous How to integrate webpushr with botbaba?
Next How to connect Razorpay to botbaba?
Table of Contents