With a little help from Zapier
We love Zapier. It makes our lives easier by automating things we shouldn't be doing ourselves. Among all the things we shouldn't be doing ourselves, copying and pasting CSVs ranks pretty high.
Copying and pasting CSVs ranks pretty high among the thing we don't want to do.
So how do we query data from Mailchimp?
It's actually quite simple, thanks to our friends at Zapier. We will go through the steps below, but this is what it looks like:
- Step 1: Create a Google Sheet synced with customer data from Mailchimp, using Zapier.
- Step 2: Connect the above Google Sheet to Airboxr
- Step 3: Query customer data through Airboxr
Let's go through the steps quickly:
Step 1: Create a Google Sheet synced with customer data from Mailchimp, using Zapier.
We are going to use this Zap to sync new subscribers from Mailchimp on to a Google Sheet.
You may be asked to sign into your Mailchimp when you start the process. When on the Zap, set up a trigger for New Subscriber. This will run the Zap every time a new subscriber is added to your Mailchimp list.
The next steps are pretty simple →
- On the Choose Account step, select the Mailchimp account you want to sync.
- On the Customize Subscriber step, select the audience list you wish to sync.
- On the Find Data step, Mailchimp will pull a raw of data from Mailchimp and display on screen. This is just to show that Zapier is able to pull data from your Mailchimp account. Click on Continue on this step.
Great, we're half way through! ?
Now we are going to tell Zapier to paste this data on to a Spreadsheet. Before we do that, we are going to prepare a Google Sheet into which the Mailchimp data will be pasted. We've already prepared a sample for you, go ahead and make a copy of this file.
Make a copy of synced GSheet →
This GSheet contains the headers that we will sync with Mailchimp. You may choose to add other headers to include more data you want to collect as well. Once copied, you can rename it to say "Mailchimp".
Let's go back to Zapier again.
Click on the 2. Create Spreadsheet Row in Google Sheets button. You may be asked to sign into your Google Account. Then:
- Under App, choose Google Sheets.
- Under Action Event, select Create Spreadsheet Row.
Click on Choose Account and choose your Google Account from the dropdown. Then click on Customize Spreadsheet Row and:
- Under Drive, choose 'My Google Drive'.
- Under Spreadsheet, choose the spreadsheet you copied above.
- Under Worksheet, choose Audience.
Next, just map the relevant field from Mailchimp with the right column header from GSheets by using the dropdown. E.g., under the Email Address dropdown, choose Email and so on.
Now go to the last step called Send Data and hit the button called Test and Continue. If all goes well, you're done and all new subscriber will automatically get synced to your Google Sheet. On to the next step on Airboxr.
Step 2: Connect the above Google Sheet to Airboxr
This part is easy—just copy the link to the Google Sheet you created in Step 1. Then launch Airboxr, click on Import, and paste the link in the provided box.
Step 3: Query customer data through Airboxr
Your Mailchimp data is ready for querying now. Simply hit Next and run your analysis any way you want.
That's all! ?
This is just a one-off step. Moving on, you can simply launch Airboxr on any sheet and access your Mailchimp customer data. No more downloading CSVs, running importranges, or cleaning data.