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

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 backstageincome.com 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.

Conclusion

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.

Hi Sasha, Greatly appreciate your videos and the new books. They are pretty good. You are really a genius buddy!

 

Thank you very much!

AMAZON'S BEST SELLING AUTHOR

SASHA EVDAKOV

MINDSETS OF A

MASTER

STOCK TRADER

YOUR KEY TO MASTERING THE

INNER GAME OF TRADING

Dear Sasha,

 

Thank you so much for your work, I think you are a wonderful mentor! I came across your videos few months ago and I just love listening and learning from you. I'm new in trading and I believe with your help I will succeed:)

FREE Guide to the Best Cameras for a Youtuber

Eager to find out which cameras are the top choices to producing and recording videos?

 

Grab my FREE Guide below by entering your name and email address... 

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

Video Gear Guide for YouTubers

Ready to improve your YouTube channel? If you want to see the best YouTube gear for YouTubers then download my latest gear guide!

 

Enter your name and email below to get started...

FREE DOWNLOAD

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

Want to Create Videos that Convert Viewers into Buyers?

Are you tired of making videos that don't produce results?

 

Get my Video Formula cheat sheet and see how to create videos that get clicks and attracts buyers!

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

Want to Find a Profitable Niche?

If you are interested in starting an online business and want to find the perfect niche to start making tons of money.

 

Then grab our FREE email series on how to find a highly profitable niche!

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

Want to Sell

Your Own Products?
 

This FREE information will show you how to create your first digital productand start getting sales in no time

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

Download My Youtube Video Creation Checklist for FREE...
 

Overwhelmed by number of tasks that you need to do to make high-quality YouTube videos?

 

Then grab this YouTube Video Creation Checklist if a strategic procedure list for producing your YouTube videos.

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

Download My List of The 125 Most Profitable YouTube Niches

Get my list of the 125 Most Profitable YouTube Niches. It will be an eye-opener for you!


Sign up for FREE and get extraordinary ideas...

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

Learn How to Get Thousands of

Visitors to Your Website
 

This FREE email series will show you exactly how to get thousands of real visitors to your website even if you are an absolute beginner.

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

WANT TO GROW YOUR BUSINESS?
 

If you are interested in starting your own online business and making money online.

 

Then grab our quick email series on how to start a profitable business fast!

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

FREE Stuff: Get MyOnline Business Toolbox
 

Had enough of the expensive and uselessonline business tools? Stop wasting your money and time.

 

Use my Online Business Toolbox and grow your business immediately. What's more, you'll save a ton of money.

 

If you are ready for that sign up for FREE below...

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

Profit from My 35 Local Strategies to Make Extra Money
 

Are you interested in making some money on the side? That don't need to be extra hard.

 

You can use My 35 Local Strategies to Make Extra Money and in seriously short time reap the benefits.

 

Grab this opportunity by entering your name and email below...

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

FREE Idea Bank of:
225 Profitable Pinterest Niches

Are you interested in learning whichPinterest niches are profitable?

 

Grab our FREE Pinterest Niche Guide by entering your name and email below

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

Benfit from My List of The 125 Most Profitable YouTube Niches

This is a List of the 125 Most Profitable YouTube Niches that might be a real eye-opener for you.


Sign up for FREE and gain some extraordinary ideas...

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing... 

Download My List of The 125 Most Profitable YouTube Niches

Get my list of the 125 Most Profitable YouTube Niches. It will be an eye-opener for you!


Sign up for FREE and get extraordinary ideas...

AWESOME!

In order for you to get your goodies and freebies you have to confirm your email address.

 

To confirm your email address, just go to your email inbox (or check your spam) and click the link that's inside the email that states you want to receive messages from us.

 

That's its!

Just one more thing...