How to Save Chatbot Contact Email to Google Sheets Using Pabbly Connect

Learn how to save chatbot contact emails to Google Sheets using Pabbly Connect. Follow this step-by-step guide for seamless integration with Joonbot. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To save chatbot contact emails to Google Sheets, you need to start by accessing Pabbly Connect. Open your web browser and type the URL Pabbly.com/connect. This will take you to the Pabbly Connect landing page.

If you are a new user, click on the ‘Sign Up for Free’ button to create an account. Existing users can simply sign in. After signing up, you will receive 100 free tasks to get started. Once logged in, navigate to the dashboard where you can create a new workflow.

2. Creating a Workflow in Pabbly Connect

In Pabbly Connect, the next step is to create a new workflow. Click on the ‘Create Workflow’ button. You will be prompted to name your workflow; for this integration, name it something like ‘Save Chatbot Contact Email to Google Sheets’ and click on ‘Create’.

• Choose Joonbot as your trigger application.
• Select ‘Configure Webhooks’ as the trigger event.

After selecting the trigger event, you will receive a webhook URL. This URL acts as a bridge between Joonbot and Pabbly Connect. Copy this URL as you will need it to set up the webhook in Joonbot.

3. Setting Up Joonbot for Webhook

Now that you have your webhook URL, log into your Joonbot account. In the Joonbot interface, select the chatbot you want to use for this integration. Scroll down to the ‘Trigger a Webhook’ option and click on it.

• Create a new webhook and name it ‘Google Sheets Integration’.
• Select POST as the webhook method.
• Paste the copied webhook URL into the URL field.

Once you have entered all the details, click on ‘Create’. This successfully creates the webhook in Joonbot, allowing it to communicate with Pabbly Connect.

4. Testing the Webhook Connection

To ensure that the webhook is working, you need to perform a test submission. Go back to Pabbly Connect and click on ‘Test Webhook’. This will prompt you to send a test request from Joonbot.

In Joonbot, navigate to the chatbot preview and fill in the required fields, including name and email address. After submitting the information, return to Pabbly Connect to check if the webhook response has been recorded. You should see the test data reflected in the webhook response.

5. Adding Data to Google Sheets

The final step is to set up Google Sheets as the action application in Pabbly Connect. Click on ‘Add Action’ and select Google Sheets. Choose ‘Add New Row’ as the action event.

Connect your Google account by clicking on ‘Add New Connection’. Once connected, select the spreadsheet and the specific sheet where you want the data to be added. Map the fields from the webhook response to the corresponding columns in Google Sheets, such as name and email address. Finally, click on ‘Save and Send Test Request’ to complete the setup.

Conclusion

In this tutorial, we explored how to save chatbot contact emails to Google Sheets using Pabbly Connect. By following these steps, you can automate the process of capturing contact information from Joonbot directly into your Google Sheets, enhancing your data management efficiency.