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.
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
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.
So, let’s get started.
Step 1: Sign up to Pabbly Connect
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
Moreover, after login into the account, tap on the “Access Now” button of Connect. Start the process of creating a workflow of MailChimp to Google Sheets integration by clicking the “Create New Workflow” button. 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. 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. 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. The following step is to copy the webhook URL which is appearing on the dashboard. 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. After login into the MailChimp account, go to the side panel of the dashboard, and then there click on the “Audience” option. Subsequently, click on “Manage Audience”, it will open up a dropdown option. Just click on the “Settings” option. Further, now you have to scroll down the page and click on the “Webhooks” option. 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. 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. 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. 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. As soon as you add the subscriber’s details, the entry will appear on the “Pabbly Connect” dashboard. Then, click on the “Save” option. To make this MailChimp Google Sheet integration work, you have to choose the action for your trigger. Later, press the “(+)” icon then select “Google Sheet” and in the choose method option, select ” Add New Row”. 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. 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. 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. 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. 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.Step 2: Access Pabbly Connect
Step 3: Workflow for MailChimp to Google Sheet Integration
(a) Start with a New Workflow
(b) Name the Workflow
Step 4: Setting Trigger for MailChimp & Google Sheet Integration
(a) Select Application you Want to Integrate
(b) Copy the Webhook URL
Step 5: Connecting MailChimp to Pabbly Connect
(a) Click on MailChimp Audience
(b) Go to Settings
(c) Click on Webhooks Option
(d) Create Webhook
(e) Paste the Copied URL
(f) Go to Signup Forms
(g) Fillup the Form
Step 6: Test the Response in Pabbly Connect Dashboard
Step 7: Setting Action for MailChimp & Google Sheet Integration
(a) Select Application you Want to Integrate
(b) Click the Connect Button
(c) Map Field Data
(d) Test the Submission and Save
Step 8: Check Response in Google Sheet
Conclusion –
You May Also Like To Read –
