Are you trying to find a way to add new MailChimp Subscribers to Google Sheets Rows? If yes, then here in this blog, we will walk you through the process of MailChimp and Google Sheets integration.

How to Add New MailChimp Subscribers to Google Sheets Rows

Basically, MailChimp is an email marketing software that helps people to grow their business by managing sales and creating a good relationship with the customers. On the other hand, Google Sheets allows you to maintain contacts, data, etc easily.

As we all know, adding every single detail of the customer one by one on Google Sheets such as name, email, address, etc is a hell lot of work. So we started looking out for software that can easily integrate MailChimp with Google Sheets. And Voila!! We found an amazing software i.e, named Pabbly Connect that can connect unlimited applications in a matter of time.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect     

This amazing software saves you from all the tedious or repetitive tasks by creating seamless workflows. With zero coding skills, you can bind unlimited applications in a minute. Pabbly Connect helps you to transfer data in real-time. Apart from that, it doesn’t restrict you on any features such as unlimited workflows, actions, triggers, etc even in its free plan.

Here, in this article, we will understand how to add new MailChimp Subscribers to Google Sheets rows using an automation tool i.e Pabbly Connect.

How to Add New MailChimp Subscribers to Google Sheets Rows (step by step)

So, let’s get started.

Step 1: Sign up to Pabbly Connect

Sign Up

Begin the process of connecting MailChimp to Google Sheets by pressing on the “Sign Up Free” icon on the Pabbly Connect dashboard. Following that, either manually fill-up all the details or else sign up using Gmail credentials.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Moreover, after login into the account, tap on the “Access Now” button of Connect.

Step 3: Workflow for MailChimp to Google Sheet Integration

(a) Start with a New Workflow

Create New Workflow

Start the process of creating a workflow of MailChimp to Google Sheets integration by clicking the “Create New Workflow” button.

(b) Name the Workflow

Name the Workflow

Additionally, add the name of workflow which in our case is “MailChimp to Google Sheet”. Although, you can always name the workflow as per your requirements.

Step 4: Setting Trigger for MailChimp & Google Sheet Integration

Subsequently, after creating a workflow, now you have to select the integration app to connect your MailChimp to Google Sheet. Using Pabbly Connect one can bind or connect unlimited apps, click here to avail your access to unlimited workflows.

(a) Select Application you Want to Integrate

Select Application you Want to Integrate

The following step is to select “MailChimp” from the dropdown, then choose the “New Subscriber” option to add the data from the software into Google Sheets.

(b) Copy the Webhook URL

Copy the Webhook URL

The following step is to copy the webhook URL which is appearing on the dashboard.

Step 5: Connecting MailChimp to Pabbly Connect

To collect product data from MailChimp, you need to paste the copied Webhook URL in the software. Hence to do that, just log in to your MailChimp account.

(a) Click on MailChimp Audience

Go to MailChimp Audience

After login into the MailChimp account, go to the side panel of the dashboard, and then there click on the “Audience” option.

(b) Go to Settings

Click on Manage Audience

Subsequently, click on “Manage Audience”, it will open up a dropdown option. Just click on the “Settings” option.

(c) Click on Webhooks Option

Click on Webhooks Option

Further, now you have to scroll down the page and click on the “Webhooks” option.

(d) Create Webhook

Add Webhook

Once you click on Webhooks, it will open up a tab with a certain option. Just click on the “Create New Webhook” option to paste the Webhook URL.

(e) Paste the Copied URL

Paste the Copied URL to How to Add New MailChimp Subscribers to Google Sheets Rows

Now, in the Callback URL, paste your copied URL from Pabbly Connect. After that select the update you want, as here I have chosen “Subscribes” and then click the “Save Webhook” button.

(f) Go to Signup Forms

Go to Signup Forms to How to Add New MailChimp Subscribers to Google Sheets Rows

Next, to test the MailChimp integration, we are going to test a form. For that, you have to click on “Audience Dashboard” and then click on the “Signup Forms” option.

(g) Fillup the Form

Fill up the Form to How to Add New MailChimp Subscribers to Google Sheets Rows

After creating the form, just fill-up the form to add the subscribers. But before hitting the button, make sure to click “Capture Webhook Response” in the Pabbly Connect dashboard.

Step 6: Test the Response in Pabbly Connect Dashboard

Test the Response in Pabbly Connect Dashboard

As soon as you add the subscriber’s details, the entry will appear on the “Pabbly Connect” dashboard. Then, click on the “Save” option.

Step 7: Setting Action for MailChimp & Google Sheet Integration

To make this MailChimp Google Sheet integration work, you have to choose the action for your trigger.

(a) Select Application you Want to Integrate

Select Application you Want to Integrate

Later, press the “(+)” icon then select “Google Sheet” and in the choose method option, select ” Add New Row”.

(b) Click the Connect Button

Click the Connect Button

Once you are done making changes, press the “Connected with Google Sheet” button. Moreover, it will open the authorization window, for which you have to log in to your Google account.

(c) Map Field Data

Map Field Data

All the sheets in your account will appear on the dropdown. Simply select the sheet, which in our case is “Sheet1”. Now, all you have to do is add the necessary field from drop-down such as for the subscriber’s name, surname, email address, etc. Subsequently, after filling all the details, save the setting and then “Send Test Request” to test the MailChimp and Google Sheet integration.

(d) Test the Submission and Save

Test the Submission and Save

Once you click on the “Save & Send Test Request” button, all the data will be sent to Google Sheet and its details will appear as a response. Then, just click on the “Save” button.

Step 8: Check Response in Google Sheet

Check Response in Google Sheet

Lastly, check the Google Sheets, as you can see all the entered subscribers’ details get auto-populated in a sheet.

Now you know how to add MailChimp Subscribers into Google Sheet. This is a one-time process, after this every time when you add a new product, it will get auto-populated in the sheet.

Conclusion –

Hopefully, now we have cleared all the confusion about the automation process. Here, in this article, we learned “How to Add New MailChimp Subscribers to Google Sheets Rows?”. All you have to do is follow all the above-mentioned steps and you can easily connect MailChimp to Google Sheets. Using this automation, one can easily avoid repetitive work. And in such cases, software like Pabbly Connect is a real savior that lets you connect unlimited premium apps.

So, don’t wait anymore. Go and get your access by signing up for a free account.

You May Also Like To Read –