How To Use Google Sheets Mail Merge

Create a sheet called data containing information to personalize the email create a sheet called data that contains the necessary information to populate the placeholders in the email template.
How to use google sheets mail merge. Yellowwebmonkey has the solution for you. How to send a mail merge with google sheets in gmass. Instead of wasting time creating a google apps script to build a mail merge template you can use gmass to send emails in seconds. Read the authorization notice and. Step 1 formatting your spreadsheet.
Run your script to send emails. Create an apps script to read data from your sheet perform a mail merge and send out emails. Here s a walkthrough guide on how to send a mail merge with google sheets in gmass. A dialog box will appear and tell you that the script requires authorization. A mail merge is an extremely useful tool for personalizing forms or emails for many individuals at once.
You can set up a mail merge using google drive and an add on called autocrat. Alternatively you can download the right inbox extension that will allow you to do a mail merge within gmail.