This integration allows you capture information submitted on your Bot's built-in user form and automatically save the captured data into a Google Spreadsheet.

Step 1 - Setup the Built-in User Form & Sample Data

1. Go to the Bot's SETTINGS > USER FORM page to setup the form fields and enable the form. Read this step by step guide to learn How to Collect Data with a USER FORM

   

Step 2 - Prepare the Google Spreadsheet

1. Log in to https://drive.google.com

2. Click the [+ New] button, then create a [Blank Spreadsheet]

3. Rename the untitled spreadsheet so you can easily find it in the next steps

   

4. Add the form field titles on the first row.

   

Step 3 - Generate a zapier key

1. In your Botsonic account, go to your account [Integrations] page. Click [Settings] from the left-hand side bar or select [Integrations] from your Avatar dropdown menu.

   

2. Click on Zapier's [Connect] button to generate the Zapier Key. Copy the Zapier key to your clipboard, you'll need it in the next steps, but you can always go back to this page to copy it later.

   

Step 4 - Connect & Install

1. Go to your "Your Bots" Page and click on a bot. If you haven't created a Bot yet, read this Quick Start Guide.

   

2. Click [Integrations] from the left hand side menu, then click [Apps]

   

3. Look for the [Capture User Form] integration. Click [Connect], then click [Install]

   

4. Search and select [Google Sheets] on Zapier's Botsonic integrations page.

   

5. Click [Connect these apps]

   
   

Step 5 - Set up the trigger

1. Give your Zap a name

2. Click the [Trigger] box, then search and select "Botsonic" as the trigger

   

3. Click the [Botsonic trigger box] to open up the trigger settings. Select "New Form Entry" from the [Event] dropdown] field, then click [Continue]

   

4. Click [Sign in], then sign-in to your Botsonic account

   

5. Click the [Sign in] button to open the Zapier dialog box. Enter the Zapier Key, then click [Yes, Continue to Botsonic]

   

6. Select the Bot you want to connect from the dropdown options, then click [Continue]

   

7. Click [Test trigger]

   

8. Click [Continue with selected record]

   
   
   

Step 6 - Set up the action

1. Choose an Action. Search and select [Google Sheets]

   
   

2. Search and select [Create Spreadsheet Row], then click [Continue]

   
   

3. Click [Sign in] and log into your Google Account, then click [Continue]

   

3. Fill out and select the following fields:

   • Drive: My Google Drive
   • Spreadsheet: search and select the spreadsheet where you want the captured data to be saved
   • Worksheet: search and select the worksheet
   
   

4. Select and map out the spreadsheet header titles with the Botsonic user fields, then click [Continue]

   
   
   

5. Click [Test Step]

   

6. Go to the spreadsheet to check if the test was successful

   

Step 7 - Publish the Zap

When you're ready, click the [Publish] button to start using the Zap with your Botsonic chatbot