Zapier lets you connect ChatBot with many apps and 3rd party services, including Google Sheets, and lets you use the bot’s full potential.
By integrating ChatBot and Google Sheets, you can gather the user’s details in the spreadsheet each time the bot collects the information while chatting.
You must collect the user’s queries as attributes for the Zapier integration to work. Follow this article to see how to prepare your bot.
ChatBot app configuration
The first part of the integration enables you to prepare the bot for the integration.
How to prepare a Google Sheet Worksheet
Before you start configuring the Google Sheets app, remember to add headers to your worksheet. You need to select where the attributes should be saved in the worksheet.
Google Sheets Zap configuration
After you finish the first configuration stage, you must configure the rest of the Zap. You can do that after you click the Continue button in the first stage of the configuration.
-
Click the Close button.
-
Choose an app. If you wish to change the app, you can do that now.
-
Choose an event (what should happen in the sheet once the integration is triggered) from the list.
-
Choose a Google Sheets account from the list.
-
Choose the Drive, Spreadsheet, and Worksheet to which the integration should pass the attributes.
-
Select which attribute should be saved under which header.
-
Continue after you select all of the needed attributes.
-
Test the integration. You can see all of the pieces of information chosen in the previous step.
-
The test was a success. You can see the location of the attributes in the worksheet.
-
Check the test attributes sent to the worksheet.
-
Turn the Zap on now.
-
Your active Zap will appear in the bot as an orange Zapier block. Remember to publish the bot.
Editing the Zap
If you want to change the created Zap, click the Zapier block directly on your bot’s tree.
You will be redirected to the Zapier site to edit previously created Zaps.
Read more: