{"id":3217,"date":"2018-07-10T21:47:28","date_gmt":"2018-07-10T21:47:28","guid":{"rendered":"https:\/\/www.gmass.co\/blog\/?p=3217"},"modified":"2020-12-29T20:16:15","modified_gmt":"2020-12-29T20:16:15","slug":"send-emails-different-people-different-days","status":"publish","type":"post","link":"https:\/\/www.gmass.co\/blog\/send-emails-different-people-different-days\/","title":{"rendered":"How to send emails to different people on different days"},"content":{"rendered":"

\"\"Using a combination of\u00a0Gmail<\/strong>,\u00a0Google Sheets<\/strong>, and\u00a0GMass<\/strong>, you can easily email different people on different days. In the\u00a0Google Sheets\u00a0<\/strong>spreadsheet containing your email addresses, you simply need a\u00a0Date<\/strong>\u00a0column that includes the date on which you\u2019d like that particular email sent.<\/p>\n

Overview<\/h3>\n

The basic steps to send automatic emails on specific days in Gmail are:<\/p>\n

    \n
  1. Set up a\u00a0Google Sheets<\/strong>\u00a0spreadsheet containing email addresses and the dates to be sent.<\/li>\n
  2. Use\u00a0GMass<\/strong> to connect to the spreadsheet with a\u00a0specific filter criterion<\/a>.<\/li>\n
  3. Compose the campaign.<\/li>\n
  4. Set it to\u00a0repeat daily<\/a>.<\/li>\n
  5. Send it out!<\/li>\n<\/ol>\n

    Set\u00a0up your spreadsheet<\/h3>\n

    Your spreadsheet can contain any number of columns to personalize your emails, but for date-based sending, it needs to include\u00a0a column for the email addresses<\/strong>\u00a0and the EmailSendDate<\/strong>, for when you want each email sent out. That date can be anything that pertains to your use case (see Other Use Cases below after the example).<\/p>\n

    \"Customer<\/a>
    Customer contact spreadsheet showing dates on which emails are to be sent out.<\/figcaption><\/figure>\n

    Above is our sample spreadsheet containing a list of people and the corresponding EmailSendDates<\/strong>. Note that the\u00a0dates can be in any valid date format.\u00a0In the example above, I am showing a number of different dates, with or without the year information, and using different formatting, just to show the flexibility. In your actual spreadsheet, you would probably stick to a standard format.<\/p>\n

    In what format should the date be?<\/strong>\u00a0For this example, your date column can contain dates with years or without years, and they can be in any recognizable U.S.-based date format<\/strong>. For a date of January 15, 2019 for example, the spreadsheet cell can contain \u201c1\/15\/19\u201d, \u201c1\/15\/2019\u201d, \u201c01\/15\/19\u201d, \u201cJanuary 15, 2019\u201d. It should not<\/em> contain, however, the European date format of \u201c15\/1\/19\u201d.<\/p>\n

    If you are sending something out on an annual basis on that date, and therefore the year does not matter, you can leave years off of the date. For example, \u201c1\/15\u201d and\u00a0\u201cJanuary 15\u201d would be acceptable date values. In this example, that is the approach I will follow (see the\u00a0last example in Other Uses Cases\u00a0below if you do need the year information to be used).<\/p>\n

    Set\u00a0up the filter criterion in GMass<\/h3>\n

    Click the\u00a0GMass spreadsheet icon<\/strong><\/p>\n

    \"GMass<\/a>
    GMass spreadsheet button, found at the top of Gmail page.<\/figcaption><\/figure>\n

    and choose the\u00a0spreadsheet<\/strong>\u00a0and\u00a0worksheet<\/strong>\u00a0that you just set up. Because we don\u2019t want to send an email to everyone on the spreadsheet at once, we need to specify a filter criterion so that emails only go out when the current date matches the date in the\u00a0EmailSendDate\u00a0<\/strong>column.<\/p>\n

    \"Choosing<\/a>
    Choosing the spreadsheet and applying the filter.<\/figcaption><\/figure>\n

    The filter criterion is based on the \u201cEmailSendDate\u201d column in the spreadsheet. We want to match rows where the EmailSendDate is equal to the current date. In this example, we are going to do it without regard to the year of the EmailSendDate.<\/p>\n

    Once you\u2019ve inputted the filter criterion, click the\u00a0CONNECT TO SPREADSHEET<\/strong>\u00a0button to continue.<\/p>\n

    Note:<\/strong>\u00a0If it\u2019s no recipient has an EmailSendDate that matches today, then the Gmail Compose window will launch with an alias address in the To field representing 0 addresses. That is normal (and is shown in the next screenshot). It just means that right now, 0 emails will be sent. Since you\u2019re going to set up the campaign to repeat daily, it will check to see if anyone has an EmailSendDate on each day the campaign runs, and send out the ones that do.<\/em><\/p>\n

    Set up the mail merge<\/h3>\n

    A\u00a0Compose<\/strong>\u00a0window in Gmail<\/strong> should have launched where you can enter the\u00a0Subject<\/strong>\u00a0and the\u00a0Message\u00a0<\/strong>for the email. Here I\u2019ve personalized the\u00a0Message<\/strong>\u00a0with the first name.<\/p>\n

    \"The<\/a>
    The outgoing email.<\/figcaption><\/figure>\n

    Again, don\u2019t be alarmed by the alias address representing 0 recipients. That\u2019s just because it happens that today’s date does not match any of the recipients’ EmailSendDate. If any had matched, they would be shown in the To: field.<\/strong><\/p>\n

    Now, in order to get this email to send every day to just the\u00a0recipients whose EmailSendDate<\/strong> is that day, you must check the\u00a0Repeat daily<\/strong>\u00a0checkbox, which is found in the GMass Settings window.<\/strong><\/p>\n

    \"Checking<\/a>
    Checking the “repeat daily” checkbox in GMass Settings.<\/figcaption><\/figure>\n

    Setting this to \u201cRepeat daily to new Sheets addresses\u201d will cause GMass<\/strong> to query the spreadsheet daily to see what email addresses match the filter criterion. Without this setting, the email would send today to anyone whose EmailSendDate is today–and then would just stop.<\/p>\n

    Instead, this setting will tell GMass<\/strong> to:<\/p>\n

      \n
    1. Query the spreadsheet daily for rows where the current date is equal to the EmailSendDate<\/b>.<\/li>\n
    2. Send an email to just those people.<\/li>\n<\/ol>\n

      Bonus: You can keep adding rows to your spreadsheet, even after the campaign has started.<\/h3>\n

      You can add more rows to your spreadsheet anytime you wish, and GMass<\/strong> will automatically pick up the new email addresses and dates. You don\u2019t need to edit your GMass<\/strong> campaign. Just add the new data to the spreadsheet and GMass <\/strong>will detect them and send the emails accordingly on the daily schedule you\u2019ve already set.<\/p>\n

      Other Use Cases<\/h3>\n

      This is a general pattern that works for a number of use cases, either in business or your personal life.<\/p>\n