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. Read the authorization notice and. Yellowwebmonkey has the solution for you. Create an apps script to read data from your sheet perform a mail merge and send out emails. Instead of wasting time creating a google apps script to build a mail merge template you can use gmass to send emails in seconds. Alternatively you can download the right inbox extension that will allow you to do a mail merge within gmail.
Step 1 formatting your spreadsheet. You ll need to head over here and make a copy of the gmail google sheets mail merge spreadsheet template. How to send a mail merge with google sheets in gmass. A dialog box will appear and tell you that the script requires authorization. Autocrat makes it easy to merge data from google sheets into google docs or into a pdf.
Run your script to send emails. In the copied spreadsheet click on custom menu item mail merge send emails.