Grow your business, income, & life.

Behind-the-scenes training to grow your business and generating income. Strategies and mindsets that work.

Use Zapier to Automatically Backup Your Email List: Mailerlite to Google Sheets #insideBSI 2

Hey, this is Sasha.

In this post, I want to share with you how to go about adding some Zapier automation to back up your mailing list.

I want to back up my mailing list if something goes wrong. Also if you need to move mailing list companies, it’s a smart thing to do.

It’s an excellent way to back things up. 

This is the way if you want to back up your e-mail list

I’m going to create simple automation. When we go into Zapier, you could see that it automates things. I already have a couple zaps set up here that do back up some things from Aweber.

We also have Mailerlite that we use. Take a look at the resources page on our website and that way you get some insight into all the things and tools that we use.

You can see here’s AweberMailerlite to back up the Aweber list.

I also have some other things that I back up:

  • Aweber – Google sheets

That’s what we’re going to do: Mailerlite – a Google sheet. Now you could duplicate this and copy and then rearrange some things. I’m going to create a zap from scratch. This way, what we can do is take any subscribers that we have in Mailerlite here at backstage income.

We can move them to our backup list here with a new sheet. That’s what we’re going to do.

The process of creating a Zap

I’m going to create a zap – start a trigger We’re going to start it with – Mailerlite to Google Sheets Backup – BSI.

Creating a trigger: We have a new subscriber A. Hit continue.

We’ll add an action step. We’ll find Google sheets and create a row is what we want. We’ll create a row and then use that e-mail. There the spreadsheet will do the Aweber backup. I could always rename it later.

Then we’ll make a list as the BSI. This is the little corner segment meaning the sheet. There are no headers in the spreadsheet. 

We could add those. I don’t know if we need them. You’ll be able to understand what it is. And I want to see what fields they can pull because you’re not sure.

Spreadsheet & Aweber action 

I’m going to enter fields from #1 to #15.

It depends on how much data you’re trying to collect. You can rename these later because it won’t pull the top row.

We’ll hop on back to Aweber and refresh fields. There we go. Here we go field 1 – let’s say we want the name.

Here is the e-mail. We could also add the last name see depending on how tricky your e-mail newsletter set up. You could continue.

We’ll start from the beginning:

  • name 
  • last
  • e-mail
  • phone
  • city
  • state
  • zip
  • date

I can start renaming these fields in a spreadsheet. 

This is how it looks in Aweber.

This is where I tagged people as if they have interests. These are great to have, as well.

What might be useful about these interest section?

I want to add those, and so we’re going to need more fields. We’ll start looking at these things if there’s anything else besides those interests significant. However, I don’t think there’s anything else I need.

We’re going to start adding those in. The way I do it is if they have an interest in YouTube or they click something related to YouTube it’ll mark them as YES.

That way, I know that these people are interested in YouTube. 

There are other interests as:

  • ebooks 
  • blogging 
  • money 
  • website traffic
  • building leads 
  • Pinterest 
  • podcasting 
  • business stage
  • passive income

Let’s see if we have anything else. 

Well, there are interests in coaching, inner circle, survey.

These are the ones I have. The only problem is when this gets added because this is for a new subscriber. A lot of times they’re not going to have these kinds of things.

You almost have to create new update custom fields.

After populating these sections real quick in Aweber click send test button and see if it works.

This should pop up in a second, and you can see where it is.

You can see that’s what it does. Now if I had more fields than we could do that. But I don’t, so this is it.

Finish this out, turn the zap on.

And this is now going to back up things. I could make another zap to update these things.

Making another zap

Let’s say Mailerlite Update Person.

You can see if Zapier has it. Sometimes some of these integrations don’t always work the best. You can see this one targets new subscriber or subscriber added it to a group.

You’ll have different types of groups within your segment. If there’s a group that they’re added to what you could do is the following.

Let’s say a group that we’re going to add them to is they get added to the active list. Then if we add them to the active list, we can update a row. We could update some of those fields.

In my case, I don’t do that. A lot of these will probably be empty. It’s wise to back up your newsletter list. But at least to have the e-mails as a backup this is nice.

That’s one way I would do it. This is simple and automated. 

Let’s say they add another feature where subscribers updated on a field then maybe I’ll add those kinds of integrations.


That’s a quick way to use Zapier automation to backup your e-mail newsletter list to Google Sheets. And one of the ways that I do it.