How to Create Mailchimp Subscriber from Google Forms Response Using Pabbly Connect

Learn how to create a Mailchimp subscriber from Google Forms responses using Pabbly Connect. Follow this step-by-step guide for seamless integration. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To create a Mailchimp subscriber from Google Forms responses, we will use Pabbly Connect. First, access the Pabbly Connect homepage by visiting the official website. If you are a new user, click on ‘Sign Up Free’ to create an account and receive 300 tasks for free each month.

If you already have an account, click on ‘Sign In’. After signing in, you will be directed to the Pabbly Connect dashboard. Here, you can start creating your workflow by clicking on the ‘Create Workflow’ button located in the top right corner.

2. Creating a Workflow in Pabbly Connect

In the workflow dialog box, name your workflow ‘Create Mailchimp Subscriber from Google Forms Response’. Select a folder for your workflow, such as ‘Automations’, to keep your tasks organized. Click on the ‘Create’ button to proceed. using Pabbly Connect

• Select the trigger application as Google Forms.
• Choose the trigger event as ‘New Response Received’.
• Copy the webhook URL provided by Pabbly Connect.

This setup allows Pabbly Connect to capture responses from Google Forms. Ensure you have your Google Forms ready to link with Pabbly Connect.

3. Linking Google Forms to Google Sheets

To connect Google Forms with Pabbly Connect, you first need to link Google Forms to Google Sheets. In your Google Form, navigate to the ‘Responses’ tab and click on the ‘Link to Sheets’ option. Create a new spreadsheet for storing the responses. using Pabbly Connect

Once the Google Sheet is created, it will automatically populate with fields such as Timestamp, First Name, Last Name, Email, and Phone Number. This data structure will be important for the next steps. After ensuring that the Google Sheets connection is working, you can proceed to install the Pabbly Connect Webhooks add-on.

• Go to Extensions > Add-ons > Get Add-ons.
• Search for ‘Pabbly Connect Webhooks’ and install it.
• After installation, go back to Extensions and click on ‘Pabbly Connect Webhooks’ for initial setup.

After setting up the add-on, you can enter the webhook URL copied from Pabbly Connect and specify the trigger column as the final data column (e.g., Column E). This setup allows Pabbly Connect to capture the data whenever a new response is submitted in Google Forms.

4. Connecting Google Sheets to Pabbly Connect

After linking your Google Form to Google Sheets, you need to ensure that new responses are sent to Pabbly Connect. In Google Sheets, go to Extensions > Pabbly Connect Webhooks > Initial Setup. Here, paste the webhook URL and set the trigger column to the last column of your data (e.g., Column E). using Pabbly Connect

After configuring the initial setup, click on the ‘Send Test’ button to verify that data can be sent to Pabbly Connect successfully. Ensure that the response is captured in Pabbly Connect by checking the dashboard.

Enable ‘Send on Event’ in the Pabbly Connect Webhooks options. This ensures that every new response in Google Sheets triggers a capture in Pabbly Connect.

Once this setup is complete, you will see the responses from Google Forms appearing in Pabbly Connect as they are submitted.

5. Setting Up Mailchimp Integration in Pabbly Connect

Now that Pabbly Connect is capturing responses from Google Forms, it’s time to set up Mailchimp as the action application. In Pabbly Connect, select Mailchimp as the action application and choose the action event as ‘Add a New Member with Custom Fields’. This action will create a new subscriber in your Mailchimp account using the data from Google Forms. using Pabbly Connect

To connect Mailchimp with Pabbly Connect, click on ‘Add New Connection’. You will need to provide your Mailchimp API key and Data Center. To obtain your API key, log into your Mailchimp account, navigate to your profile, select ‘Extras’, and then ‘API Keys’. Generate a new API key and copy it into Pabbly Connect.

Enter the API key and specify your Data Center (e.g., us6). Select the audience list to which you want to add subscribers. Map the fields from Google Forms to Mailchimp fields (Email, First Name, Last Name, etc.).

After mapping the fields, click on ‘Save and Send Test Request’ to ensure that the integration works correctly. You should see a new subscriber in your Mailchimp account reflecting the data submitted from Google Forms.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to create Mailchimp subscribers from Google Forms responses. By following these steps, you can automate your subscriber list efficiently and effectively, ensuring that every new response is captured seamlessly.