Sending individual emails on a mass scale is an important task for almost any business. You can send personalized information to multiple recipients at the same time. For example, you may want to send marketing emails based on individual user behavior in your product, send e-commerce emails based on buyer behavior, or even send birthday emails to your employees within your own company. Whatever it is, doing this manually is a highly inefficient process. Automating this instead could save you multiple hours that you can use to focus on more important tasks within your business operations.
In this article, let’s explore the importance of automating sending individual emails on a mass scale and how you can do this using the Sheetgo web app.
Why send emails to multiple recipients individually?
Sending individual emails on a mass scale allows you to get the best of both worlds. You can take the personalization of individual emailing and pair it with the speed of mass emailing to create the ultimate process.
Here are just some other reasons why you should send emails to multiple recipients individually:
- Send personalized data: Customize each email to the recipient by including individual data. This can be anything from their account details, order details, or financial data. You can communicate with hundreds of recipients simultaneously while keeping their data private.
- Increase conversions: When users see a generic mass email, they’re very unlikely to open it. Creating individual emails on a mass scale that include personalized touches such as their name can dramatically increase your conversion rate.
Let’s take a look at what Sheetgo has to offer.
Why use mail merge by Sheetgo?
Google does offer a multi-send feature for Gmail in order for users to send multiple emails at once for email marketing, announcements, and newsletters. Although any Google Account can access this feature and create its own mailing lists, it does have a few limitations.
The main limitations of Google’s multi-send feature include:
- Unable to send individual custom messages: Google does not offer a solution to create personalized messages for individual recipients. You can only send the exact same email content to your list of contacts.
- 1500 send limit: You can only send up to 1,500 emails to recipients per day using the multi-send feature, compared to the 2,000 limit for regular emails from a work account.
- Manual input: Users still need to manually input their recipient email addresses into Gmail in order to send out the emails.
Sheetgo is a simple, affordable alternative that will enable you to send individual emails all at once. What’s more, Sheetgo automates this entire process for you. Once you set up your workflow, you can sit back and relax while Sheetgo does the work for you.
- Automated from start to finish: Sheetgo will handle the email generation and delivery process from beginning to end. Every email is sent automatically so that you can avoid any manual effort.
- Send data straight from a spreadsheet: Send hundreds of emails in a matter of minutes from a simple spreadsheet. Just add the data related to your email content, create your email content, and Sheetgo handles the rest.
- Customize with Sheetgo Tags: Personalize every single email using Sheetgo Tags. You can use these when creating your email content, and Sheetgo will substitute the tag with the dynamic data in your spreadsheet. You can use tags for names, dates, contact details, identification, etc.
- Gmail integration: Sheetgo’s Gmail integration means that you can send emails directly through your Gmail account whilst experiencing all of the intelligent features the Sheetgo web app offers.
- Schedule automatic updates: Create a self-sufficient workflow by scheduling automatic updates. Sheetgo will automatically generate and send an email whenever new data is added to your spreadsheet. You don’t even need to open up your files!
- Avoid double-sending emails: The Check email recipients setting by Sheetgo means that you can avoid double-sending emails after the workflow updates.
How to send an email to multiple recipients individually
In order to see how to send an email to multiple recipients individually using Sheetgo, let’s start with a use case.
Let’s say I am part of the marketing team for an e-commerce company. I have a spreadsheet containing all customer data, including their name, email, and the URL of where they were last on the e-commerce site.
Using Sheetgo, I can filter out the users who were last on the checkout page, then create an email template that will transfer individual data from the spreadsheet to create a personalized email to each individual.
As a result, each customer last on the checkout page will receive a personalized email with their data and a URL to take them back to checkout.
Step 1: Sign up to Sheetgo
Signing up to Sheetgo is easy – simply use your Google, Microsoft, or Dropbox account to get started.
Step 2: Prepare your spreadsheet
Ensure your data is within your spreadsheet. You must include any dynamic data you wish to add to your emails. The header will be the smart tag you will use to personalize email content.
In this example, I have a spreadsheet with all the columns of data I need, including the customer name, email address, and last seen URL.
Step 3: Upload your source file
Now it’s time to begin creating your workflow.
In your workspace on the Sheetgo web app, click +New workflow, then choose to Create connection to build a custom workflow.
Search for and select your spreadsheet file in the corresponding cloud storage account located on the left-hand side of the pop-up.
Step 4: [Optional] Filter data
You can choose to filter your data if you need to. Here, as I only want to email the customers who were last seen on the checkout page, I can use the Filter feature by Sheetgo to filter my data accordingly.
Under Process, click Filter > Condition
- Column: Column F: Last seen URL
- Criteria: Text contains
- Value: /checkout
When finished, click Next.
Step 5: Generate email
Now it’s time to begin generating the emails.
Under Generate, click Email.
Step 6: Add email addresses
Under the section Email addresses, you can choose options to either add the recipients’ email addresses manually or allow Sheetgo to transfer email addresses from your spreadsheet file automatically.
Use custom recipients
Select the Use custom recipients option and manually enter the email addresses of those to who you wish to send your email to.
Note that this option works best if you want to send the same bulk email to multiple recipients.
Get dynamically from column
Select the Get dynamically from column option and select the column within your spreadsheet from the dropdown menu that contains all of the email addresses.
In this case, I select column C.
Step 7: Create custom email content
Now it’s time to create your email content. Firstly, type out the content you want every email to have. Then, add the Sheetgo tags to introduce dynamic data into your emails – this will change for every email depending on the row of data.
As you will be able to see, Sheetgo automatically turns your column headers into smart tags. Simply click on one of these tags to add it to your content.
I have now created my email content using the smart tags as you can see below. I can even add a smart tag to the action button to navigate each recipient to their respective checkout page!
This means that whenever you run or schedule updates for your workflow, Sheetgo will never re-send an email already received.
Step 8: Schedule automatic updates
You can schedule automatic updates for your workflow so that Sheetgo will continue to send individual emails whenever a new row of data is added to the spreadsheet.
In Workflow, click on the Automate button located in the bottom right-hand corner of the screen, choose your schedule and click Save.
How to send personalized mass emails in Gmail
And there you have it! Now that your workflow is complete, you have successfully delivered emails to multiple recipients individually.
Any of my customers who were last on the checkout page will now receive an email like this:
Alternatively, take a look at some of the related posts below!