How to Send Customized Bulk Emails with Mail Merge in Google Sheets and Gmail

Send personalized bulk emails using Mail Merge in Google Sheets and Gmail. I'll go through the step-by-step process of setting up Mail Merge and sending out messages from your list in Google Sheets. You create a Gmail draft template with placeholders that correspond to data in a Google Sheets spreadsheet.

0:00 Introduction
1:00 Make of copy of Google Sheets with Mail Merge
1:38 Customize your fields (columns) in Google Sheets
4:30 Create your draft email in Gmail with field names
8:55 Initialize and Run Mail Merge from Google Sheets
12:20 Quota for Google Services

[andreamorgan]

You are an angle sent from heaven! Thank you so much ! I love your videos 🤍🤍🤍

[ikanngg]

Ive been manually doing emails with their name with a macro pullover and its kinda hard for me. Thank you for this! You save my life. 😊

[ItsNarwhalPlaysMC]

Thank you so much for this. Literally saved me so much time. Super easy and customizable!

[alvansam]

Thank you so much for your teaching style. I appreciated that.

[TilakConrad]

Superb as always - congratulations on a great teaching style and production - thank you

[patriciashawwatkins]

Thank you! Your presentation solved my problem, just in time.👏

[usdnqfk]

Thank you for the informative discussion. This is helpful.

[walterharley]

Outstanding! I will create one to use. Thanks.

[webpromo]

Can you set this up so there is a column for Attachments (referenced in Google Drive) so that each dynamic email has a file attachment as listed in the Attachments column?

[RefereeDepartmentMFF]

Hello, thank you for share it. I have question. It didn't work properly when I added extra column in the sheets. Please could you fix it?

[gvgfdce]

How to add cc, bcc in the mail? Also is there a way to follow up automatically by scheduling the email or we have do it manually?

[alexanderhill-cpbe]

FYI: I dont know if the script has changed since this video was made. But you no longer need to add the {{Recipient}} template string into the "To" field as the script code already takes the {{Recipient}} column fields and saves to an Array Variable to handle this. So you can leave the "To" in the email blank and it will still work.

[dilhanmaduranga]

Could you please tell me how many total emails, can i send in a single time? because I need to send bulk emails with different attachments.

[ictdirector]

Hi, the placeholder does not work in the subject and body of the email but the email is delivered anyway. Any help? Thank you

[laiyungcheung]

Hi, thank you so much for your tutorial. I am using a domain email which already connected to gmail. May I ask that is this mail merge enable to send bulk emails which using the domain email as the "sender"? Because there seems no choice for the senders, but I need to send the emails by the domain email. thanks so much!

[kingconnor]

thank you soooo much working confirmed, can i change sender name?

[ochin]

hey, how we can attach customized pdf like workshop certificates to each participant.

[Orvillerede]

Is there a way to get the script or the mail merge tab up to to save in the excel sheet permanently?? Every time I close out of the tab and come back later that day or the next day, I have to redo making the copy again and then copy and pasting the data into it again

[MarketUS]

great tip. even though I am in my one account, the copy saves it in my other account. how do I force it to my first account. thanks.

[krystalnolen]

when i do this I copies and pasted a google sheet i had already made into this format and whenever i did the merge it says failed to send "no recipient" any help??