#MAIL MERGE GOOGLE HOW TO#

Gmass automatically opens the composer and adds a speacial email address in the “to” field. Choose your spreadsheet from the list and click “Connect” 4. Connect Gmass to your spreadsheetīack in Gmail, click the spreadsheet icon next to your search bar. Set up your Google sheetĬreate columns for the email address, and then any columns you want to use in the mail merge. Follow the process to connect your Google account. If you don’t automatically get prompted to create your account, click any of the Gmass buttons that appear near your search bar. Click here to get your free account.Ĭlick the “Add to Gmail” in the top right hand corner.įollow the prompts to install the Extension. To get Gmass Pro for only $16 per month, click here.

It’s highly recommended, and if you need to send more than 50 a day, I’ve organized a special deal with the founder. It’s the easiest of all the tools in this post. Gmass is a paid tool, but you can send up to 50 emails per day for free. Because who still uses paper and cardboard? I’ve also used this in my personal life to send out wedding invitations. That’s not something I want them to think. If it comes from my email list and there is an unsubscribe in the footer and all that, it will clearly look like I’ve added them to an email list. But there are a lot of other situations when this is perfectly legitimate.įor my business, I’ve used this when I am working with several partners and I don’t want to add them to my email list just to send them a message. If you’re watching this and want to spam people, you suck. All are available for free, but the extensions are limited in volume. Two methods use a Chrome extension, and one uses a script. You’ll learn 3 different, very simple tools to do that and the exact process to using both.

#MAIL MERGE GOOGLE HOW TO#

Today you’ll learn how to send bulk email from Gmail using Google Sheets.

This is where this Gmail mail merge tutorial comes in. Sometimes you might need to send the same email to a bunch of people.

Mail merge google