Gmail mass email tips: Avoid the spammy look with the personalized touch:
Gmail contact groups are great for sending a single email message to a specific set of people, but what if you want to give each email a personal touch, such as with a newsletter or promotional offer? Unlike Microsoft Office, Google’s productivity suite doesn’t have a native mail-merge feature you can leverage to do this. But don’t sweat it: With a little help from Google Sheets and a free downloadable script, you can personalize bulk email messages in Gmail in minutes.
Just remember, Google allows you to send only 100 emails per day using scripts. Here’s how to get started.
1. Create a spreadsheet
Log into your Google Drive account. On left sidebar, click New > Google Sheets to create a spreadsheet. You’ll be importing your email recipients’ contact information here, so give it a descriptive name.
Next, go to the menu bar and select Add-ons > Get add-ons. This takes you to Google’s add-on store. In the search window, type a name for your mail merge script—for this example, we’ll use
Yet Another Mail Merge—and hit Enter.
This is a public mail merge script. Click the Free button, and a window will open, asking for various permissions to access Google Sheets, Contacts, and Gmail. Click Accept. A window will pop up under Add-ons on the menu bar, indicating that the script has been installed. Click the X to close it.
2. Import your contacts
The next step is to import your email recipients into the spreadsheet. Click Add-ons > Yet Another Mail Merge > Import contacts from a group. A small window will open with a drop-down menu of all the contact groups in your Gmail account. You can also go into Gmail, and create a new group with all the contacts you want to include in your mail merge. Then repeat the steps above and select this group from the drop-down menu. Click Import contacts, and those contacts will populate your spreadsheet.