Gmail Mail Merge: Send Personalized Emails in Minutes

Tired of manually sending the same email over and over? Google Mail Merge is here to save the day! Learn how to send personalized emails in minutes using Google Sheets and Gmail's built-in mail merge feature. We'll cover:

Setting up your Google Sheet
Creating your Gmail draft
Integrating mail merge tags
Sending your personalized emails

0:00 Introduction
0:46 Personalize your emails with mail merge
3:07 Using Google Sheets to mail merge with Gmail

[jameshelms]

Excellent video! Do you have a video showing how to clean out large amounts of emails, and also how to create folders inside an inbox that emails will automatically drop into?

[pedigoj]

This was very helpful! thank you. The only thing I appear to have an issue with is the preview function; how do I properly use it so that I can see all my merges before I hit send?

[accountfocus-mz]

Perhaps it should be said in the first 10 seconds of the video that this only works for paid accounts? Just a thought.

[kildarecareers]

Love the video. Thank you. Two quick questions. 1. Is there a way to select recipients rather than it going to everyone in that Google Sheet? 2. Is there a way to save the email (I currently just copy it from a Google Doc) as I will be sending the same email on a regular basis. Thanks again. I learn so much from all of your videos

[billyhestand]

Why am I not seeing the icon you are clicking on with the two people and the plus sign?

[kotinienterprise]

Hi there, great video! Question: on your example at 6:05 the email address on the send email corresponds to the name Kathy Williams from the spreadsheet and not Drew. Can I mail merge mine in an offline mode so I can review them from drafts before sending them? Thank you

[AdrianGarcia-zl]

I have a paid business - google workspace account and i do not have the mail merge option. Do I need a specific workspace tier for this feature?

[DJ-ndxi]

Would love to see HOW to cc names from a column on my google sheet. I see your note at the end but there's no "how to."

[kellythomas]

Are you able to include attachments/images to the mail merge? Not just the link to an attachment, but embed the image in the email. Thanks!

[DavidKoon-zovm]

Thanks but it cannot do cc. For example, it will be great to copy a support person for each email sent.

[workspacetherapist]

So each recipient receives a separate email then? It’s not like a mass email where they will see everyone on the list right? They only see it was sent to them?

[ArijanaMB]

I dont have the option to mail merge when I open an email in order to send it. How and where do I find this, or enable this? I have tried and looked everywhere. Please help! Thank you.

[ElizabethRussell-rm]

Any knowledge of whether the fully customizable merge fields are available when using a template layout in Gmail (within a Google Nonprofit account)? I'm only seeing a limited list of merge field options and if you type @ in the body of the email, it doesn't produce the list of fully customizable fields. Thx for any guidance!

[dailygrow]

I can't find just Cc and Bcc not mail merge Even i have Google workspace how can I find or set kindly help me.

[Belowtheradar]

I created a label in google contacts, division 1 basketball coaches. I have 300 coaches contacts names saved and under each of those coaches contacts I have three assistant coaches names and emails but when I sent out an email to that label only the head coach receives the email and not their assistant coaches. so how can I make sure that everyone under that one contact name will receive the email.

[rajeevraghavan]

Is there anyway I can CC and BCC more than one email? For me it is showing only one email is allowed per cc and bcc.

[dababydagoat]

Hi, I have my Gmail appearing as a email different address, but when I use this Mail Merger, the emails send through as my original Gmail account. How do I make it send the emails as the other Address???

[DanielChavez-fmvh]

When I used this, my profile picture does not get displayed to the recipient. Is there a way around this?

[mkry]

is there any way to personalize the subject line too?

[gabbagool]

Can I put more then one email address in each cell on the spread sheet?