In the following example we'll show you how we automate sending data collected by bot to fill in a basic lead form in Google Sheet. The chosen data will appear in your Google Sheet file automatically once you set it up! #2. You must determine what data collected by your bot will be sent to Google Sheets by mapping data fields (column in your worksheet) with the data saved in your BotStar bot.
#GOOGLE CHATBOT FOR SHEETS UPDATE#
Select the Spreadsheet & the Worksheet: Select from the drop-down the spreadsheet you want to connect with this Google Sheet Update block, as well as the specific worksheet where the new data will be saved in.įield Mapping: Define what information will be sent to what column in your worksheet.
#GOOGLE CHATBOT FOR SHEETS HOW TO#
How to setupĭrag and drop action Update Google Sheet block in the bot flow. When your chat user passes through this flow, their data will be pushed to your Google Sheet file and displayed in a new row. This action sends data collected by BotStar to your spreadsheet. You can now easily send data out to Google Sheet or retieve data from Google Sheet file to your chatbot. Query: search, access, retrieve data and bring it in (from Google Sheets) to your bot.ĭrag and drop action Update/ Query Google Sheet in the bot flow based on your use case. Update: send data out to Google Sheets, or edit data in the spreadsheets within your Google account. Jump to our visual builder after you complete the integration step, you can choose what actions to perform every time a reachable user interacts with a bot. Make sure to connect to the correct Google account that will use the spreadsheet.
You will be asked to integrate your google account. Head to Bot Builder > Integrations and scroll down a bit to find Google Sheet Integration section > toggle it on and click Connect. If you want to change the structure of your spreadsheet/worksheet in the middle of the setting process, you must go to your Google Sheets Action and reload the chosen Spreadsheet and Worksheet fields.Īfter creating/checking your worksheet, let's go back to the flow and connect your Google account to BotStar to use the Google Sheets Integration.
Note: The spreadsheet should be created in its final version before you enable integration. Head to your Google Sheet account, create a worksheet with column names on the first row of the document. To use this feature, you must have a spreadsheet in your Google Sheet account first. #Connect BotStar to your Google Sheet account #1. Take a look at this document to learn how to connect your BotStar Account to Google Sheets, and transfer your user’s data back and forth without a single line of code. To be specific, this feature allows you to search, access and edit data in the spreadsheets within your Google account automatically. It got much easier - now you can connect your existing Google Sheet account to BotStar without using any third-party apps.
0 kommentar(er)
