Action Block: Google Sheets

This integration is only available on the Start-up or Business Plan

Google Sheets is an online version of Microsoft Excel. With the Google Sheets integration, you can dump data collected by the bot to a Google Sheet.

How do I set it up? 

Step 1: Add action block on the canvas by clicking on ‘+’ 

Step 2: Choose Google Sheets

Step 3: Configure it on right panel

Click on the ‘Google Sheets’ action block to open up the configuration panel on the right side of the screen. You will have to follow the following steps to configure ‘Google Sheets’ action block: 

Authorise the account: 

Authorise your Google account and provide all the necessary permissions asked for, so that WotNot can push the data to the Google Sheet as soon as it is captured. 

Select the sheet: 

All the sheets that are shared with you will be displayed in the dropdown. You need the select the Google Sheets where you would like the chatbot to send the data.

Select the variable: 

Select the variables that you want to dump on the selected Google Sheet.

The header row will always contain the name of the variable 

A new row is created on Google Sheets as soon as the data has been captured 

Deleting the column from the Google Sheets will lead to loss of data 

Deleting of that sheet will result in loss of data