Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start integrating Google Sheets with Mailchimp, first, you need to access Pabbly Connect. This platform allows you to automate tasks without any coding skills. Head over to the Pabbly Connect website by searching for ‘pabyt.com/connect’.

If you’re a new user, sign up for free to receive 100 tasks every month. This will let you explore the features of Pabbly Connect and see how it can streamline your workflows.

2. Creating a Workflow in Pabbly Connect

Once you’re on the Pabbly Connect dashboard, click on the “Create Workflow” option. This feature allows you to set up the automation process between Google Sheets and Mailchimp. You can choose to create a workflow using AI, which helps analyze your request.

  • Select the event to trigger the workflow.
  • Set Mailchimp as the action application.
  • Specify the Google Sheets data to be sent to Mailchimp.

After setting these parameters, approve the workflow, and it will automatically create a template for you. This is where Pabbly Connect shines by simplifying the setup process.

3. Setting Up Google Sheets with Pabbly Connect

Next, you need to connect Google Sheets to Pabbly Connect. Open your Google Sheets and look for the extensions tab. Here, search for “Pabbly Connect Webhooks” and install the add-on. This will allow Google Sheets to communicate with Pabbly Connect.

Once installed, refresh the spreadsheet and navigate to Extensions > Pabbly Connect Webhooks > Initial Setup. You will be prompted to enter the webhook URL provided by Pabbly Connect and specify a trigger column. For this integration, the trigger column will be the one where the phone number is entered.

4. Testing the Integration Between Google Sheets and Mailchimp

To ensure everything is working, you’ll need to test the integration. Add a new subscriber’s details in Google Sheets, including their first name, last name, email, and phone number. Once you input this data, check back in Pabbly Connect to confirm that the webhook response captures the data correctly.

If successful, you will see the details appear in the trigger response. This verifies that the connection between Google Sheets and Pabbly Connect is functioning properly. Now, you can proceed to add this subscriber to Mailchimp.

5. Adding the Subscriber to Mailchimp via Pabbly Connect

After confirming the webhook response, it’s time to add the subscriber to Mailchimp. In Pabbly Connect, click on the connect button and provide your Mailchimp API key and data center. This step is crucial as it establishes the connection between Mailchimp and Pabbly Connect.

Once connected, select the audience list where you want to add the subscriber. Map the data from Google Sheets to the corresponding fields in Mailchimp, such as email address, first name, and last name. After mapping, click on the “Save and Send Test Request” button to finalize the process.

Upon refreshing your Mailchimp contacts page, you should see the new subscriber added successfully. This automation not only saves time but also ensures that your subscriber list is always up-to-date without manual intervention.

Conclusion

Integrating Google Sheets with Mailchimp using Pabbly Connect automates the subscriber management process, making it efficient and error-free. With this setup, any new subscriber added in Google Sheets will automatically reflect in your Mailchimp account, streamlining your email marketing efforts.