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. This step-by-step tutorial covers the entire integration process. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To create a Mailchimp subscriber from Google Forms responses, first, access Pabbly Connect. This platform is essential for automating the integration between Google Forms and Mailchimp.

Visit the Pabbly Connect homepage by browsing to the Pabbly website. Here, you will find options to sign in or sign up for free. If you are a new user, click on ‘Sign Up Free’ to get started. Existing users can simply sign in to access their dashboards.

2. Creating a Workflow in Pabbly Connect

After logging into Pabbly Connect, the next step is to create a new workflow. Click on the ‘Create Workflow’ button located in the top right corner of the dashboard.

• Name your workflow as ‘Create Mailchimp Subscriber from Google Forms Response’.
• Select a folder for organization, such as ‘Automations’.
• Click on the ‘Create’ button to finalize your workflow setup.

With the workflow created, you can now set up the trigger application. Select Google Forms as the trigger application and choose ‘New Response Received’ as the trigger event. This allows Pabbly Connect to capture new responses automatically.

3. Linking Google Forms to Google Sheets

To connect Google Forms with Pabbly Connect, you need to link it to Google Sheets. In your Google Form, navigate to the ‘Responses’ tab and click on ‘Link to Sheets’. This action creates a new spreadsheet to store responses.

Confirm that the new spreadsheet has fields corresponding to the form inputs, such as Timestamp, First Name, Last Name, Email, and Phone Number. Now, you can test the integration by submitting a sample response in the Google Form.

• Submit a test entry through the Google Form.
• Check the Google Sheets to ensure the response appears correctly.

Once confirmed, proceed to connect Google Sheets with Pabbly Connect to complete the automation process.

4. Setting Up Webhooks in Google Sheets

To have Google Sheets communicate with Pabbly Connect, install the Pabbly Connect Webhooks add-on. Click on ‘Extensions’ in Google Sheets, then ‘Add-ons’, and select ‘Get Add-ons’. Search for ‘Pabbly Connect Webhooks’ and install it.

After installation, go back to the ‘Extensions’ menu, select ‘Pabbly Connect Webhooks’, and click on ‘Initial Setup’. Here, you’ll enter the webhook URL provided by Pabbly Connect and specify the trigger column, which is typically the last column where data is entered.

Paste the webhook URL from Pabbly Connect. Set the trigger column to the final data column (e.g., Column E).

After configuring, click on ‘Submit’ to finalize the setup. This allows Pabbly Connect to capture data whenever a new response is added to Google Sheets.

5. Adding Mailchimp as the Action Application

The final step in your workflow is to set Mailchimp as the action application in Pabbly Connect. Select Mailchimp and choose ‘Add a New Member with Custom Fields’ as the action event. This will enable you to create a new subscriber based on the Google Forms response.

To connect Mailchimp, click on ‘Connect’ and select ‘Add New Connection’. You will need to enter your Mailchimp API key and Data Center. To find your API key, log into your Mailchimp account, navigate to your profile, and access the API keys section.

Copy the API key and paste it into Pabbly Connect. Enter your Data Center, which can be found in the Mailchimp URL.

Once connected, map the fields from the Google Forms response to the Mailchimp fields, such as email address, first name, and last name. After mapping, click on ‘Save and Send Test Request’ to verify the integration.

Conclusion

In this tutorial, we successfully demonstrated how to create a Mailchimp subscriber from Google Forms responses using Pabbly Connect. By following these steps, you can automate the process of adding subscribers to your Mailchimp account seamlessly.