Create a mail merge using Gmail and Google Sheets

Everything you need to get anything done, now in one place: introducing Google Workspace, formerly known as G Suite.

Whether you are in sales, marketing, education, project management, data analysis, etc., it’s common for people to want to send emails to multiple recipients with information that is customized to each. In this episode, learn about Martin Hawksey's mail merge solution, which helps anyone send emails with customized content from a Google spreadsheet, and Gmail.

Product: Cloud G Suite Development, Sheets, Gmail, Apps Script; fullname: AGV, Martin Hawksey;

#GoogleWorkspace
#SheetsToApps
#CustomizingGoogleWorkspace

[edwardpovey]

Hi all, a really useful tip. When drafting your email, make sure you've changed to plain text mode, otherwise the {{}} tags in the body of your email won't get read by the script and will appear blank when you hit send. Like me, if you want your email to have a fancy footer and some nice fonts, you can copy and paste your plain text email body into a new draft in normal mode. As long as the {{}} tags are in plain text the script will read them and the merge will work. It's basically taken me about a day to work this out, in which time I could have written all the emails I needed to send out by hand!

[GreenTea]

Very frustrated that Google included a template spreadsheet with a script that has not been verified by Google. They don't mention this being a typical step in the process or let us know that this sheet script was developed by Google or even how to verify that it is sound and sanctioned by Google. Has anyone gone ahead and continued through verification and allowing it to view your contacts? Was it fine? Did you mail merge work?

[lafamillecarrington]

So easy and worked like a charm. Love the idea that it links to a draft email rather than having to create the whole email content within the script.

[MrNTTech]

Do not copy cell names from Sheets. I had the same issue that many were complaining about. If you copy to notepad, and then copy to your draft, it has worked 100% of the time for me.

[wdrdzuh]

yeah... it does't work and I don't know why.
It says "end line too short"
I googled it and nothing came up.
Any idea would be extremely appreciated.

[trztmqh]

"Mail Merge" isn't an option in the Google Sheet. Something in these instructions, both video format and text is missing a key piece of information.. HOW do we get, "Mail Merge" option on Google Sheets?

[znvqglh]

I have never come across such a soft and polite American !! i went ahead and heard her 3 times !!. Nice who ever she is .

[DarthMan]

It worked! It really actually worked!!! BTW to get past the warning, not verified, you must click the "Advanced" hyperlink and then the next hyperlink with the "(Unsafe)" option beside. Then you must click on the allowance to let the script touch . You can change 3rd party access later too under settings.

[cherielwell]

I can't get around a warning that pops that this is not a verified app. and the screen where I put in the draft subject line never comes up. Very Frustrted. HELP.

[lhuang]

The First name won't show on the mail, how to solve this issue?

[sarnathchari]

where can I find the mail merge button? not showing up on my google sheets

[anto]

there is no mail merge option in the spread sheet

[deannaloehle]

Help. For some reason the fields aren't being filled in. I have made sure that the columns and fields are titled the same and used {{}} with no extra spaces. It generates and sends the email but with blanks where tge fields were.

[komalkumarshah]

Where is the link to access Google Sheets for Mail Merge ?

[TheFartanSpartan]

maybe im just a novice, but when i tried to do the mail merge, it said that Google has yet to verify it and that it may be unsafe. How can that be if they made a video about it and it is on their site gallery?

[dennisphillips]

I don't get the "mail merge" option in the Sheet.

[mrcobram]

When I click on "mail merge" in the xls file, it says "authorisation required, a script attached to this document needs your permission to run". If I click on "continue" I received a message saying "this app isn't verified". How can I solve this?

[mls]

Does anyone else get a warning from Google saying this app has not been verified?

[MrFurano]

Can Google please increase the Email quota? The current quota is too low.

[ricardobrito]

Thanks to every employees of Google sheets. It helps me a lot.