<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1822615684631785&amp;ev=PageView&amp;noscript=1"/>

New Feature: Recurring automated email campaigns with Gmail and Google Sheets

GMass and Google Sheets togetherWith GMass, you can send emails automatically to new rows added to your Google Sheets spreadsheet.

This is the second most powerful feature we have ever built (the most powerful feature is auto follow-ups). Now, with automated recurring email campaigns, you can connect a campaign to a particular Google Sheets spreadsheet, and have your email campaign send daily (or hourly) to any new email addresses in the spreadsheet. Additionally, you can set auto follow-ups on a campaign, for a fully automated drip campaign system. Just add your new prospects to your spreadsheet, and the prospects will automatically start receiving your sequence of emails, including any auto follow-ups.

You can also configure a recurring campaign to send to all addresses in the Sheet, instead of just new addresses, to conduct a recurring reminder-style email campaign to the same set of people.

How do you set up an automated recurring email campaign?

Just check this one magical box when setting up your mail merge campaign…the one that says “Repeat daily”. You can also now set it to repeat hourly.

After connecting to my spreadsheet and composing my email campaign, I set it to repeat daily, so that this same email, and any configured auto follow-ups will send automatically to new email addresses added later to the spreadsheet.

This checkbox will show up anytime you compose a campaign after connecting it to a Google Sheets spreadsheet. It will cause the campaign to send daily or hourly, based on the time the campaign is first sent, and it will send to any new email addresses found in the spreadsheet every day or hour. If you set your campaign to have auto follow-ups, then each new email address in the spreadsheet will get the original campaign and the sequential automatic follow-up emails, based on their behavior.

How do you get new email addresses into the spreadsheet?

You can enter them manually, or you can use a number of automated systems available, like Zapier, to tie your Google Sheets spreadsheet to any number of outside databases or CRM systems.

Just add new rows and those people will get the email campaign and any associated automatic follow-up emails.
Here at my company, we house our data in a SQL Server database, and we use Zapier to push data from SQL Server into a Google Sheets spreadsheet daily. We then have a daily recurring GMass campaign set to email new GMass users every day. The campaign connects to the spreadsheet every day, finds any new rows, and sends the mail merge campaign.

New auto follow-up email option to send to “all”

Now, in addition to setting auto follow-ups based on those who didn’t reply and who didn’t open, you can also set the follow-up to go to everyone who received the original email by choosing All, regardless of their behavior. This is useful for creating for example, a series of welcome emails designed to introduce various features of your product or service to a new subscriber.
The new “All” option will send the follow-up to everyone that was part of the original campaign, regardless of whether they opened or replied.

I’ll be writing a separate article on how to use GMass and this new recurring campaign feature to create a “welcome series” email campaign to new customers. You can use this new option, with a Google Sheets spreadsheet, to fully automate a “welcome series” campaign, if your new customers are added to the spreadsheet automatically every day.

Frequently Asked Questions

Q: What’s the big deal about recurring automated email campaigns?

A: The big deal is that now instead of creating and sending a new campaign every day or every week to your new prospects, you can set your campaign up just once and still have it sent to new prospects, just by adding the new prospects to your spreadsheet. You control who gets your sequence of emails by who you add to your spreadsheet.

Q: I’ve set my campaign to recur daily, but now I’ve changed my mind and want to stop it. How do I do that?

A: Just find the campaign in your GMass Scheduled Label, open the Draft, click the GMass Settings arrow and click the red Cancel button.

Q: I’ve set my campaign to recur daily, but now I want to change the spreadsheet it’s connected to. How do I do that?

A: Once you’ve set up an automated recurring email campaign, you can’t alter the spreadsheet or the spreadsheet filter it uses. You will need to cancel the campaign and create a new one that is connected to the new spreadsheet.

Q: How are auto follow-ups related to this new capability?

A: If you create a recurring automated email campaign with auto follow-ups configured, then every day when the email campaigns sends to new rows in the spreadsheet, those new email addresses will also receive a sequence of auto follow-up emails based on whether or not they open, reply, or are just a part of the campaign.

Q: If I set a filter when connecting to my Google Docs spreadsheet, when the campaign recurs, will it only send to new rows that match the original spreadsheet filter?

