How to Send Bulk Emails in Gmail From Google Sheets

Rate this post
How to Send Bulk Emails in Gmail From Google Sheets

Sending one email at a time to a list of contacts might take up a significant portion of your day if you want to customize them. If this sort of advertising is wasting your time, it may not be worth monitoring.

All you need is a contact list, Google Sheets, and Gmail to send hundreds of customised emails to your contacts at once with the Yet Another Mail Merge add-on for Google Sheets.

Download Yet Another Mail Merge

With up to 50 free emails you may send utilizing Yet Another Mail Merge (YAMM), your first step is to download the program from their website.

  1. Go to the YAMM website and choose the Get Started For Free option.
  2. Click the Install button
  3. Click on Continue
  4. Select the Google account that will be used.
  5. Allow YAMM access to your account by clicking Allow.
  6. Click Done

Once you’ve installed YAMM in Google Sheets, you may use it at any time by selecting Add-ons from the menu after opening a new sheet.

Create Your Google Sheet and Email Draft

To set up bulk emailing, you’ll need to build a Google Sheet with the contact information for everyone you want to contact.

In addition to establishing an email template, you must also create a sheet template so that when you combine the sheet and email, your contacts will immediately sync.

Free Newsletter Templates That You Can Print or Email as PDF

Depending on whether you already have a Google contact list, there are two methods to input your contacts into your Google Sheet.

  How to Recall a Sent Email in Outlook

Sending Bulk Emails From Scratch

  1. Create a new Blank document in Google Sheets.
  2. Insert the column headers for your bulk emails, such as email address and first name. Row 1 must always include these.
  3. Complete your Sheet with all of the necessary information.
  4. Compose a new email in your Gmail inbox.
  5. Fill in the blanks with.. for each characteristic in your prepared email. Check that your characteristics match the column headings in your Google Sheet.
  6. Close the draft email.
  7. Go to your Google Sheet and click the Add-ons menu option.
  8. Choose Yet Another Mail Merge (YAMM) > Launch Mail Merge
  9. Fill up your sender name and choose the draft email that has your qualities.
  10. Check the Track email opened, clicked, or bounced box.
  11. Select the Send a test email option.
  12. Check your inbox to check that your email was sent successfully.
  13. Click the Send Emails button on your Google Sheet.

Your emails will have been sent to everyone on your contact list that you uploaded to the Google Sheet.

As in the previous step, create a draft email. Instead than manually entering all of your contacts into a Google Sheet, you’ll import them from an existing list.

  1. Create a new Blank document in Google Sheets.
  2. Select the Add-ons option from the top menu.
  3. Import Contacts from Yet Another Mail Merge (YAMM) (Google, Salesforce).
  4. Choose the contact list you want to import.
  5. Alternatively, use the dropdown to pick a particular contact list.
  6. Select the Import Contacts option.
  7. Start Mail Merge and proceed with steps 9-13 from the previous list.
  Have You Been Hit by the Coinbase Email Scam?

Although you must prepare your list ahead of time, you will save a significant amount of time over manually inputting all of your data into your spreadsheet.

Track Your Data

After you’ve sent your bulk emails, you may return to the campaign’s spreadsheet to see the campaign data.

When you open the sheet, you’ll see a popup sidebar on the right-hand view that shows all of your campaign’s information.

Emails that are opened, clicked, replied to, bounced, or unsubscribed are included. You’ll also notice a Merge Status column header, which lists all of the metrics next to each individual email address.

It will also be color-coded so that certain email addresses in your campaign may be readily identified. The sidebar only counts emails sent in the last 10 days, so you’ll have to manually track your whole campaign to learn more.

If you accidentally closed the sidebar, go to the menu choice Yet Another Mail Merge > Open tracking report.

This will reopen the sidebar and allow you to access all data once again.

YAMM Pricing

The first 50 emails sent using YAMM are completely free. However, if you want to launch a larger campaign or have a large workplace where numerous emails must be sent at once, you will need to upgrade to a larger plan.

YAMM offers three price options: Personal, Team, and Unlimited.


The Personal plan includes two cost choices depending on whether you have a conventional Gmail address or a Google Workspace account. The standard Gmail account costs $20 per year and includes up to 400 recipients per day with one user access.

  How to Archive Emails in Outlook

The Workspace account is $40 per year and contains up to 1500 recipients each day with a single user.


If you have a Google Workspace domain, YAMM will charge you based on the number of team members you need. Plans vary from 5 to 100 people and cost between $100 and $2,000. Every plan allows for up to 1500 receivers per day per user.


Companies with more than 100 users will not be able to buy online, but you may still contact YAMM for a tailored quotation based on the number of users you need.

You may potentially add as many users as you like, and each user will get up to 1500 receivers each day with all capabilities enabled.

Sending Bulk Emails With YAMM

You may save time by batching your emails together with further customization for improved open rates using Yet Another Mail Merge. Make sure you have a mailing list of contacts set up in your Gsuite for the best results. It may also be used to send workplace emails to ensure that everyone gets the acknowledgement.

You are looking for information, articles, knowledge about the topic How to Send Bulk Emails in Gmail From Google Sheets on internet, you do not find the information you need! Here are the best content compiled and compiled by the team, along with other related topics such as: Email.

Similar Posts