Integrate Google Forms with BigCommerce Using Pabbly Connect: A Step-by-Step Guide

Learn how to automate customer creation in BigCommerce from Google Forms submissions using Pabbly Connect with this detailed tutorial. No coding required! Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for Integration

To start the integration process, you need to access Pabbly Connect. First, open your browser and navigate to the Pabbly Connect homepage by typing ‘Pabbly.com/connect’. Here, you will find options to sign in or sign up for free.

If you are a new user, click on the ‘Sign Up for Free’ button. This will allow you to create a new account in just a couple of minutes, and you will receive 100 free tasks monthly. For existing users, simply click ‘Sign In’ to log into your account. Once logged in, you can access the Pabbly Connect dashboard to create your workflows.

Creating a Workflow in Pabbly Connect

After accessing the dashboard of Pabbly Connect, you need to create a new workflow. Click on the ‘Create Workflow’ button, which will prompt you to name your workflow. For this tutorial, name it ‘Create BigCommerce Customers on Google Form Submission’.

Next, select a folder to save your workflow. You can create a specific folder for e-commerce automations. Once you have named your workflow and selected the folder, click ‘Create’. You will see two main sections: Trigger and Action. The trigger is the event that starts the workflow, while the action is what happens as a response.

Setting Up the Trigger with Google Forms

The first step in your workflow is to set up the trigger. For this integration, select ‘Google Forms’ as your trigger application. The trigger event should be set to ‘New Response Received’, which captures the form submission.

After selecting the trigger event, you will be provided with a webhook URL. This URL will connect your Google Forms to Pabbly Connect. Copy this webhook URL and proceed to your Google Forms. In your Google Forms, navigate to the ‘Responses’ section and click on ‘Link to Sheets’ to create a new Google Sheets document that will store the form responses.

• Open Google Forms and click on the ‘Responses’ tab.
• Click on ‘Link to Sheets’ and create a new spreadsheet.
• Submit a test response to ensure data is being recorded.

This will allow the data from new form submissions to be recorded in Google Sheets, which will then be sent to Pabbly Connect automatically.

Configuring Google Sheets to Send Data to Pabbly Connect

Once you have linked your Google Form to Google Sheets, you need to set up a connection to send data to Pabbly Connect. Go to the Google Sheets where your form responses are recorded. Click on ‘Extensions’, then ‘Add-ons’, and select ‘Get Add-ons’. Search for ‘Pabbly Connect Webhooks’ and install it.

After installing the add-on, refresh your Google Sheets. Under ‘Extensions’, you will now see ‘Pabbly Connect Webhooks’. Click on ‘Initial Setup’ and enter the webhook URL you copied earlier. Specify the trigger column, which is the last column in your sheet that will contain data. This setup will ensure that whenever a new row is added, the data will be sent to Pabbly Connect.

• Select ‘Extensions’ and click on ‘Pabbly Connect Webhooks’.
• Click on ‘Initial Setup’ and paste the webhook URL.
• Specify the trigger column to send data when a new row is added.

Once the initial setup is complete, you can test it by submitting a response in your Google Form. The data should appear in your Google Sheets and be sent to Pabbly Connect.

Creating Customers in BigCommerce

Now that you have set up the trigger and connected Google Sheets to Pabbly Connect, it’s time to create customers in BigCommerce. Go back to your Pabbly Connect workflow and set the action application to ‘BigCommerce’. Choose the action event as ‘Create Customer’.

To connect your BigCommerce account, you will need to enter the Store Hash Key, Client ID, and Access Token. You can find these credentials in your BigCommerce account under ‘Advanced Settings’ and ‘API Accounts’. Once the connection is established, map the fields from the Google Sheets response to the BigCommerce customer fields.

Select ‘BigCommerce’ as the action application in Pabbly Connect. Choose ‘Create Customer’ as the action event. Enter your Store Hash Key, Client ID, and Access Token from BigCommerce.

After mapping the necessary fields such as first name, last name, email, and phone number, you can test the action. Once confirmed, every new Google Form submission will automatically create a customer in your BigCommerce store through Pabbly Connect.

Conclusion

In this tutorial, you learned how to automate the process of creating BigCommerce customers from Google Forms submissions using Pabbly Connect. This integration allows you to streamline your customer management without any coding skills. By following these steps, you can efficiently manage customer inquiries and enhance your e-commerce operations.