A: Yes, it will. For example, let’s say you have a spreadsheet with a column called “DripCampaign” and you’ve set each row to “yes” or “no” for this column. When you use GMass to connect to the spreadsheet, you set a spreadsheet filter of “DripCampaign=yes”. When you set your campaign, you set it to repeat daily. When the campaign looks for new additions to the spreadsheet every day, it will only look for rows where DripCampaign=yes.

Q: How does this feature “know” which addresses in the spreadsheet are new?

A: When GMass checks the spreadsheet for “new” addresses, it actually grabs ALL of the email addresses and then removes the ones that have already received an email from that particular campaign. That’s how it finds all of the “new” addresses. Therefore, you can rearrange your spreadsheet in the middle of a campaign, move rows around or delete rows, and you won’t have to worry about GMass sending to an email address for a second time.

Q: I’ve sent the campaign at 4:00 PM, but I want it to recur daily at 2:00 PM instead of 4:00 PM. How can I change that?

A: Just find the campaign under the GMass Scheduled Label, click the GMass Settings arrow, and change the scheduled time to the next day at 2:00 PM, and then hit the GMass main button.

  1. Insane update, Ajay! This is great.

    In regards to using place holders: {Name}, {Site Name}, etc. in the email header, will using the automated email sequence disrupt this at all?

  2. I used this once accidentally left everyone's email in the to line instead of cutting and pasting them in to the BCC. Everyone's responses went to the entire group and drove people crazy. Thus I stopped using Gmass. Do you a way of automatically putting addresses in BCC now?

  3. It doesn't seem to be updating for me. Tried reloading Gmail and removing and reinstalling the chrome extension. Any thoughts? Would love to check this out.

  4. Hi there,

    The way that GMass works is that it sends an individual copy to each recipient, thus not sending to the whole group. The only way your email would go out to all recipients at once is if you sent it via the regular Gmail Send button. When you use GMass, there is no reason to use the BCC field, as it is sending as one email per person.

    I'm not sure when you were sending or the specifics of your campaign, but as of May of this year, GMass has tried to address this problem by hiding the Send button. GMass will hide the Gmail Send button on batches of 20+ recipients. See: http://blog.gmass.co/2016/05/we-are-now-hiding-gmail-send-button.html

    FYI – To get the best support/quickest responses from our team, see: http://blog.gmass.co/2016/11/how-to-get-best-support-from-gmass-team.html

  5. Hi Eric,

    Thanks! We're pretty excited about this feature.

    To answer your question, personalization tags will work normally. Nothing to worry about there.

  6. what ahppens when the bulk mails go out..say 1L mails fro an Email ID provided by gmail services using Gmass..will it go into spam as it happens wit most of bulk mail services like sendgrid and survey monkey etal..a reply is required to take some business decisions..rgds jk nair

  7. Hi there,

    We find that because we send through Gmail, we tend to get higher deliverability than other email marketing tools that are often marked as spam automatically.

  8. Will a campaign stop when someone who is enrolled in a campaign is removed from the source sheet at google?

    When a user enrolls for a free trial of my service, I want to send them a drip campaign. If they cancel though, I have a service to automatically remove their email from the google sheet Gmass is using. Will they stop receiving follow up emails in this scenario?

  9. I’m trying to figure this out and a lot of things are super confusing:

    1. Are you storing our emails on your servers? I delete the draft and email from everywhere, but it still appears in the follow up section.
    2. I then create the email with the same subject and two of them (if I try 4 times, 4 of them) appear under the follow up section. They all have the same names. How do I know which one is which?
    3. I then go back to the draft (and I save them as only create draft, because they’re follow ups, not campaigns, so they don’t appear under scheduled tab), and try to change the name, but even if I change nothing changes under the follow up tab. If I change the name and hit Gmass it tells me the error with the links which I have to manually replace every time?
    4. I have to a day to test follow ups? If i did something wrong, I have to wait one more day? Than one more day?
    5. Where is the manual? Do I have to query your blog every time to see how to use this?

    Could you please clarify these topics?

    1. Hello, i have that same question, i want to start using GMass, but first want to set up everything. So my question is, do i have to pay for it to see the option to repeat daily to new sheets addresses?
      Or this option is no longer available?

  10. I have done this you can easily do this step Recurring automated email campaigns with Gmail and Google Sheets. So thanks for this information I was always thinking about the how I recuring my business through Google and Gmail.

    1. Your welcome and thanks for your feedback on the ease of setting up recurring automated email campaigns.

  11. Gmail Support Have Billions of Users. Yes, Gmail is a very popular emailing service. gmail Provide most feature of email and which is absolutely free of cost, to know more about Gmail you can visit OUR WEBSITE

  12. Thanks for this article. I just ran into this problem and this was a great article. Hotmail is known for its back to back and instant services. Hotmail Support can be trusted with all the information and they are bound professionally and ethically to keep these customers’ data secret. Avail the most effective support for Hotmail to improve its efficiency. Hotmail user can contact the experienced customer care team to get proper guidance to accomplish the above-mentioned process stepwise.

  13. Many peoples are using Gmail in the world because gmail services is free of cost in the world and gmail is more secure than other email

  14. The Many Peoples are using Yes, Gmail is a very popular emailing service. gmail Provide most feature of email and which is absolutely free of cost, to know more about Gmail,

  15. I am trying to start own campaign with Email, there are many options share by you, But we have a daily recurring GMass campaign set to email new GMass every day.

    1. If you have questions or run into any issues, Please contact our support team through http://gmass.co/g/support

  16. Question

    > A: When GMass checks the spreadsheet for “new” addresses, it actually grabs ALL of the email addresses and then removes the ones that have already received an email from that particular campaign. That’s how it finds all of the “new” addresses. Therefore, you can rearrange your spreadsheet in the middle of a campaign, move rows around or delete rows, and you won’t have to worry about GMass sending to an email address for a second time.

    I have a paid AND a free plan.

    On the free plan, i have this set up and I append 50 emails each day.

    On day 1, only 50 emails. No problem. emails sent.

    On day 2, gmass tells me that I went over the free day limit b/c i’m trying to send 100… when clearly, according to the description, gmass should be fetching 100 and removing 50, but it still thinks that I’m sending 100 “new”.

    So in this case, do I need to remove the first 50 from the day 1? But if I do this, won’t the auto followup break?

      1. I’m trying to understand this. So, the 50 limit on the free tier is not only a limit of the number of emails that GMass will send per day but also a limit of the number of emails it will read from a spreadsheet, even if many of those addresses have already been sent emails?

        1. Hi Scott,

          Yes, since your connected spreadsheet’s list of emails would be added to the TO field at the time a campaign’s batch is scheduled, if that number exceeds the 50 emails sending limit, then GMass will prompt you to subscribe. You would need to break down your list to separate sheets containing no more than 50 rows.

          1. This is really stupid. You should be able to add more emails to the same sheet without it getting confused. Please tell me it was fixed?

          2. Not sure what you mean but this is part of the FREE version’s usage limit. This is the limitation we’ve implemented on our free version. If you would like to lift this limit and have a sheet that you can add onto indefinitely then you would need to subscribe to one of our paid plans.

  17. not that im on the free plan b/c i read that i should “slowly” increase outgoing emails on gsuite.. so until i am bumped up to non-free trial of gsuite, im just testing with free gmass

  18. Do you mind sharing the details on how you house your data in a SQL Server database, and use Zapier to push data from SQL Server into a Google Sheets spreadsheet daily?
    Is this something that I need to hire a developer for?


  19. I have static list of 10,000 addresses, to whom i want to send a 3 email follow up campaign. For various reasons I simply want to work my way down the list, kicking off 500 per day. How can i set up gmass to “work down the list” a little at a time?

  20. Hi, does this feature work with your advanced feature: Send as Replies?
    If I send out one email with Gmass and set it to repeat once a day, and then subsequently send out a second email where I select the advanced feature Send as Replies AND set it to repeat once a day, what will happen when I add new email addresses to the spreadsheet?
    Will the new email addresses get both the first AND the second email? Will they get both emails in a single thread? When will the two emails go out?

Leave a Reply

Your email address will not be published. Required fields are marked *

Try GMass today

It only takes 30 seconds to install it!

Install Now GMass requires Chrome
Share This